Help with Formula in validation rules

Question

I have couple of custom fields

Tuser_c Checkbox Tdate_c Date

I want to have the tdate field to be required if the Tuser is true

AND( $User.Tuser__c ,ISNULL( $User.Tdate__c ))

This doesnt fire the validation rule when i leave Tuser_c as true and leave the TDate_c blank(Nothing entered in the field)

Is there something i am missing

As mast0r mentioned in his answer, the validation rule works without the $user reference. Any reason why it wouldnt work with the $user reference? — Prady, Commented Apr 24, 2013 at 10:35
All $variables are related to "who's looking at the data" (current user, his profile, his role, his session id... Hierarchical custom settings fall here as well) or simply some cached data (custom labels). All the rest is hard "what the data is". So - what were you trying to do? Allow only certain users to perform edits? Or check if the lookup to user stored on the record meets some condition? Looks like it's a data rule and not "who's editing" rule - so without $user. — eyescream, Commented Apr 24, 2013 at 10:56

Sergej Utko · Accepted Answer · 2013-04-24 11:15:45Z

1

I would try to use ISBLANK and remove $User reference:

AND(Tuser__c, ISBLANK(Tdate__c))

answered Apr 24, 2013 at 10:08

Sergej Utko

22.1k11 gold badges59 silver badges88 bronze badges

That didnt work too :(
– Prady
Commented Apr 24, 2013 at 10:14
@Prady Is it for the User object?
– Sergej Utko
Commented Apr 24, 2013 at 10:17
Yup, its user object
– Prady
Commented Apr 24, 2013 at 10:22
@Prady I've tried this without $User reference. In my Org it works fine. Updated my example.
– Sergej Utko
Commented Apr 24, 2013 at 10:25
ok let me try removing the $user
– Prady
Commented Apr 24, 2013 at 10:26

| Show 4 more comments

1 Answer 1