Seating sections vs Worksheet

[MartinBlomberg]

Hi all,

Slowly slowly I'm getting better at VW, still I can't get this thing to work.

My goal is to have the following on a worksheet:

- Section names 

- Count for all sections

- A total count for all seats

 

I've tried to create but just won't get the result I want. Please see images 😃

There's also a map over all sections with different colors.

 

What am I missing? Using VW2021. 

 

Thanks!!

[Pat Stanford]

The colors look like there might be some kind of Data Visualization turned on.

 

The dashes in Column B indicate that there have been objects SUMmarized into those database subrows.

 

Can you post the file or a simplified version of part of the file?

[MartinBlomberg]

2 hours ago, Pat Stanford said:

The colors look like there might be some kind of Data Visualization turned on.

 

The dashes in Column B indicate that there have been objects SUMmarized into those database subrows.

 

Can you post the file or a simplified version of part of the file?

Thanks Pat!

Your absolutely right, the colors are a color visualization that works just fine.

Also, another feature that I would just LOVE to have in this drawing is the ability to mark some chairs as "blocked" which the comes up as "Not for sale" in a worksheet.

How do I do that without bend over backwards? 

 

Here's a simplified version of the seating sections. Thank you so much!!

 

Martin

Only seating sections.vwx

[Pat Stanford]

@michaelk Can you comment on your visual blocked seating option?

 

If you put the Not for Sale into a Record.Field attached to each seat rather than just being a list in a worksheet then you should be able to use Data Visualization to mark them a differently. You could import a spreadsheet with the blocked seats and use a script to attach the data to the record attached to each seat. Or if you don't need any other fields, you might be able to just use the fact that a record is attached.

 

I will try to take a look at your file later today.

[michaelk]

@MartinBlomberg check out this tool:  TheateRow.  It will be much easier to number the seats, draw the curved parts, and change the seats symbols within the rows.  The worksheets will probably be much simpler too.  

 

Let me know if this looks interesting to you and you have any questions.

[Pat Stanford]

@michaelk I was thinking of your 6' tool.  ;-)

 

[michaelk]

Ha!  I'm trying to build that into the seating tool itself, instead of being a confusing second tool.

 

Almost got it working a couple weeks ago.  I guess it depends on what you mean by "working" :-).

 

But the current version of the tool will do blocked seats.

[michaelk]

To answer your worksheet question:

 

In column B of the database you want to check Sum Values to get everything to add up in that ='Seating Section'.'ChairsNumberStatic' column.

 

You can put the total in any non database row.  Just put the formula =B1 (or whatever the header row cell is for the seating column) and that will report the sum of that database column.

Only seating sections~.vwx

[MartinBlomberg]

12 hours ago, michaelk said:

To answer your worksheet question:

 

In column B of the database you want to check Sum Values to get everything to add up in that ='Seating Section'.'ChairsNumberStatic' column.

 

You can put the total in any non database row.  Just put the formula =B1 (or whatever the header row cell is for the seating column) and that will report the sum of that database column.

Only seating sections~.vwx 8.63 MB · 0 downloads

Thank you so much!!! I just love the feedback you get from people like you guys. Wonderful!

I'll try this seating tool out straight away.

 

Again, thank you!