I am trying to integrate a ‘Newly Added’ inline list for businesses that filled out a submission form in the last week or so. Forms are submitted via Google Forms. I was thinking of using the timestamp for this, but when a business is updated, the time stamp changes, so this won’t work as businesses update their information, as they are not really ‘new’. Anyone knows how I can make it so, the inline list would only capture the first timestamp that is inputted for a specific row, and not the ones after that.
You could have separate date columns to capture the date the first time the row is added in one column and any edits in another date column. That way the first date column is only touched when adding a row.
That approach, if I take it right, is based on one business having multiple rows (the approach looks like it’s assuming an edit will create a new row). Seems like not the case?