Hm I don't quite get it, what went totally wrong?
I thought I have posted a link to the "Visio MVP Series" play list, "using shape data" that explains what shape data is and how to use it?

Do you mean, linking to that exported file did not work, or?

Thanks a lot!

@Nikolay - first try went totally wrong - maybe because I have different reports upon different shapes for different purpose (terminals, relays etc) with different props. Probably my fault

@wapperdude - looks really nice! I have to test it after modifying. I'll check how to export to a template (already open?) rather than a new file. with already defined formatting and coding. And access to all props.

@Thomas - I didn't check this out but I have to finish the schematic itself with all the lists required Monday.

It turned out that this was not the most important task- with a bit more discipline while dropping shapes could reduce this to a minimum.
Insofar reports are ok.

By the way: when defining a report - where I can set if a user.- or prop.- field/cell is selectable for the report itself (not criteria)? Some props are not in the list. Where's the gap?

have a nice weekend!
hl

Ah, good to know. I didn't find that with Google. Having it online is of course better than downloading an Excel file.

In our VSTO AddIn I implemented many of these commands as MarkerEvent because I didn't know about this option
Now, I change that to DOCMD() because this does not require the AddIn.

Many years ago I prepare web-based table
https://surrogate-tm.github.io/surrogate/DOCMD.htm
There you can also use filters and so on...

It's sad that the forum doesn't have the ability to embed such tables. As in this post at Russian Visio  forum.

Here is a list of all Visio "DoCmd" commands:
https://learn.microsoft.com/en-us/office/vba/visio/concepts/docmd-docmd-commands

All of them can be used for automation (VBA).
But only a subset can also be used in the ShapeSheet.
In the attached Excel document the auto-filter can be used to find them quickly.

For example EventDrop = DOCMD(1052) will ungroup a group on drop.

Visio has native shape data support.

I think you can check out this educational video from David Parker and Chris Roth (aka "Visio Guy") series:
https://www.youtube.com/watch?v=ckZs4B8tS_I

The idea behind Visio shape data linking is, you edit your data in Excel (or other "data source"), and then use it in Visio.
You do not edit it in Visio, just use. Therefore, lists and stuff like that is not needed (and not supported)

Editing shape data in Visio has lots of issues:
- The person who edits data, needs Visio. This may be a problem already;
- The built-in editing experience is far from perfect (if you compare with Excel for example, or specialized forms)
- Allowing to edit data in Visio AND another app would lead to "two sources of truth" and the need for synchronization, which is never a good thing

Hi, I have two related contributions:

https://youtu.be/LQpllJpzsU4
https://visguy.com/vgforum/index.php?topic=7581.0

https://youtu.be/OYpENi7Pg4U
https://visguy.com/vgforum/index.php?topic=7572.0

The first tool has explicit support for fixed list, variable list and boolean data types.

Might this be the elusive post:  https://visguy.com/vgforum/index.php?topic=7302.0

I know that I have seen it before but can't find it.

I have a report - exported to Excel.

Then I want to change the report in Excel (because it's easier than to modify every shape in Visio) - how I can replace shapesheet-values by the changes I made in Excel
In other words: read back from Excel-cells to Visio-Shapesheet-Cells?

And how to ensure that the format is the same as required in Visio (e.g. Lists)?

I stand on the tube - Ich steh auf'm Schlauch

Thanks for links and tips!
hl

I've not tried Visio on a touch screen, ever, so not sure how that aspect would work.  Obviously, mouse and touchpad work.  Overall, creating a user presentation and limiting accessibility to strictly a kiosk function would be a challenge.  Perhaps requiring code external to Visio.  Another thought might be leveraging a 2nd screen view???

Regarding layers, yes, that's do-able.  I think this post presents the idea you're after:  Show/Hide Layers

Page to page linking may not necessary.  A  solution could be as follows:
> place your "controls" on a drawing page.  They will always be visible.  Perhaps along 1 edge of the page.
> Place your map shapes on 1 or more background pages.   Each background page made visible as needed, or, at least shapes on them.
> Background pages may be "stacked". 
> Background pages minimise the accidental movement of shapes by the kiosk user.