OMIT different Fields based on Section Access Reduction Fields

[datagrrl]

Hello-

I have a Section Access Reduction field. I am basically listing all values in that field for all users, because all of the users can see all records, but depending on the reduction field they may not have access to some column values from that record.

This is my example:

ACCESS	USERID	COLOR	OMIT
ADMIN	ADMIN
USER	USER2	YELLOW	COST
USER	USER2	BLUE
USER	USER2	RED	COST
USER	USER3	YELLOW
USER	USER3	BLUE	COST
USER	USER3	RED	COST
USER	USER3	RED	VOLUME

The Data has the following fields:

COLOR

HEIGHT

WIDTH

COST

VOLUME

Is this possible? It seemed easy at first, but the method I attempted didn't work.

[swuehl · Accepted solution]

I believe OMIT will remove the complete field listed for the user (or multiple fields if you are listing multiple in multiple section access lines). It will not remove fields values, e.g values of field COST only for records where COLOR equals YELLOW or RED (see USER2).

Is this what you are trying to achieve?

[datagrrl]

Yes, that is exactly what I am trying to do.