check box when last modified by a certain user

  • 0
  • 1
  • Question
  • Updated 10 months ago
  • Answered

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

Photo of EH

EH

  • 192 Points 100 badge 2x thumb

Posted 10 months ago

  • 0
  • 1
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,756 Points 5k badge 2x thumb
Hi Eyad,

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

Thanks,

Gaurav Sharma
Photo of EH

EH

  • 192 Points 100 badge 2x thumb
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) ?
Photo of Avi Sikenpore

Avi Sikenpore

  • 532 Points 500 badge 2x thumb
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.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,256 Points 50k badge 2x thumb
just an edit to my post above

"as you can not control how the user ....."
Photo of EH

EH

  • 192 Points 100 badge 2x thumb

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

Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,256 Points 50k badge 2x thumb
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)
Photo of EH

EH

  • 192 Points 100 badge 2x thumb
work perfectly, thanks.