Forum Discussion

CarolMcconnell's avatar
CarolMcconnell
Qrew Captain
3 years ago

User field not updating

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...
Tables and fields
  • CarolMcconnell's avatar
    CarolMcconnell
    3 years ago
    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
    ------------------------------
CarolMcconnell's avatar
CarolMcconnell
Qrew Captain
I did uncheck just to check and it is still not updating.  The field is just a user field.

------------------------------
Carol Mcconnell
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
3 years ago
What is the field type you are trying to update?  Is it from a relationship?

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
  • CarolMcconnell's avatar
    CarolMcconnell
    Qrew Captain
    3 years ago
    No, it is just a user field.  No relations.

    ------------------------------
    Carol Mcconnell
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      3 years ago
      "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
      ------------------------------
  • CarolMcconnell's avatar
    CarolMcconnell
    Qrew Captain
    3 years ago
    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
    ------------------------------
    • LauraThacker's avatar
      LauraThacker
      Qrew Captain
      3 years ago
      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
      ------------------------------