Discussions

 View Only
  • 1.  Update one User field when another one is updated

    Posted 06-07-2022 16:55
    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 user at time of creation.  When a new record is created I want the user in the user field to update the user in the user at time of creation field.

    I put a form rule that says if User at time of creation is null, update user at time of creation with user in user field.  However it is not working.

    Any ideas?

    ------------------------------
    Carol Mcconnell
    ------------------------------


  • 2.  RE: Update one User field when another one is updated

    Posted 06-07-2022 17:56
    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
    ------------------------------



  • 3.  RE: Update one User field when another one is updated

    Posted 06-07-2022 18:04
    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
    ------------------------------



  • 4.  RE: Update one User field when another one is updated

    Posted 06-07-2022 18:12
    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
    ------------------------------



  • 5.  RE: Update one User field when another one is updated

    Posted 06-07-2022 18:36
    Yes, it is not checked.  I've tried both ways.

    ------------------------------
    Carol Mcconnell
    ------------------------------



  • 6.  RE: Update one User field when another one is updated

    Posted 06-07-2022 18:44
    Is that formula on the form?  Sometimes form rules do not fire properly when the formula field they depend on is not on the form.

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



  • 7.  RE: Update one User field when another one is updated

    Posted 06-07-2022 18:48
    Yes it is on the form.

    ------------------------------
    Carol Mcconnell
    ------------------------------



  • 8.  RE: Update one User field when another one is updated

    Posted 06-07-2022 19:24
    Not sure what to suggest. Contact me by direct email and I can have a look if you like.

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