News:

BB code in posts seems to be working again!
I haven't turned on every single tag, so please let me know if there are any that are used/needed but not activated.

Main Menu

Set data in multiple selections

Started by TwoBeAss, March 15, 2024, 07:27:35 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

TwoBeAss

I created a master shape where some fields are able to be set at once in a multiple selection (see attached file e.g. Labels) but some of them couldnt be set in a multiple selection (Amounts or Source fields)

Could somebody explain me why ? Is it because of the formula to hide the data cells?

Thanks for your help,
Tobi

Surrogate

Quote from: TwoBeAss on March 15, 2024, 07:27:35 AMbut some of them couldnt be set in a multiple selection (Amounts or Source fields)

Please look at this picture! In these cells used GUARD function, which protect cell's value!

TwoBeAss

These are just the Headlines.. I am talking about the A1-10, S1-10,L1-10 and so on...

Yacine

???
No problem here. I could modify the As and Ss.
Yacine

TwoBeAss

Maybe to clarify:

- Select both shapes
- See Shape Data Window
- Value for Type1 could be set (marked green on screenshot)
- Value under Amounts could be edited, but doesn't change the shape data (marked red on screenshot)


Thomas Winkel

#5
Visio seems to have a problem with your dynamic Label.
Prop.S1.Label = "Source "&Prop.T2 -> Not working
Prop.S1.Label = "Source "&"1" -> Not working
Prop.S1.Label = "Source 1" -> Working

TwoBeAss

yeah that seems to be the case.. Then i think there is no solution for me on that case (exept for Labeling the fields static) :(


Thomas Winkel

#7
You could obtain dynamic labels using SETF / GetRef without formulas in the label cell:
User.Test = SETF(GetRef(Prop.S1.Label),"""LabelName""")
or, in your case:
User.Test = SETF(GetRef(Prop.S1.Label),"""Source "&Prop.T2&"""")

Surrogate

#8
Quote from: Thomas Winkel on March 15, 2024, 12:25:28 PM
Visio seems to have a problem with your dynamic Label.

Usually i use trick, add new row in User-defined cell and use formula like:
IF(Prop.T1.Invisible,SETF(GetRef(Prop.A1),"Source "&Prop.T1),SETF(GetRef(Prop.A1),""))
Just as result


Browser ID: smf (possibly_robot)
Templates: 4: index (default), Display (default), GenericControls (default), GenericControls (default).
Sub templates: 6: init, html_above, body_above, main, body_below, html_below.
Language files: 4: index+Modifications.english (default), Post.english (default), Editor.english (default), Drafts.english (default).
Style sheets: 4: index.css, attachments.css, jquery.sceditor.css, responsive.css.
Hooks called: 294 (show)
Files included: 34 - 1306KB. (show)
Memory used: 1151KB.
Tokens: post-login.
Cache hits: 13: 0.00133s for 26,764 bytes (show)
Cache misses: 2: (show)
Queries used: 15.

[Show Queries]