Discussions

Expand all | Collapse all

check box when last modified by a certain user

  • 1.  check box when last modified by a certain user

     
    Posted 01-20-2018 06:10

    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



  • 2.  RE: check box when last modified by a certain user

    Silver
    Contributor
    Posted 01-20-2018 06:21
    Hi Eyad,

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

    Thanks,

    Gaurav Sharma


  • 3.  RE: check box when last modified by a certain user

     
    Posted 01-20-2018 07:03
    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) ?


  • 4.  RE: check box when last modified by a certain user

    Silver
    Contributor
    Posted 01-20-2018 09:54
    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


  • 5.  RE: check box when last modified by a certain user

    Posted 01-20-2018 14:59
    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)


  • 6.  RE: check box when last modified by a certain user

    Posted 01-21-2018 01:51
    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.


  • 7.  RE: check box when last modified by a certain user

    Posted 01-21-2018 01:52
    just an edit to my post above

    "as you can not control how the user .....


  • 8.  RE: check box when last modified by a certain user

     
    Posted 01-21-2018 02:12

    Hi guys,

    thank you for your help, really appreciate it.

    I have applied what you have suggested and the formula is working however the problem I'm facing is that the formula (checkbox field) is working only after I saved the record. I wanted the checkbox to be checked or not during the user is completing the records and before saving it so the user is aware that the record is above their financial limit.

    the idea im trying to reach is if the amount in a field is above the user's financial limit then they need to be warned. (different users have different financial limit)

    I changed the (last modified by) to the (case owner but still not working before saving.

    any ideas? thanks is advance.

    Eyad



  • 9.  RE: check box when last modified by a certain user

    Posted 01-21-2018 02:42
    The [Last Modified by] does not exist until the tecord has been saved

    There is a function called User() which return whoever is logged in

    Maybe what you want is

    IF(
    UserToEmail([Last Modified By])="brubble@bedrock.com" and [Your Numeric Field]>(Your certain value), true,

    UserToEmail(User())="brubble@bedrock.com" and [Your Numeric Field]>(Your certain value), true)


  • 10.  RE: check box when last modified by a certain user

     
    Posted 01-21-2018 04:46
    work perfectly, thanks.