check box when last modified by a certain user

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.

just an edit to my post above

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

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

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)

work perfectly, thanks.