Date changed automatically based on another field
Posted: 2020-11-24 12:40
Hello to everybody,
I have a request, if someone can help me.
I have a form for tasks. I would want to know if someone can direct me to the correct path to solve something.
I have a table "Task_List" with records with a 'Due Date' & 'Priority'
Are times when I want the 'Due Date' to be changed automatically based on "Priority' field
======
Example: all tasks with priority (0) DE-HOT and (1) High the Due Date to remain frozen.
But the other tasks with priority " (2) Normal, (3) Low , (4) Opportunities " , the Due Date to change when i open the table to a specific date in the future; example 'Today + 5 days'
Why I want this: A lot of Low priority tasks are not completed in time( up to the Due Date), and becomes overdue.
But the low priority are not critical so i want the Due Date to be changed every time to ' Now() + 5 days ' , until is started or closed or priority is changed.
I hope i explained myself.
Any idea or recommendations is very useful.
Thank you
I have a request, if someone can help me.
I have a form for tasks. I would want to know if someone can direct me to the correct path to solve something.
I have a table "Task_List" with records with a 'Due Date' & 'Priority'
Are times when I want the 'Due Date' to be changed automatically based on "Priority' field
======
Example: all tasks with priority (0) DE-HOT and (1) High the Due Date to remain frozen.
But the other tasks with priority " (2) Normal, (3) Low , (4) Opportunities " , the Due Date to change when i open the table to a specific date in the future; example 'Today + 5 days'
Why I want this: A lot of Low priority tasks are not completed in time( up to the Due Date), and becomes overdue.
But the low priority are not critical so i want the Due Date to be changed every time to ' Now() + 5 days ' , until is started or closed or priority is changed.
I hope i explained myself.
Any idea or recommendations is very useful.
Thank you