shapedata and conditional label

Started by shinji7800, February 24, 2021, 12:27:37 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

shinji7800

Hi everyone,

I am trying to set a simple formula for a conditional label for a shapedata.

=IF(STRSAME(sheet.65!Prop.DR, "NRS"), "Interface Fa x/0/y : ", "interface Gi 1/x : ")

Label became dynamic,  but value (set by user) is not updated ... there is no dependencies and precedents so I have no clue what's going on.

please find here an exemple on video : https://youtu.be/wiYMynCw2u0

if you prefer I can provide a google drive link

thanks

best regards

Surrogate

At my side it works ! But when i use used-defined data which stored in TheDoc, sometimes i have problems with update text values...


shinji7800

Hi Surrogate !

thanks for your time !

but I not sure if I explain well my issue ...

I use shapesheet with formula (IF statement) for conditional lable in shapedata.


your gif example seems to me, a "simple" field

am I wrong ?

Surrogate

Quote from: shinji7800 on February 24, 2021, 01:43:57 PM
your gif example seems to me, a "simple" field
no, that shape contain 2 fields. In this gif you can see how changed only one of them.
Also i can changed "second field", which contain date. It is conditional !
My solution enought complex, it is reason why sometimes not all fields are updated...

Surrogate

Quote from: shinji7800 on February 24, 2021, 12:27:37 PMif you prefer I can provide a google drive link
IMHO it is best way, for investigation...

shinji7800


Surrogate


shinji7800

hi all ,

it seems that label and value cells don't like when there is calculation.

so I double rows and hide one of them conditionally. result is the same for user :)


I will post a video for additional exemple maybe it helps :)


best regards

 

wapperdude

Uploading the file would be helpful.

How are you transferring the information to the shape for display?  Are you using Insert>Field?
Visio 2019 Pro

shinji7800

Hi

Yes I use  insert > field (ctrl + F9) > custom formula

For exemple on my initial non working test

Let shape A with props,

on shape B ctrl+F9 > custom formula

=shapeA!Props.row1.value


The alternative I find (even I will prefer the non working :D)

Is on shape A create an another props :

- let row1 for a specific case (imagine for daytime)
- let row2 for an another specific case (imagine for night time)

For the Each rows add if statement in "invisible" cell
- row1.invisible = IF(daytime, FALSE, RIGHT)
- row2.invisible = IF(daytime, RIGHT,FALSE)

on shape B ctrl+F9 > custom formula

=IF(daytime, shapeA!Props.row1.value,shapeA!Props.row2.value)


I will post files as soon I can :)

Hope it helps

Regards


Machine

I'm pretty much sure I had similar situation long time ago.
Because of some reasons If-statement behaves like a Guard if shapes are grouped together.

What you could do, is to change Label via SETF/GetRef.
Basically force the Label change from the shape where you got your List (NRS;DRP).