Action icon to show finder where a file is (Google Drive on Mac)

[FaCe]

Is it possible to create an action to show finder where a file (column URL - URL of a Google doc file) is it ?

[nicolasfsamaja]

Hi, you dont need an action.
There is a "Column type" that is called URL.

If you configure a column like that and then show, it will link you.

[FaCe]

Hi, yes i know it but i’d like to show the finder where the file it’s saved, i don’t need to open the file. Any chance to do it in AppSheet?

[nicolasfsamaja]

What if you put like text that info? (not like url then)

[Landan_QREW]

If I am understanding the ask correctly, you want to take a drive URL (entered by a user in your AppSheet App) and return the relative path for that file back into the app?

EX. User Enters 'https://docs.google.com/document/d/some-document-id' inside of an column in your appsheet app
You want AppSheet to Display 'Drive/SomeFolderPath/DocumentName.doctype' ?

If so, you will likely want an Apps Script that can find each parent folder and list it in that format. It could return that as a string within a new column of your table and display that in your AppSheet app.

[FaCe]

I try to elaborate a bit what exactly i'm asking.

I've an URL column where i've inserted a Google Doc file url

i.e. https://docs.google.com/open?id=54GYJ7j...

When click on it instead open the file i'd like to show the folder where the file is located (see pic), it can be done ?