Hi Bob,
I have a form that lists several records from a database. I then have a form to edit some data read from the database for a record selected from that list. I want to mark the record - by a symbol or colour - in that original list of records to show that the data for that selected record has been changed. Is there a flag somewhere that indicates some data, any data has been changed? I don't want to know what has been changed, just if some data has been changed.
Regards
Nick
I have a form that lists several records from a database. I then have a form to edit some data read from the database for a record selected from that list. I want to mark the record - by a symbol or colour - in that original list of records to show that the data for that selected record has been changed. Is there a flag somewhere that indicates some data, any data has been changed? I don't want to know what has been changed, just if some data has been changed.
Regards
Nick
Hi Nick,
If you created the table in ChronoForms it will have cf_modified and cf_modified_by columns that you could check. They are blank in a new record and updated in a changed one.
Bob
If you created the table in ChronoForms it will have cf_modified and cf_modified_by columns that you could check. They are blank in a new record and updated in a changed one.
Bob
Hi Nick,
The 'modified' columns should work as long as you add columns with the exact names that ChronoForms uses.
Personally, I'd probably do something like Sloan's suggestion and add a status column to the record that can be checked and changed as needed - more flexible but a bit more work too.
Bob
The 'modified' columns should work as long as you add columns with the exact names that ChronoForms uses.
Personally, I'd probably do something like Sloan's suggestion and add a status column to the record that can be checked and changed as needed - more flexible but a bit more work too.
Bob
Hi Bob,
That makes sense but I am a bit concerned that, as I see it, these techniques would flag a record as changed even if the user made no changes but submitted the update anyway - rather than back out of the record or reset the record. Or at least that is as I understand the suggestion. I may have that wrong - time to try it and see I guess.
Thanks for the help
Nick
That makes sense but I am a bit concerned that, as I see it, these techniques would flag a record as changed even if the user made no changes but submitted the update anyway - rather than back out of the record or reset the record. Or at least that is as I understand the suggestion. I may have that wrong - time to try it and see I guess.
Thanks for the help
Nick
Hi Nick,
Well yes, if you need to know for sure that they changed it rather than just edited and submitted unchanged then you need to follow Sloan's route and compare the 'before' and 'after' data.
Bob
Well yes, if you need to know for sure that they changed it rather than just edited and submitted unchanged then you need to follow Sloan's route and compare the 'before' and 'after' data.
Bob
This topic is locked and no more replies can be posted.