Can I set new input table when needed?

[prezes]

Hello everyone!

I would like to create an app that sends receipts to our workers, that are based on a specific spreadsheet file. The problem is, that input file changes every month (due to our existing processes and payment automation).

Is there a chance to select a source file every time when we would like to send receipts?

If not, do you know any other apps that can do this?

Thanks!

[Marc_Dillon]

You can change the source of your Tables here:

Though I’m not sure I’d recommend using Appsheet in this way.
Perhaps you could build some automation in a different service (zapier,integromat,google apps script) that will copy all records from the monthly new file, and paste them into the spreadsheet Table that is already loaded into your app.

[prezes]

Thanks for your reply Marc!

Your suggestion sounds just like something we need.