I have a form and plan on having lots of submissions in the next few days.
I want to make it easier on the client so they know which submissions are brand new. Hypothetically when they wake up and check the chart when there are new records they’ve never seen, it says “new submission” or something similar.
Let me know. I was thinking of having a column with single select but unsure how to automatically trigger something that’s brand new.
You can have a single select that shows the state of a record. Note that you will also want a mechanism to move records out of that initial state. There is no way to automatically change the state of a single select (or any other field) based only on whether or not the record has been viewed. The user must change a field value, click a button or otherwise interact with the record.
Another option is to create a field based on when the record was created that says if the record was created in the last day, week, month, etc, then group records according to that formula field.
Also know that setting default values for fields does not work well for records created via a form.