I am just frustrated spending few hours to figure out the issue.
Everything is working fine with BOT: Soft Delete | Product Transactions From Products Stock Adjustments | Execute Still SHOWS ERROR in automation monitor.
1/2 Action in process inside bot: Soft Delete | Product Transactions From Products Stock Transfer | Execute is working and 2/2 action which is setup exactly like above bot does not complete the second action to return value to parent table. SHOWS ERROR in automation monitor and Success in audit history
Not sure how to fix this now because both have same setup but in different table and I spent hours wasting time on it. Contacted support and no solutions till now.
There maybe or may not be solution and it could be an inherent bug between automation monitor and audit history.
However, if could share more details on your bot set up and relevant columns of the underlying table(s), there maybe a chance someone could suggest a workaround.
Action 02: Call process that updates back Product Table to update available quantity. This process is used by multiple bots from different table to update back product table.
Spent around two hours with Appsheet support and they don’t have any answer to this but told me to wait for 24 hours. I have to see if they find whats wrong.
As per AppSheet Support he says the record is already DELETED so it is not updating AVAILABLE QUANTITY column because it is not returning the Product ID.
Then my question is how is the first action triggered and updated back in PRODUCT TRANSACTION TABLE same row has IDs and second action does not work.
Then what is the use of Automation bot with data change event DELETES ONLY ?
You are correct in your question. I was also wondering how other subsequent actions/automation is firing on delete. That is why requested more details. Will delve over and revert if I come across something tangible. Now that you have shared excellent details, other community colleagues may also have insights.
If the delete action in Product Transfer table is invoked by the user through action button manually Instead of bot , then you could possibly create a group action in the sequence
Action 1 you described
Action 2 you described
Delete action on the Product Transfer table
The user can then invoke the sequence by tapping on the group action.
Yes @Suvrutt_Gurjar you are right and I feel like this is a bug in automation and can cause soo much issues if root cause is not found. Usually we do not go into automation monitor to check this on daily basis.
Also, wanted to use in BOT instead of changes in action. The available quantity must be updated by AppSheet server instead of device side update as it can cause errors if a user does not have latest value.
My entire day was gone trying to find issues in my setup and couldn’t find none. Also, TRYING to explain AppSheet support how it should behave when automation is used. But no hopes. Things were easy when @Aleksi was there and he used to understand issues in just couple of messages. I hope good days of AppSheet come back.
Oh okay. Are you able to save the product key from the Product Transfer table to the Product Transactions table in action 1 in the bot? You can then probably use that key value in action 2?
It is passing values to product transactions table yes. And already have Product ID in transaction table. How is it used in action 02 ? This bot is triggered in Product stock transfer table. I might need another bot in product transaction table to trigger product table.
