hi,
help- integrate live update back in app from dependent drop down up to 3 or 5 and then to open selected option hyperlink of file created at that cell info from google drive.
Please have another go at explaining exactly what it is you want to achieve, show relevant blocks and screenshots, drawings where possible.
,
This is dependent drop-down data from google sheet, in which when i go to last cell then its hyperlink to pdf/ photo file in google drive and when one clicks on it will get open to see that file or download.
can it be same done from app too with same hyperlink open from google drive. in app with same kind of drop-down selection but linked to google sheet.
Viewing the image or pdf can be quite straightforward once you have the link. You should be able to view the image in an image component by adjusting the url accordingly, this is how you might do it for an image stored on google drive:
For a pdf, you can either download it, and use an pdfviewer extension, or try one of the solutions here
With regard to replicating the drop downs, this can be done a variety of ways using either listpickers, listviews, spinners, or popup menu extensions.
The main concern for you is maintaining and synchronising your data between the app and google drive. You appear to have a "shop database", with 7 levels, which looks like it could contain a considerable amount of data, you probably do not want to send and receive all the data every time there is a change to the data at either end, so you will need a method to handle updates. You may need to reconsider how you are storing your data, and think more about a "proper database". I would probably be wanting to use SQLite on the app, for data volume and speed of access, and to replicate something similar for the online setup. It might be possible to do this with a "flat file" database in google sheets(you could then use the query language with apps script).
Thanks