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
Hi,
I have tried but still not working.
The reasons is that it seems that the values of system fields (Record owner, Record ID, etc) is allocated to the record at the end of the saving process when the record is first added.
I believe, the form rules applies sometime before this allocation, and therefore, that is why they do not work because the condition cannot be applied as Record owner is still blank when it run. When the record is created, edited and saved again, then the rule runs correctly.