I have this screen with text/date entry components writing to a blank google sheet (purpose here is to collect user data) but the entry components appear frozen, ie. it is not possible for user to type into any of the fields. Any idea why this is happening? (The only way it works is if the google sheet fields are pre-populated beforehand, then the user can edit them from the app.) Thanks in advance.
Glide needs to know a row where you want to write the data to, so if you don’t have any rows, the right way is to enter them via a form and then let them edit the resulting row.
No because that row is used for headers, you need a row for Glide to write to.
Put it like this, in a details screen, Glide is supposed to let you edit a row but here we don’t have any rows.
In a form, Glide doesn’t need any rows because those pieces of info will be written as a new row when you submit.
Ok, I get it now, thank you!!!
So I ended up creating a form with the entry components, which works fine. I would now like the default values to be user-specific. How should I set this up? I tried playing around with different visibility conditions but I think this refers to the item itself not the content right?
I assume you can set user profiles values as default values?
Thanks for your answer, @ThinhDinh.
Yes, and I tried doing this, but for some reason, the user data from the sheet is not being picked up by the app. I think the reason is that, for any given user, there are 2 rows of data on the sheet, one of which has no data. This empty row get created whenever a new user logs in (on top of being recorded in the App:Logins sheet) - do you have any idea how I could fix this? Many thanks
When you use User Profiles, new rows will be automatically created for them so you should let them edit it instead of submitting a new form.
Ah ok. Let me give it a try.
So now the button opens a screen (instead of a form) connected to the users sheet.
But for some reason, the default values that get picked up are not user specific - they appear to always be reading the data from the first row of the sheet.
I am logged on as the second user on that sheet, but the app keeps reading from the first row for some reason
You have to filter that tab by email is signed-in user.
thank you @ThinhDinh