Highlighting unchanged records after a merge update

Question

Is there a way to Highlight unchanged records after a merge update------------------------------Lang Maane------------------------------

markshnier__you · Answer

Yes they would disappear.&nbsp; I think you need to think through what you want.&nbsp; Like what would you expect to happen after the Next Merge update.&nbsp;&nbsp;Are these record also edited manually?&nbsp; ie does the [Date Modified] reflect the most recent [Date Modified] or are there also manual updates.&nbsp; If there are manual updates are they only done on forms or also on grid edit.I'm trying to think of ways to differentiate between Imports and manual updates.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

malangmaane · Answer

Basically After an update with new data, I want the records that have not changed to be flagged. I may need to create a new field to show "completed" for a record as unchanged….Any insights on how to accomplish this.------------------------------Lang Maane------------------------------

markshnier__you · Answer

You could have a flag or row colorization where the [Date Modified] is Today.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

malangmaane · Answer

Thought about that but what happens tomorrow when Date modified becomes yesterday......would the highlight disappear?

markshnier__you · Answer

OK, so thinking out loud. ... You run the update and note the current date and time.Then you enter that date / time into a field on an Admin record, and then push a URL Formula button.&nbsp; The button would run&nbsp; a table to table import of the records into themselves which would mass update any record where the date modified was before the last merge date time with a flag to indicate that it was not changed by the last merge.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Forum Discussion

Highlighting unchanged records after a merge update