We have a table of projects (contains key, project and task for multiple employees) and a table for time entry (with primary key, project, task, employees). We created a behavior to create the lines in the time entry table depending on the project table. We followed these steps (thanks @Steve ) and added an automation to be able to scheduled and activate the behavior when the data change in the project table.
Important points :
-the key in the time entry table is [project] +[task] + [employee] + [start of the week] because we don't want duplicates for the same week
-the behavior works well when creating new lines for a new week
We have a column for each day of the week. The problem we have is that when we have data manually entered by a user in the time entry table, the automation , when activated, will reset the duration by the initial value.
We tried :
-set the "Reset on edit" off in the time entry table
- In "Initial value" : [_THISROW_BEFORE].[Monday]
-In "Initial value" : if([_THISROW_BEFORE].[Monday] <> [_THISROW_AFTER].[Monday] , [_THISROW_BEFORE].[Monday] ,"")
-In the behavior when we set the values, we added in [Monday]=[_THISROW_BEFORE]
Thank you!
LinkedIn
Twitter
