Autopopoulate to current User
Little background: Each Employee can submit multiple tasks. (Relationship between Employee table and Task Table) The employee table has all employee details, name, emailid,etc. The key for this tabl...
Forum Discussion
I suggest changing the Key field of the employees table to be the user field.
Then make a relationship where 1 EE has many Tasks based on the user field on the task record.
You will either be able to default that field to be the current user or at worst have a form rule ot set it to the current user when it is blank.
Then make a relationship where 1 EE has many Tasks based on the user field on the task record.
You will either be able to default that field to be the current user or at worst have a form rule ot set it to the current user when it is blank.