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
Forum Discussion
9 Replies
- Hi Eyad,
If(UserToName([Last Modified By])="Your User Name" and [Your Numeric Fiedl]>(Your certain value), true, false)
Thanks,
Gaurav Sharma - 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) ?
- 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 - 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) - 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.
