Author Topic: Link text fields on different pages  (Read 8081 times)

0 Members and 1 Guest are viewing this topic.

drewdb

  • Jr. Member
  • **
  • Posts: 30
Link text fields on different pages
« on: August 10, 2008, 09:39:59 PM »
Hi to all once again,

Does anyone know how to link the text in a text box across pages?

In my template i have 5 pages with a border that contains Job Name and Info. I would like the user to be able to enter this info on the first page border and the other 4 borders on the other 4 pages would reflect the same info.

I have tried hyperlink to off page without success of transfering the text.

vojo

  • Hero Member
  • *****
  • Posts: 1528
Re: Link text fields on different pages
« Reply #1 on: August 11, 2008, 09:39:59 AM »
if name in a user cell....can reference that cell from any page in the drawing.
    pages[<pagename>].sheet.<shapenumber>!user.jobname

The trick or problem is that user has to drop the root or source shape in the same order each time used
 (on the first page....3rd shape dropped...etc)

You may be able to fence some of this off by having unique page name and shape name so that the
ordering of creation may not need to be that stringent

Alternatively, you could have a background page with a user cell.   All other pages reference that page user cell.   That background page only references the source....so only 1 update needed...or even have the the root/source on that background page so that no updates needed

This smells a bit like a template approach

Visio Guy

  • Administrator
  • Hero Member
  • *****
  • Posts: 1718
  • Smart Graphics for Visual People...n' Stuff
    • Visio Guy
Re: Link text fields on different pages
« Reply #2 on: August 11, 2008, 12:01:40 PM »
I think drew said he was setting up a template, so vojo's tip is correct.

So on, say, page 3, you could select a shape, then:

1. Go to Insert > Field
2. Choose Custom Formula from the list
3. Enter: pages[page-1]!User.jobName

That means, in the page's ShapeSheet on page 1, you'd have to store the job name in a user cell, or a shape data field (custom property)

You can get to the page's ShapeSheet by deselecting all shapes, then choosing Window > Show ShapeSheet.
For articles, tips and free content, see the Visio Guy Website at http://www.visguy.com
Get my Visio Book! Using Microsoft Visio 2010

drewdb

  • Jr. Member
  • **
  • Posts: 30
Re: Link text fields on different pages
« Reply #3 on: August 12, 2008, 12:15:25 AM »
****** Edit ****** sorry i fixed it by adding: =pages[Index]!thePage!User.JobName.

this should solve my issue. it will be template so that's OK.

Thanks for your input,

I must be something i'm doing or not doing.

My first page is called - Index
My second page is called - Video

I have created User.JobName on the Index page. (double checked)
I enter a custom field in the JobName text box on the Video page as follows:

=pages[Index]!User.JobName

Form some reason it won't accept it.

Not sure what i'm doing wrong. I've tried capitalising the "p" of "pages, tried adding the same User.JobName to the Video page and replacing Index with Video, still no go.

As i said, i'm sure it's me.

Thanks again.
« Last Edit: August 12, 2008, 12:23:25 AM by drewdb »

vojo

  • Hero Member
  • *****
  • Posts: 1528
Re: Link text fields on different pages
« Reply #4 on: August 12, 2008, 08:27:19 AM »
need to include the sheet (shapename) after the page[index] but before !

wapperdude

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 3833
  • Ideas Visio-lized into solutions
Re: Link text fields on different pages
« Reply #5 on: August 12, 2008, 11:47:23 AM »
Here's an article for cell references:  http://msdn.microsoft.com/en-us/library/ms195648.aspx
Visio 2019 Pro

drewdb

  • Jr. Member
  • **
  • Posts: 30
Re: Link text fields on different pages
« Reply #6 on: August 13, 2008, 04:14:42 AM »
Thanks for the link to the Cell References.

Will use in future.

Thanks to all yet again. :)

AndyW

  • Sr. Member
  • ****
  • Posts: 320
    • PC Mimic Diagram
Re: Link text fields on different pages
« Reply #7 on: August 15, 2008, 07:01:54 AM »
Why not hold the data in the document sheet, this can easily be referenced in the cell formulas as  TheDoc!User.JobName

The document sheet can be accessed by the drawing explorer.
Live life with an open mind

Visio Guy

  • Administrator
  • Hero Member
  • *****
  • Posts: 1718
  • Smart Graphics for Visual People...n' Stuff
    • Visio Guy
Re: Link text fields on different pages
« Reply #8 on: August 15, 2008, 09:36:39 AM »
Yes, Andy has the best solution.

The document has its very own ShapeSheet. You can add Shape Data or User-cells to this sheet, and store "global" information that applies to the whole document.

Here's a tip for accessing the document's ShapeSheet: hold down the Shift key while selecting Window > Show ShapeSheet.
For articles, tips and free content, see the Visio Guy Website at http://www.visguy.com
Get my Visio Book! Using Microsoft Visio 2010

wapperdude

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 3833
  • Ideas Visio-lized into solutions
Re: Link text fields on different pages
« Reply #9 on: August 15, 2008, 05:15:56 PM »
Well, I can see the advantage of using the document, but..., pardon my ignorance...part of the goal was to allow the user to enter values.  How does that happen with the doc approach?  How does the user bring up the document shape data so he can enter drawing title, for example?
Visio 2019 Pro