Hello there everyone,
I have really been struggling with this and could really use some insight from the forum!
Any help appreciated.
I am trying to make a database that takes surveys from the same people on a yearly-biyearly basis.
I would like records sorted by “Current” or “Outdated”.
When a person fills out a record, the primary identifier is their (Name) + (Date Submitted).
I would like the same person to fill out the same survey later, and due to their (Name) being identical, make the older record “Outdated”, make the new record “Current”.
For a little more detail, IF Old Record’s (Name) = New Record’s (Name), then compare (Date Submitted) between the two. If the date of the old record is older, return (Current) = “Outdated”, else (Current) = “Current”.
This could also be a checkmark, so checkmark if “outdated”, empty if “current”!
What do you guys think, is this doable in Airtable?
Thanks in advance,