This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Automation: Wait then Delete Row

Posted on 07-21-2023 07:47 AM
Ryan_Wagner
Silver 2
Silver 2
Reply posted on --/--/---- --:-- AM

Hi. 

I'm trying to set up an automation that will wait a period of time after a row is added and then delete that row. I added a pin yesterday and checked back this morning, but it is still there...

Here is the overview of the bot:

Ryan_Wagner_0-1689950753800.png

It is set to wait 7 hours and then delete the row. Are the notifications interrupting the process? Here's what the monitor shows, but I'm not sure why it can't find the row to delete:

Ryan_Wagner_1-1689950816647.png

 

Like most issues I've asked about, I'm sure it's something obvious that I'm missing...

Thanks for taking a look.

0 4 168
Topic Labels
0 Likes
4 REPLIES 4

Posted on --/--/---- --:-- AM
WillowMobileSys
Platinum 1
Platinum 1
Reply posted on --/--/---- --:-- AM

What does the "Delete parking Spot" step do?  Can you show the action You have implemented there?

FYI, using wait times can be notoriously inaccurate.  You might set it to wait for 7 hours but it could be more than that.  It's also probably not a good idea to have many such automations kicked off and just waiting for 7 hours which it seems like your app might do.

Instead I would recommend using a scheduled automation.  We can now run them hourly.  The idea is to mark the Parking Spot row with a Time.  Then have your Scheduled automation run hourly and then select the Parking Spot rows that have a Time  7 hours or more in the past and run the delete on those selected rows.  This will be a lot more elegant and efficient.

Posted on --/--/---- --:-- AM
Ryan_Wagner
Silver 2
Silver 2
Reply posted on --/--/---- --:-- AM

Thanks @WillowMobileSys . You are always a great help. Here's the "delete" step. Not much to look at. 

Ryan_Wagner_0-1689958039343.png

 

Basically, a user can add a pin in the field, change it to type "Parking Spot", and then (at least the goal was) that the pin would delete itself after X amount of time. 

I'll try the scheduled idea, though, and report back with how it goes.

I was confused by the monitor saying the row couldn't be found...

0 Likes

Posted on --/--/---- --:-- AM
WillowMobileSys
Platinum 1
Platinum 1
In response to Ryan_Wagner
Reply posted on --/--/---- --:-- AM
@Ryan_Wagner wrote:

I was confused by the monitor saying the row couldn't be found...

Me too, which is why I was asking what the Delete step was doing. 

 

My suspicion, based on the message, is that the Delete occurred but for some reason the Wait tried to access the row again after it was deleted.  For what reason I don't know but it seems to me there is some issue with the processing.   Maybe a bug?  I would recommend reporting this problem to AppSheet.

Posted on --/--/---- --:-- AM
AleksiAlkio
Gold 4
Gold 4
Reply posted on --/--/---- --:-- AM

I realized the same kind of issue when trying to use RunAsUserEmail with the json parameter. Everything works propely when the Wait task is not used. But when adding it, it doesn't work anymore. I reported this as a bug two weeks ago.. I will add this case as well if they are related.

Top Labels in this Space