Conditional objects

[#1]

We are using section access for data reduction. In the excel sheet we use to assign who has access to what, i set a group = 1 or 4. If the group is =4 i want a certain object to appear and if group = 1 i want a different one to appear.

In the object i set conditional statement to "GROUP = 4" or for the other one "GROUP = 1" however, the problem is when you pull in the data it only pulls in 4 or 1 like it is suppose to, but the box doesn't appear unless the data is "selected"

Any thoughts?

Thanks,

[#2]

You could set up a Trigger (v9) or a macro to select the Group value on Open (ActiveDocument.Fields("Group").Select "*").

You could also populate a variable with your Group value in your load (Let vGroup = ?;)

[#3]

How might you do that if you loaded the group from a file

load

Group

from file.qvd

[#4]

Actually, if you only have one value in the Group field. You should be able to create a variable defined as:

=Concat(Group, ',')

That should be a list of all possible values of Group. Since Group would only have the single value based on the user, it will resolve to the Group value.

[#5 · Accepted solution]

Worked great, thanks for your help.