this is my category if user click any category then open question sub category how to do it
question sucategory
this is just demo avoid mistake
2 Likes
Do you use one spreadsheet with 2 sheets or two different spreadsheets ?
1 Like
yes i use one spreadsheet in which 2 sheets
I think You are not creating any category but you want to open sub category once main category is clicked… Correct?
So, Better you change the heading,
I will help you
yes if user click main category then open sub category how to do it
thank you friend 
better you tell me, Maximum how many questions you will add?
Note: Edit the heading to proceed further… 
friend i have created main category but i have no idea how to open subcategory list
First assume that your spreadsheet is set to share as “anyone with the link”
Use web component to retrieve data
To get data from the first sheet returned you can use
To call the data in a different sheet, you need the gid number for that sheet. The gid number can be found in the url address bar when you are viewing that sheet, and you add it to the end of the url
then use the following blocks
2 Likes
This is what i want to add but @dora_paz gave you suggestion clearly at first…
Like this for every main category you have extract csv table. And use it.
Understand from @dora_paz post?
this is lengthy process than airatable if i change daily this id,gid etc?
Change/update the questions… Until you delete the sheet it wont affect…
Regarding usage of google sheet in app @Taifun has given plenty of explanations. You can visit his blog or especially for your query you can visit here. And you can explore it with your own idea. First time only you need to work out, next time onwards no issue. IF not you have to look for PAID Spreadsheet
extensions, which will simplify your work more than 90%. But i wont suggest you for paid work. Because app mean it have to come out from our own ideas… Then only we can feel proud of it… If no time mean look for PAID extensions, like cloudhsheet or Spreadhseet
https://groups.google.com/g/mitappinventortest/c/LNAQSCExEtg
Learn how to use Google Spreadsheets by using these tutorials.
ok i m trying
thank you dora paz u help always without selfish 
Suppose if this is your google sheet id,
https://docs.google.com/spreadsheets/d/1E-pRsL1A9eUQQbPfvkIC1VZ1ELYeGrtwHA1-RoNRpBU/edit?ouid=114737577550815631595&usp=sheets_home&ths=true
Inbetween /d/ and /edit letters are called as spreadsheet id and after the edit?ouid= values are called as your gid
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.