Hi all, my question is How make scheduller to insert new record every first day of month (like crontab in unix). Thank you
You would set your Scheduled automation so that the "For each row in table" setting is OFF. Then the Condition simply acts as a trigger for the automation to Run or Not Run. To run on First day of Month you would use the expression:
DAY(Today()) = 1
Your Bot will run on the 1st day of each month at whatever time you set.
Next create a Process and add a step with the appropriate action that adds the row to the table you want.
I had already test for day of 7 , but trigger not runing , test by click menu Bot run, insert into table. any solution ..?
DAY(Today()) = 7
User | Count |
---|---|
43 | |
27 | |
23 | |
16 | |
12 |