I have found a few similar questions, but nothing that directly meets my needs yet. I have an Appsheet app and I want to provide external links to a Google Drive folder.
The Appsheet app has clients with IDs like 1001, 1002, 1003.
Unfortunately things are currently set up in a manner where each client has a folder in a Shared Drive for our organization. So what I want to do is create a link in the Appsheet with a formula like
concatenate("https://drive.google.com/u/myclients/", [Client ID])
This would take me to a browser and a specific Google Drive folder like
https://drive.google.com/u/myclients/1001
I know that things aren't really organized by paths, and everything just has an ID, but there has to be some way to embed this sort of functionality in an Appsheet forumula. I'm familiar with the Drive APIs, but I don't really see how to make them work together. I can work around/with all of the security considerations, just figuring out how to get the correct links is all I need. Thank you!
LinkedIn
Twitter
