Trigger a looping action by schedule

I've built a looping action based on a solution that @MultiTech posted:
https://www.appsheet.com/samples/How-to-loop-through-a-list-and-create-child-records-for-each-item-i...

It works fine, "manually". I want to automate it based on a schedule but I haven't found the way to do it.

  • The loop action performs calculations 8 days after the loans due dates. There are 2 due dates during a month: the 15th and the end of the month. 
  • All I have to do is enter the date of the 15th or the end of the month date into a form. This must be done 8 days after the due dates (23rd for the 15th and 8th for the end of the previous month).
  • When the form is saved, it executes the looping action.

I want to run the looping action automatically every 23rd and every 8th of a month.  I've tried bots without success. 

This is the form with the end of month of the previous month (March 31).

maretec_0-1713316081477.png

The looping action runs when the form is saved.  The following screenshot shows it.

maretec_2-1713316298269.png

This all works fine when I enter the date and click the Save button. The automation should do the same (enter the date and call the loop action as if the form had been saved).

Thanks in advance for any assistance.

 

Solved Solved
1 8 555
1 ACCEPTED SOLUTION

Looping for bots must be done through the API. 

  • I've got a video about how to do this, and it works off the starting point of using an action loop to create records.

https://youtu.be/4p4F1fme5h8

 

View solution in original post

8 REPLIES 8
Top Labels in this Space