the user fills out the form in glide, but it is not legible in GS.
I attached a screenshot.
GS
in Glide
in Glide the latest data has been added…
but in GS the latest data is not added
you can check in the date column
Hola @agung_Taufik
Try scrolling to the end of the Gsheet.
if you are using the array formula function it will fill up the sheet all the way to the bottom, that’s why Glide is putting the next entry to the new row in GS… do not use =arrayformula( if( a2:a="","" use double “,”
thanks @SantiagoPerez…
it’s true, the data is at the end of the gsheet, I use an arrayformula, is there a way to prevent that from happening?
1 Like
I will try it…
thanks @Uzo
easy to copy formula:
=ARRAYFORMULA(if(A2:A="",,row(A2:A))
replace row(A2:A) with your function and have Glide row ID in A column
Delete all of the empty rows in the sheet.
2 Likes
nice reminder… you are the all-star pro!
Not related to your question, but a couple of small pointers:
The formatting of both of your date related columns looks wonky.
The first one - DATE TIME - appears to be a date/time column, but the values are appearing as ISO formatted date/time strings. This is usually an indication that the column isn’t configured correctly. If you simply edit the column in Glide and save, that should fix that.
And the second one - DATE - is configured as a text column. This will cause problems if you ever try to reference this column in computed columns, so I would advise fixing it.
5 Likes
@Darren_Murphy you are a freak of nature… you made me analyze that image… and I do agree with your conclusion
Thanks to everyone who has helped me, this problem is solved
thank you very much
2 Likes
@Darren_Murphy thanks for the correction, i will fix it…
Structure your data it is the Art of this DIGITAL world
1 Like