Automate io & Deleting Data from Smartsheet
I just recently started using automate io and just recently ran into some major issues. Automate io allows you to create a bot with the trigger of 'New Row' so anytime a new row is created on a sheet, it will trigger the bot. Soon after setting it up, my bot stopped triggering, every time I created a new row (using a smartsheet form) the bot wouldn't trigger. Automate io looked into it and got back to me.
Basically what they told me, is that I should not be deleting data from my sheet. They told me that every time a row is created it is given a 'created at' stamp in the API. When I delete a row from my sheet, the row disappears but it never loses it's 'create at' stamp in the API. Therefore if I make a new row, and the new row was one that was previously deleted, the API gets sent to Automate io with it's existing 'created at' stamp and therefore the bot sees it not as a new row but as an updated row.
This was pretty frustrating to learn, for not being able to delete a row from my smartsheet is an impossible ask; especially when my smartsheet caps at 5000 rows.
- Can you confirm that what they are telling me regarding the API and the created at stamp are correct?
- Do you have any better suggestions on how to remove data from a sheet and by doing so also deleting the created by stamp?
I look forward to your reply.