Upload data to specific sheet in googlesheet

I have a googlesheet with similar table formats but different sheet names representing 20 classrooms (class#1, class#2, class#3…class#20), is there is a way to target specific sheet to add the data in?

for example user#1 will upload the data in sheet name “class#1”, user#15 will upload the data in sheet “class#15” and so on

to make it more clear, there will be like 17 users, once the user logged in with username and password a class will be assigned, so that any uploaded data by this user will be loaded only to the corresponding class sheet

Hello @majidfareed1977
To make updates on a different sheet for each use you will need to add multiple conditions.
Here is a similar post: Needed help regarding airtable data source - Questions about Thunkable - Community

thanks, i guess this is the only way.. will do like 20 conditions so that the right sheet will be selected to host the data..

i hope/wish that in future the create row block could give the flexibility to dynamically add the sheet name which will be really great.

cheers

1 Like