LinkedIn
Twitter
In fact, I posted the same information as this case last month.
https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Automation-does-not-work-properly-when-using-Go...
Additionally, I have contacted support about this.
ID 4-9428000036464
However, the problem has not yet been solved. (It was within our expectations...)
There is a workaround, so it is not urgent, but I am wondering.
Specify Google Calendar as the data source.
The data settings were left at their defaults with nothing changed.
Create the bot shown below.
This bot rewrites the value of Discription.
When I add a record, the BOT gets the following error.
And the bot cannot set value to [Description].
However, when editing, the Bot works without any problems and can Set value to [Description].
In this post, I would like to know if anyone else is experiencing the same phenomenon.
Is anyone else experiencing the same phenomenon as this post?
Solved
1 ACCEPTED SOLUTION
First, I am not clear why you need a bot to update the Description. When you have integrated Google Calendar, as it looks like you have, using the ADD button will automatically add the event to the Google Calendar. When a row is edited and then saved that ALSO is automatically update in Google Calendar. It is actually quite fast. By the time I navigate to Google Calendar, the add and/or any updates are already there!
See below for my test event in Google Calendar.
In case I am missing something, I suspect the issue you are facing is one of timing. When you ADD a row, AppSheet knows about it immediately and can run Bots based on the added row BUT the Google Calendar service may not yet know about the row PLUS the underlying datasets based on Google Calendar service may not have had a chance to update with the new row. In other words, shen the AppSheet Bot tries to locate the new row, it is not yet available to apply an update.
To test this, create a dedicated Bot for row adds and add a Wait step as the very first step. This will give time for all underlying datasets to be updated. I DO NOT advocate using waits as a permanent fix - unless absolutely necessary.
I hope this helps!
My test Calendar event as viewed from Google. The Description was added when the row was added, Then updated with UPPERCASE text. Both originated from form saves in AppSheet.
