Form Change Flag?

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

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

Hi Bob

I didn't. Any good adding those fields to the tables manually?
Nick

Thanks Sloan - I shall give it a whirl.

Regards
Nick

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

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

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

Ah. Yes, I see. Not techniques that I have used - about time to learn.
Thanks for the the detailed tips Sloane. I will get to it and see how I go.

Thanks again.

Nick