BOT doesn't work with Wait Condition in place

AppSheet AppSheet Q&A
1

I have a bot in place that’s been working fine until today. The trigger is simple and is as follows:

AND(
[_THISROW_BEFORE].[Finished Wgt Timestamp]<> [_THISROW_AFTER].[Finished Wgt Timestamp],
ISNOTBLANK([Finished Wgt Timestamp]),
[Scale Weight]>0
)

I’ve confirmed the parameters have been met for each of my tests but the bot doesn’t trigger. I went to the Automation Monitoring screen to see if I could find where its failing but I’m not seeing data for my tests either.

After much testing, I had to remove the Wait Condition to make it work again. I’m needing the “file_processing_id” field in the same row to not be blank before the final process executes. Is this condition not possible? If no, how do I ensure the previous steps in the bot complete before the final step (set_second_bc_record_values) executes?

3X_5_d_5da7f3e601e18f285d7db30770ecc705a9c6e785.png
3X_5_d_5da7f3e601e18f285d7db30770ecc705a9c6e785.png881×1444 36.7 KB

3X_e_5_e574133be12cc8550a9dc7f442cc9a30eb9debaf.png
3X_e_5_e574133be12cc8550a9dc7f442cc9a30eb9debaf.png824×749 26.9 KB

2

Any specific reason, you are unable to add the condition ISNOTBLANK([file_Processing_id]) to the trigger expression itself?

3

The file_processing_id would be blank by default until step set_file_id is completed and then it would not be blank. Is why we would need the process to complete before the other steps would execute.

1 Like
4

Daisy, did you ever figure this out? I am trying to use a Wait Condition for the first time. I think I am having an order of processing problem or maybe hitting an automatic timeout on the Wait? Not sure.

5

This seems unlikely btw

https://help.appsheet.com/en/articles/5167185-automation-limits

SkrOYC_0-1646323390056.png
SkrOYC_0-1646323390056.png693×654 45.2 KB

6

That’s the maximum, I assume if developer specified, but what is the AppSheet default? I don’t think they would set it to 30 days. More like minutes.

Anyway, I think I have figured out that the wait condition WAS firing and updating but another row edit was setting the values back.

7

Unfortunately, no I removed the Wait Condition altogether and rearranged the bot to run other tasks before the main task - in a sense adding time to process. Sorry I couldn’t be of more help.