Open google sheet file

[Wanahmad]

Hi,

I am trying to open a google sheet file from an action button. This file is a kind of reporting format. The reason to open this file is so that user can print it from their phone. Is this possible or not?

[WillowMobileSys]

Yes, I think you can. I have not done so but I believe you would need a column defined as type URL and then copy and paste the Google link to the Google sheet into that column.

Then you would need to use the “open a file” action type or possibly the “go to a website” (since its a URL). I am not certain which.

[Wanahmad]

May I ask for an example?

[WillowMobileSys · Accepted solution]

It should be easy to try for yourself. The steps would be:

1. Add or change a column for the URL type.
2. Create an action for the dataset that uses the “go to a website” action type.
3. Create Deck view to display the rows - add action into the Deck view.
4. Add a new row, copy and paste a Google Sheet URL into the new column and Save.
5. From the Deck view, tap the action and see of the Google file opens.

I have some time so I’ll try to create an example to see how it works.

[WillowMobileSys]

I created a little tester view in a test app following the steps above, it worked perfectly.

I tested from both the emulator and from my phone. I also tested with a Google Doc, Google Sheet and an Excel XLSX on my Google Drive. All opened without an issue.

[ProProjects]

Hi,

Does your method work with a file that is created in an automated workflow? I have an excel file that is created. It saves to a folder in Google Drive. I haven't figured out how to insert the file URL into the workflow yet. Any help is appreciated. 

[Steve]

Please start a new topic to address your question.

[Wanahmad]

Hi John,

I have tested the steps and it works. Thank you.