Referencing a fixed variable list

Started by Scott10284, August 17, 2016, 12:35:56 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Scott10284

So I have shapes with shape data using a fixed variable list (None;Opened;Closed). This shape data is Prop.Contacts in my shape data worksheet.

I want to turn a part of the shape off when "None" is selected.

I attempted putting the following in the Geometry.NoShow field: IF(Prop.Contacts="None",1,0)

The function IF(Prop.Contacts="None",1,0) results in 1 or true no matter what fixed variable I select, including None.

What am I doing wrong??????

If my fixed variables are numbers rather that words it work perfectly.....

wapperdude

You're trying to compare text, use strsame fcn, e.g., if(strsame(prop.xyz, "yes"), "True", "False")

Wapperdude
Visio 2019 Pro

Scott10284

#2
Wapperdude, I swear I tried that last night (after an exhausting day) and it didn't work.

I tried it again this morning with a fresh mind and apparently did not make a mistake - IT WORKED.

Thanks for the advice man!

wapperdude

Yeah...sometimes you just have to step away. 

Wapperdude
Visio 2019 Pro