HI, I have a guest list for an event and want only the last /recent entered values to remain. Unique identifier is guest name guest code as F1,F2,F3,F4,F5.
Suppose guest F2 again enters the form after 10 days with new arrival date and departure date - then he previous entry one should be hidden from my sheet and only this be considered in all rollups/lookups/linking.formula etc.
I shall calculate rooms required, catering etc when guests enter arrival/departure/no.of persons etc. data using a form
When there are two entries in the form for same guest, say F2 - I want the Last modified time to be picked up /maybe in a different view and the first one should be hidden and out of my calculations.
Effectively- Duplicates in the same column (F2, F2) need to be removed and only the value (F2) with last modified time should remain.
With this feature- I allow guests to change their plan/date/no.of persons requirement in future by entering their guest code.