I’ve searched for a while here and on YT but can’t figure this out. I’m new so would also love to hear any advice on troubleshooting efficiently. I’m treating this forum as a last resort.
I’m trying to add new data into whatever the first unused row is. I thought it might work to do “update value for row id: number of rows +1” but nothing happens (screen shot 20). I have set up a workaround where I created a variable to store the number of rows and I increase the variable by 1 for each entry (screen shot 19), but then is that row# variable going to keep its count if the user opens/closes the app? I guess I could set some sort of loop that tests if the row is empty and keeps adding +1 to the row# variable until it finds an empty row… I feel like I’m missing something.
Hi, Row ID isn’t a number like 1,2,3… it is an unique text like, 84eb245d-0de3-4fb8-8gf4-15f4039215c4. Thats is why your block doesn’t work, there isn’t a row id like a number.
However, I think that it is a good idea, try to use that.
@skulamester
You are correct about the row id if the table is Airtable or Local Storage. However, if the table is a google sheet then the row id is a running number such as 1,2,3,…
Are you connecting to the sheet using the Data Sources?
The Google Sheet connection will always assume the first row id as number 1.
Can you show the data source tables in the design just like the screenshot of the data sources I provided?
No reason but ignorance, thank you so much! I need to read the documentation more carefully next time. It just didn’t click for me. This is so exciting, thanks!
You can get the row ID of all your rows by using this block
Just make sure to select “ID” as the column name. This is a hidden column which contains the row ID and is available in Airtable, Google sheets and in Local Storage.
This will give you a list of all row IDs available in your table. and you can go through the list to obtain the row ID one after the other.
