Firstly, I want to say thankyou to Qrew for a great webinar on using API. I always thought it would be much more difficult.
I have a question-wondering if the following is possible.
We use Appsheet for out procurement system. I have 10 Apps, all of similar structure, one for each project. I use the same Suppliers across all Apps. I need to analyse Supplier performance across all Apps.
Currently, I have a Reports spreadsheet with pivot tables and charts. I manually pull the Orders details from each App into the Reports spreadsheet as the combined source for the charts.
If I create a Reports App and pull the Reports spreadsheet into a table can I use API to update this table from the Orders tab in each if the 10 Apps?