I have these tables
1) Expenses
2) Payment templates
I need to run automation to populate the salaries (recurring payments) every month in the "Expenses" table from the "Payment Templates" table, on the 1st of the month, ONLY for records that have a type = salary
Currently, I am able to do with the "Record Updated" trigger to benefit from the conditions, by adding several extra fields (to do the job of the scheduled time)