Hi everyone. Greetings from Colombia. I am new with AppSheet and trying to create an app for my company. So far I have found really usefull all the conversations of this comunity.
I have several folders and subfolders in google drive (+2000) so creating a parent-children folder list would be a big task. The objective is that the user can select the folder in wich the images will be saved and a file from a template will be created in that location. I have try to use the folder path on the text value enterd; but if the user don´t have the list, is possible to make a mistake; for example if folder path is ABC/DEF/GHI and the user puts ACB/DEF/GHI, the files will be stored at another place and will have to relocated them manually.
I want to create a dependind dropdown real time search, that start with the list of the folders that are located on “my unit” in google drive, and if I select any of them, another dropdown list appears with the children folders, and continue that way. I guess a Valid_If is possible but I don´t know if inside the expressión I could ask to getFolderbyName and get the subfolder list.
I would appreciate any ideas on this. Thank you very much and have a nice day.