Forum Discussion

PabloDarna's avatar
PabloDarna
Qrew Trainee
7 years ago

Change ""Employee"" look up field matchin the record owner upon creating the record

In the table "Ticket requests", I have a lookup field to the parent table "Employees". I would like that the ticket request record automatically sets the value of the look up field to match the record...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
I suggest having the rule only fire when the field you want to populate is blank, and also unchecking that innocuous checkbox at the bottom that says to only fire when the record changes.
PabloDarna's avatar
PabloDarna
Qrew Trainee
7 years ago
Txs Evan. It worked but using Formula E-mail totext(User()). Then the rule applies upon the adding the record.
Reason is that the key field in my "Employee" table is the e-mail.