Choosing a file to open in a n App

AppSheet AppSheet Q&A
1

I have an App which creates a series of .xlsx file for use in a mail merge extension in Sheets (YAMM). All have identical file schemas. They have to be saved as Sheets files before use but this is no problem

After a mail merge I want to get the results back into the App. I can choose a file using a view of the folders file collection. If I click on a file it is opened in Sheets but what I really want to do is to either use the file in the App or import it via a .csv.
Is there a way to either:

*. Open the file in the app, Or

  • initiate an export of the file to a csv from within the app

i hope that makes sense,

2

You can create a virtual column to launch the URL building it as a continue:

MiguelPilo_0-1718989346903.png
MiguelPilo_0-1718989346903.png443×127 4.39 KB

Where [Cot.Pdf] is the ID of the file on your drive.

To get the file ID you can use a simple Script in a new Bot.

3

Please check the following Post for more details.

View Solution in Original Post