Forum Discussion

Qrew Captain

3 years ago

Update one User field when another one is updated

I have a app that shows who the current user is based on a State selected. In order to make sure I record the correct user at the time the record is created. I have created another field let's say ...

MarkShnier__You

Icon for Qrew Legend rank

Qrew Legend

3 years ago

try this

If User at time of creation is null, update user at time of creation with "the current user". "The current user" will be a drop down choice.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

CarolMcconnell
Qrew Captain
3 years ago
That is what I tried but it's not working. I created a checkbox formula field to check if the Recruiter fields is blank and if so change the Recruiter field to the user in the State-Recruiter Name field. The State Recruiter Name field is a lookup field, so I'm not sure if that is affecting it or not.

------------------------------
Carol Mcconnell
------------------------------
- MarkShnier__You
  Qrew Legend
  3 years ago
  Did you uncheck that "hidden" checkbox at the bottom of the form rule screen for that form rule.
  
  ie Fire all the time?
  
  ------------------------------
  Mark Shnier (YQC)
  mark.shnier@gmail.com
  ------------------------------
  - CarolMcconnell
    Qrew Captain
    3 years ago
    Yes, it is not checked. I've tried both ways.
    
    ------------------------------
    Carol Mcconnell
    ------------------------------