Really bad random periodic calling of workflow from my app

Okay.

My retool mobile app calls a workflow when user submits a form.
For some reason some records work normally but others "get stuck".

I mean:

  1. The workflow runs and returns status 200.
  2. We go forward
  3. About once every 24h the workflow runs again with the original data and thus causes duplicates in our system. Again we get status 200.
  4. And another 24h pass, the workflow runs again without anyone calling it.
  5. In the mean time 95% of all other workflow runs are normal and not duplicating like crazy. We have had like 2-5 of these in the past 2 weeks.

What in the world could be going on?

The workflow sends a record to our crm and at the same time sends a calendar invite. As you may understand, it has been frustrating for our customers to get 30-50 calendar invites and our crm is full of these false duplicates.

Where to look to resolve this quickly?

Hi @retool_amateur,
Thanks for reaching out. I can try to help you with this. Are you on Retool Cloud or are you self-hosted? Can you please upload the json files for both your app and your workflow? Or are you using a Retool Form and not the form component in a Retool App?

You can do so like this:

Can you also please provide screenshots of some of the duplicate runs of your workflows. You can find all your runs by clicking on the Run history tab in the bottom left hand corner of your workflow.

Thanks.

@retool_amateur,
Also, as a workaround while we are figuring out what is causing this, you may try one or both of these:

  1. To avoid creating duplicates in your database, instead of inserting into your database, use upsert.
  2. To avoid sending duplicate calendar invites to customers, before sending a calendar invite, check to see whether the calendar invite already exists for that customer. (or tie the calendar invite to the successful upsert in the previous step).

I hope this helps.

@retool_amateur,
Just checking in to see what the status is on your workflow.