hello to the whole community
I'm new and not very experienced in FM, I've come here and I think the Community is beautiful. I'm building an application for my work, I need to repeat events automatically ... but I do not know how to create the script to generate them.
I have the following tables; employees, customers, events and calendar. In the Events format I choose the period between two dates, I choose the employee and the customer where he provides services, the days of the week and the working hours, a scripts will have to look for a record in the calendar table for each day of the employees inserting employee, customer and hours.
example WEEK TYPE:
START DATE: 01-01-2018 DATE DATE: 31-12-2018
MONDAY: 4 HOURS
THURSDAY: 4 HOURS
The scipt must insert in the calendar table: all the dates of Monday and Thursday between the start and end date, the employee, the client and the hours, in the respective fields .....
Thanks for help or suggestions .....