Forum Discussion
Pick earliest appointment date
Hi i have the below problem:
I have in first table with unscheduled works for my employees, and i want to pick the earliest appontment date based in product delivery date and from the second table if he has the characteristic and if he has available capacity. In the third table i have allready picked appontment dates for some days ahead for other works, and if my employee has completed the daily capacity to automatic pick the next available day with available capacity, is there a way?
Table1
| employee | CHARACTERISTIC | Quantity | Product Delivery Date | Appointment Date |
| EMPLOYEE1 | CHARACTERISTIC1 | 1 | 1/4/2022 | |
| EMPLOYEE2 | CHARACTERISTIC2 | 1 | 1/4/2022 | |
| EMPLOYEE2 | CHARACTERISTIC3 | 1 | 30/3/2022 | |
| EMPLOYEE2 | CHARACTERISTIC1 | 1 | 30/3/2022 | |
| EMPLOYEE3 | CHARACTERISTIC2 | 1 | 30/3/2022 | |
| EMPLOYEE1 | CHARACTERISTIC1 | 1 | 30/3/2022 | |
| EMPLOYEE3 | CHARACTERISTIC2 | 1 | 31/3/2022 | |
| EMPLOYEE3 | CHARACTERISTIC3 | 1 | 31/3/2022 |
Table2
| EMPLOYEE | CHARACTERISTIC | CAPACITY |
| EMPLOYEE1 | CHARACTERISTIC1 | 3 |
| EMPLOYEE1 | CHARACTERISTIC2 | 5 |
| EMPLOYEE1 | CHARACTERISTIC3 | 10 |
| EMPLOYEE2 | CHARACTERISTIC1 | 4 |
| EMPLOYEE2 | CHARACTERISTIC2 | 15 |
| EMPLOYEE2 | CHARACTERISTIC3 | 3 |
| EMPLOYEE3 | CHARACTERISTIC1 | 10 |
| EMPLOYEE3 | CHARACTERISTIC2 | 2 |
| EMPLOYEE3 | CHARACTERISTIC3 | 17 |
Table3
| employee | CHARACTERISTIC | Quantity | Product Delivery Date | Appointment Date |
| EMPLOYEE1 | CHARACTERISTIC1 | 1 | 28/3/2022 | 31/3/2022 |
| EMPLOYEE2 | CHARACTERISTIC2 | 1 | 30/3/2022 | 31/3/2022 |
| EMPLOYEE2 | CHARACTERISTIC3 | 1 | 30/3/2022 | 31/3/2022 |
| EMPLOYEE2 | CHARACTERISTIC1 | 1 | 30/3/2022 | 31/3/2022 |
| EMPLOYEE3 | CHARACTERISTIC2 | 1 | 24/3/2022 | 31/3/2022 |
| EMPLOYEE1 | CHARACTERISTIC1 | 1 | 28/2/2022 | 31/3/2022 |
| EMPLOYEE3 | CHARACTERISTIC2 | 1 | 30/3/2022 | 31/3/2022 |
| EMPLOYEE3 | CHARACTERISTIC3 | 1 | 30/3/2022 | 31/3/2022 |
| EMPLOYEE1 | CHARACTERISTIC1 | 1 | 17/3/2022 | 31/3/2022 |
| EMPLOYEE2 | CHARACTERISTIC1 | 1 | 21/3/2022 | 31/3/2022 |
Thanx in advance
1 Reply
HI skourtip,
Your sample data looks irregular so I can't clear your expected results, can you please explain more about these?
How to Get Your Question Answered Quickly
Did you mean to calculate the 'appointment date' based on 'Product Delivery Date' and daily capacity and auto-generate the next 'CHARACTERISTIC' plan and appointment date if the current one is completed?
Regards,
Xiaoxin Sheng
