Author Topic: Problem with Page to page field access  (Read 9919 times)

0 Members and 1 Guest are viewing this topic.

Surrogate

  • Hero Member
  • *****
  • Posts: 1630
    • ShapeSheet™ Knowledge Base
Re: Problem with Page to page field access
« Reply #15 on: August 26, 2021, 01:24:21 AM »
something like selector ?

Are you sure that each page have shape with ID=1855 (or NameID = Sheet.1855), and that all these Sheet.1855 have cell User.Value ?
« Last Edit: August 26, 2021, 01:27:06 AM by Surrogate »

Surrogate

  • Hero Member
  • *****
  • Posts: 1630
    • ShapeSheet™ Knowledge Base
Re: Problem with Page to page field access
« Reply #16 on: August 26, 2021, 02:33:21 AM »
May be this example file can help you

« Last Edit: August 26, 2021, 02:34:52 AM by Surrogate »

geoffg41

  • Jr. Member
  • **
  • Posts: 11
Re: Problem with Page to page field access
« Reply #17 on: August 27, 2021, 05:34:01 PM »
Hi Surrogate

What i am trying to do is this

In my main page "Site Supply" I have a number of Substations  each one of these Substations refers to another page in the top left corner there is a Site supply shape with a "total load value" which is the value I need to insert into the associated substation on the main page  there is never anymore than one of these on each page (except for the main Site Supply Page )

1. For example on the main page "Sub 01 2225 Pump Station"  in its shape data  I have a a list of all the pages to select from
when a selection is made I would like that page to be inserted into here "=Pages[2225SUB]!Sheet.1855!User.Value" then I need to insert the shape sheet which will also be shape name  "Initial Supply & Cable.XXXX " and a number at the end which I was hoping that this could be automatically  inserted into here   =Pages[2225SUB]!Sheet.1855!User.Value
hope this makes sense

Is this at all possible

Surrogate

  • Hero Member
  • *****
  • Posts: 1630
    • ShapeSheet™ Knowledge Base
Re: Problem with Page to page field access
« Reply #18 on: August 28, 2021, 01:47:49 AM »
Hi, Geoff!
I need to insert the shape sheet which will also be shape name  "Initial Supply & Cable.XXXX " and a number at the end which I was hoping that this could be automatically  inserted into here   =Pages[2225SUB]!Sheet.1855!User.Value
hope this makes sense
I am sorry, I am Russian and understand what are you need  :-\
I mean words which i selected as green above. You need get value or shapetext from another 2225SUB page and Sheet.1855?
What you mean as End?
Did you try my example from previous message?
« Last Edit: August 31, 2021, 04:21:01 PM by Surrogate »

geoffg41

  • Jr. Member
  • **
  • Posts: 11
Re: Problem with Page to page field access
« Reply #19 on: August 28, 2021, 01:58:35 AM »
Hi Surrogate

Yes  languages are always a  barrier

What I mean is the shape that the value comes from is in the shape name "Initial Supply & Cable "

yes i did but couldn't get it to work how i wanted it to

Surrogate

  • Hero Member
  • *****
  • Posts: 1630
    • ShapeSheet™ Knowledge Base
Re: Problem with Page to page field access
« Reply #20 on: August 28, 2021, 01:48:32 PM »
Geoff, you want rename shape via ShapeSheet?
Sorry, but it is impossible ! But you can do it via VBA or another programm language like as C#, Python, PowerShell
« Last Edit: September 03, 2021, 03:07:37 PM by Surrogate »

geoffg41

  • Jr. Member
  • **
  • Posts: 11
Re: Problem with Page to page field access
« Reply #21 on: August 28, 2021, 03:47:31 PM »
Hi Surrogate

Thanks for your help 

What I would like to do is to reference the shape from another page using its shape name

geoffg41

  • Jr. Member
  • **
  • Posts: 11
Re: Problem with Page to page field access
« Reply #22 on: August 28, 2021, 08:31:37 PM »
Hi Surrogate

Thanks again for all your help just letting know that I have worked it out
I ended up putting the shape value on the main page and used your example to get that value where I needed it

Works a treat

thanks again 

wapperdude

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 4449
  • Ideas Visio-lized into solutions
Re: Problem with Page to page field access
« Reply #23 on: August 29, 2021, 04:03:44 PM »
Take a look at this.  It shows the constructs for page, shape, and cell references.

https://docs.microsoft.com/en-us/office/client-developer/visio/about-cell-references
Visio 2019 Pro