Text only | Text with Images

Visio Guy

Visio Discussions => General Visio => Topic started by: morelup on February 20, 2019, 03:27:42 PM

Title: Determining if a dynamic connector is connected to shape
Post by: morelup on February 20, 2019, 03:27:42 PM
I'm trying to make a dynamic connector show a different color if it isn't connected on both ends to shapes.  As far as i can tell, the only thing that changes when a dynamic connector connects to a shape is that the begin/end x/y cells change from literal values to functions.  Is there a function I can use to determine if a function is in a cell and not a literal value (or some other way to identify this scenario?)
Title: Re: Determining if a dynamic connector is connected to shape
Post by: Surrogate on February 20, 2019, 05:11:16 PM
Try use EndTrigger/BeginTrigger in GlueInfo section, this syntax in LineColor cell

Code Select
IF(BegTrigger+EndTrigger>=3,2,0)
(http://forumimage.ru/uploads/20181128/154340903390763858.gif)

Title: Re: Determining if a dynamic connector is connected to shape
Post by: morelup on February 20, 2019, 06:49:12 PM
Ok that might work, My visio is forcing the value to be _XFTrigger(Connector!EventXFMod) then updates to _XFTRIGGER(Sheet.17!EventXFMod) when i connect it to a shape.  It looks like that resolves to 1|2 though like your example shows so that might work.

Thank you!
Title: Re: Determining if a dynamic connector is connected to shape
Post by: wapperdude on February 20, 2019, 09:17:44 PM
What you're looking at is the literal formula in the cell.  Right click in the shape sheet and choose show values.  Surrogate's solution uses the values. 
Title: Re: Determining if a dynamic connector is connected to shape
Post by: Visio Guy on February 21, 2019, 08:16:52 AM
Pro tip:

[F5] toggles values and formulas in the ShapeSheet!
Text only | Text with Images