Hey guys,

Any idea on how to configure a report that shows individualised data? 

What I mean is apply the filter "My opportunities" in a opportunity report, to apply to anyone who views the report.

So I view the report, it will show 'my' opportunities. And when TeamMember2 views the report, it will show 'his' opportunities.

When I do the 'My Opportunities" filter, it still only stays for my opportunities...

Hey guys,

I'm a real newbie and just can't seem to work. I am needing help writing this validation formula.

Basically, I want a checkbox to only be pressed TRUE if field A + field B + field C is not blank. The checkbox is not always used, so I want this validation to only work when I try to save the record with the checkbox as TRUE.

I tried:

OR(
ISBLANK(fieldA),
ISBLANK(fieldB),
ISBLANK(fieldC))

And this worked, except I can't save the records at all even if the checkbox is NOT ticked...



So I then tried 3 different validation rules separately:

1. 
AND(
     checkbox = TRUE,
     ISBLANK(fieldA)

2. 
AND(
     checkbox = TRUE,
     ISBLANK(fieldB)

3.
AND(
     checkbox = TRUE,
     ISBLANK(fieldC)

This one worked, but it doesn't work together, when I enter value for fieldA and click checkbox, it works and doens't validate the other rules!!



I am thinking it's something like this in a SINGLE formula, but I can't seem to get the validation working...

OR(
    AND(
     checkbox = TRUE,
     ISBLANK(fieldA)),
    AND(
     checkbox = TRUE,
     ISBLANK(fieldB)),
    AND(
     checkbox = TRUE,
     ISBLANK(fieldC))))

But validation doesn't work.... Can anyone help...?

Hey guys,

I'm a real newbie and just can't seem to work. I am needing help writing this validation formula.

Basically, I want a checkbox to only be pressed TRUE if field A + field B + field C is not blank. The checkbox is not always used, so I want this validation to only work when I try to save the record with the checkbox as TRUE.

I tried:

OR(
ISBLANK(fieldA),
ISBLANK(fieldB),
ISBLANK(fieldC))

And this worked, except I can't save the records at all even if the checkbox is NOT ticked...



So I then tried 3 different validation rules separately:

1. 
AND(
     checkbox = TRUE,
     ISBLANK(fieldA)

2. 
AND(
     checkbox = TRUE,
     ISBLANK(fieldB)

3.
AND(
     checkbox = TRUE,
     ISBLANK(fieldC)

This one worked, but it doesn't work together, when I enter value for fieldA and click checkbox, it works and doens't validate the other rules!!



I am thinking it's something like this in a SINGLE formula, but I can't seem to get the validation working...

OR(
    AND(
     checkbox = TRUE,
     ISBLANK(fieldA)),
    AND(
     checkbox = TRUE,
     ISBLANK(fieldB)),
    AND(
     checkbox = TRUE,
     ISBLANK(fieldC))))

But validation doesn't work.... Can anyone help...?