Forum Discussion

EHEH's avatar
EHEH
Qrew Cadet
8 years ago

check box when last modified by a certain user

I want a check box formula to be checked if the following is correct:


1- last modified by a certain user

AND

2- another numeric field is > than a certain  value

  • GauravSharma3's avatar
    GauravSharma3
    Qrew Commander
    8 years ago
    Hi Eyad,

    If(UserToName([Last Modified By])="Your User Name" and [Your Numeric Fiedl]>(Your certain value), true, false)

    Thanks,

    Gaurav Sharma
  • EHEH's avatar
    EHEH
    Qrew Cadet
    8 years ago
    Thank you very much Sharma, but I don't know why it did not trigger the box. should I put the user name as it shows on QB : (Surname, First name) ?
    • GauravSharma3's avatar
      GauravSharma3
      Qrew Commander
      8 years ago
      No, you don't need to put as it shows on QB. Because UserToName() formula returns the user's full name.

      Please let me know if you need any further help.

      Thanks,

      Gaurav
    • QuickBaseCoachD's avatar
      QuickBaseCoachD
      Qrew Captain
      8 years ago
      I suggest testing against the user's email address as you can control how the user types their own name.

      If(UserToEmail([Last Modified By])="brubble@bedrock.com" and [Your Numeric Field]>(Your certain value), true, false)
    • AviSikenpore1's avatar
      AviSikenpore1
      Qrew Trainee
      8 years ago
      This also ensures that a bad actor does not spoof your checkbox by simply changing their name in the quickbase profile. 

      Changing email is not as easy because Quickbase will log your out and need you to verify the email address prior to updating the associated email address.