ok, i got it.
i try to explain how it works and i hope someone could have a usage for that.
I have a stock system and every product has his own documents. if iam or my employees needs documents from a specified article, the should click one action and got opened the right drive folder with the documents from this articel.
Sounds simple, it isnt.
Cause the only way to open a drive folder, is to get the unique drive folder html adress.
First, i start with an bot, that create a pdf document, for every new article, with ISBLANK([Drive Link])
the pdf is a simple template with the data i add by creating a new article.
This pdf is saved into an folder, namend with the article number, inside the folder article.
so i got a folder with the articlenumber, for every new article i add.
To get the link, to this folder, you have to add the folder ARTICLE to a table. Click on add table, google drive and select colletion of files. choose the folder ARTICLE (within all the folders named with the articlenumber) and add this. i decide to choose the name Article Data
If you have added the table, go to the table columns of ARTICLE DATA and click on show button from the _ID Column.
Rename the column File to Articlenumber and set the typ to ref. Choose as source table, your ARTICLE table.
Create a virtual Column with the name Folder Link and as Text type.
Insert this Formula inside this Column:
Concatenate(“https://drive.google.com/drive/folders/”,[_ID],“?usp=sharing”)
you can see, that google give us the right ID to the folder, cause if you manualy go to the google drive folder and click on getting link, you see, if you check this link, its the same id inside. we only have to put the text bevor and after with the id together and we have the html link.
to link these folder link with your article table, you only have to make a virtual column in the article table, like VDrive Link and put this formula inside:
Lookup([_THISROW].[Artikelnummer],“Artikel Dateien”,“Artikelnummer”,“Folder Link”)
so i want to open it with an symbol in my article detail view, as set as card type.
i create an action calles DRIVE LINK for the record of the table article, to do this: external: go to a website, and set as target the column VDrive Link.
Finish.
After you create a new article, appsheet create the folder, import the folder link and after about 10 seconds, you can click on the action and appsheet open your drive folder.
hope it helps
