Auto population of data on form loading
Hi, This is my situation, I have two tables employee_master and employee_job. In employee_master table, i have userid, empid,name,email. In employee_job, i have userid,empid,designation,departme...
Forum Discussion
Thete us a simple way and a more complicated way.
The simple way,especially if there are no other relationships involving the Employee master table is to change the Key field of the employee master table to the userid.
Note that you may want to Copy your app to try this first.
Then, on your jobs table, you can have a formula field called [Current User] with a formula of User()
Lastly a form rule that says
When the field related armployee is blank change the related employee field to be the value in the field Current User.
Note that the field that the form rule is acting on will be the field which is used in the relationship to the employer table.
The simple way,especially if there are no other relationships involving the Employee master table is to change the Key field of the employee master table to the userid.
Note that you may want to Copy your app to try this first.
Then, on your jobs table, you can have a formula field called [Current User] with a formula of User()
Lastly a form rule that says
When the field related armployee is blank change the related employee field to be the value in the field Current User.
Note that the field that the form rule is acting on will be the field which is used in the relationship to the employer table.
I'm not sure how else to say the form rule
Condition:
When the field related armployee is blank
Action:
change the related employee field to be the value in the field Current User.
Condition:
When the field related armployee is blank
Action:
change the related employee field to be the value in the field Current User.