# Newly Added Inline List **URL:** \ **Category:** Ask for Help\ **Created:** [September 23, 2020, 5:18pm UTC](https://community.glideapps.com/t/newly-added-inline-list/16261 "2020-09-23T17:18:36Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [September 23, 2020, 5:18pm UTC](https://community.glideapps.com/t/newly-added-inline-list/16261/1 "2020-09-23T17:18:36Z")
Hi! 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. Thanks! ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [September 23, 2020, 5:46pm UTC](https://community.glideapps.com/t/newly-added-inline-list/16261/2 "2020-09-23T17:46:23Z")
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. ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [September 23, 2020, 8:23pm UTC](https://community.glideapps.com/t/newly-added-inline-list/16261/3 "2020-09-23T20:23:48Z")
How does that work? ---
**Author:** ![Roldy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/roldy/32/36068_2.png) [@Roldy](https://community.glideapps.com/u/Roldy)\ **Post date:** [September 24, 2020, 12:13am UTC](https://community.glideapps.com/t/newly-added-inline-list/16261/4 "2020-09-24T00:13:59Z")
Hi @Jen_NYCP You can solve adding a query in your google sheet. For example, assume that: A is the businesses column B is the date TEST is the named range The query is: =QUERY(TEST; “Select A, MIN(B) GROUP BY A”; 1) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [September 24, 2020, 1:05am UTC](https://community.glideapps.com/t/newly-added-inline-list/16261/5 "2020-09-24T01:05:04Z")
Have an “Added” column for when they first added to your data, captured via the datetime special value in the form. Then for any edits using the pencil button, point the datetime value to another “Last edit” column so it won’t change the “Added” column. ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [September 24, 2020, 1:43am UTC](https://community.glideapps.com/t/newly-added-inline-list/16261/6 "2020-09-24T01:43:30Z")
This is all in glide data editor? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [September 24, 2020, 1:46am UTC](https://community.glideapps.com/t/newly-added-inline-list/16261/7 "2020-09-24T01:46:26Z")
If you still keep on using Google Forms for this then this have to be in the Sheets. ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [September 24, 2020, 1:55am UTC](https://community.glideapps.com/t/newly-added-inline-list/16261/8 "2020-09-24T01:55:31Z")
I will look into this one! Thanks! ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [September 24, 2020, 2:07am UTC](https://community.glideapps.com/t/newly-added-inline-list/16261/9 "2020-09-24T02:07:57Z")
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? ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [September 24, 2020, 2:33am UTC](https://community.glideapps.com/t/newly-added-inline-list/16261/10 "2020-09-24T02:33:40Z")
No each business has its own row. I’m thinking I would just need a new column to capture the first time stamp and stay that way. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [September 24, 2020, 3:26am UTC](https://community.glideapps.com/t/newly-added-inline-list/16261/11 "2020-09-24T03:26:28Z")
The problem here is you’re using an external service to do this? Any reason not to do it using Glide’s form? ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [September 24, 2020, 3:34am UTC](https://community.glideapps.com/t/newly-added-inline-list/16261/12 "2020-09-24T03:34:45Z")
I was using the form long before I built my glide app and like the format it provides.