As a follow up to the office hours conducted on 04/14/2021 we have summarized the questions we received during the office hours and are posting them with answers here so everyone can benefit from them.
Seems like a related issue to this on the community regarding this.
Invoices, Receipts & W9 docs currently.
AppSheet leverages Google Cloud Document AI for invoice/receipt processing. You can find more details for them here. There are two major features that we are providing through document processing:
- Auto extraction of structured data from these documents into pre-baked tables (schema) for Invoices, Receipts & W9 documents in AppSheet. Views can be built to visualize data etc
- Triggering of Bots that can execute a process
You can create documents from standardized templates. Currently we support CSV, HTML, JSON, PDF & XML documents. Please check out the Create a File task. In the future you will be able to invoke AppsScript functions directly from AppSheet. Your AppsScript can contain code to generate various types of Google documents such as Docs, Slides, Sheet etc.
Not currently. But AppSheet can write data to many data-sources that Data Studio can build reports against. We are exploring options on how we can offer seamless integration with Data Studio in the future.
Yes, this can be done via the Create a File task in a process.
Currently we only support Google Drive as a document source. We may look at it in the future based on customer demand.
Yes, once data is in Sheets, you can create an app directly from the sheet and show that data in different kinds of views. Please check out this article.
Not currently.
Yes thatโs in our future roadmap.
Yes, currently thatโs supported through the Webook Task. In order for that to work you need to have a bot in the 2nd app that is listening for a data change event and the webhook task from bot in the 1st app can invoke the AppSheet API and invoke the data change action
We donโt support processing responses from webhooks. You can make one way sync or async calls to webhooks.
Today it can be done by creating two processes:
- Process 1
a) Pick โNoneโ for the Entity value.
b) This process has a call process step and it calls process- Process 2
a) Pick your table name (the one you want to update) as the entity value.
b) This process has a step/task (data action) to add data to this table- Create a Bot with an event of type โScheduledโ, the bot calls Process 1
In future we plan to provide a simpler user experience that involves only one process.
We currently support data copied from one table to another.
The monitoring app (accessible from the โMonitorโ button on the bot) provide high level metrics and details on bot runs. The bot run tab will show details on each execution of the bot, including the data it received, steps it executed etc.
No
Itโs not possible for us to determine if this is a bug or if you havenโt properly set up the app based on this information. Iโd recommend posting on our community website or if you think itโs a bug, submitting a support ticket (support@appsheet.com). Iโd also encourage you to look at security filters in our documentation to avoid users seeing information they are not supposed to have access to.
Thanks for attending the office hours and please keep your questions coming.
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |