Discussions

 View Only
  • 1.  User field not updating

    Posted 08-05-2022 13:43
    What would cause a user field not to be updated?

    I have a checkbox, user and date field.  I have a form rule that when the checkbox is checked to update the user to the current user and the date to the current date.

    The date updates but the user field will not.  Here is the rule.



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


  • 2.  RE: User field not updating

    Posted 08-05-2022 14:11
    Try unchecking that box at he bottom so that the rule fires all the time.

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: User field not updating

    Posted 08-05-2022 14:19
    Well, I don't want it to change just because a person is in the record.  I only want it to change when the checkbox is goes from not checked to checked.

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



  • 4.  RE: User field not updating

    Posted 08-05-2022 14:23
    I did uncheck just to check and it is still not updating.  The field is just a user field.

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



  • 5.  RE: User field not updating

    Posted 08-05-2022 14:57
    What is the field type you are trying to update?  Is it from a relationship?

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------



  • 6.  RE: User field not updating

    Posted 08-05-2022 15:05
    No, it is just a user field.  No relations.

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



  • 7.  RE: User field not updating

    Posted 08-05-2022 15:09
    "grasping at straws' here.  Do you have any pink warnings in your form rules that indicate you might have a conflicting form rule? 

    The only other idea I have before having to resort to contacting customer care team is to create a field called
    [current user]

    where the formula is

    User()

    And have the form rule change that field to the value in the field [current user]

    I can't see anything wrong with the way you're doing it but sometimes doing it a different way works for no explicable reason.

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------



  • 8.  RE: User field not updating
    Best Answer

    Posted 08-05-2022 15:09
    I figured it out.  I did not have my name showing in the user list and so it wouldn't update for me.  When I added my name back, it worked fine.

    Thank you.

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



  • 9.  RE: User field not updating

    Posted 08-07-2022 20:32
    For clarification for anyone reading this thread: For users to be selectable in a User-field (or have rules populate the current user value into a user field); the checkbox [Show in User Pickers] must be checked in the USERS area of the Application.

    ------------------------------
    Laura Thacker (IDS)
    laura@intelligentdbs.com
    (626) 771 0454
    ------------------------------