Select a spreadsheet dynamically

[Marius J.]

Hi,

I have to use cases:

1. To load a worksheet to use its data in a template
2. To store a form's user input into a spreadsheet

In both cases, currently, I have to "create or select" manually a spreadsheet in the back-end. That means that every time a user uses the app, the data is going to be retrieved/stored from/in the same spreadsheet. In my case, I need to use a different spreadsheet depending of the user (or of some answers in the form). How can I do that?

A simple way would be to be able to combine the "Find a file" building block and the Google Sheet ones, i.e. to insert a row or load a worksheet in the right spreadsheet given its $fileId.

Another solution would be to make the Google Sheet building blocks look like the find file one, i.e. to be able to get the spreadsheet given a $path starting in a given folder.

I don't know whether it's possible to implement but, in any case, thanks for your work!

Best,

Marius