AnsweredAssumed Answered

Repeat events automatically

Question asked by dragone on Feb 7, 2018
Latest reply on Feb 14, 2018 by dragone

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

EMPLOYEE: ANNA

CUSTOMER: ROSSI

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 .....

Outcomes