Lighting Position Worksheet

[JamesB1]

Hi, 

 

I am looking to create a worksheet that shows what fixtures are in each lighting position. I would like the position to be shown once and then show the fixtures below. I have managed to get the worksheet set up like this: 

 

 

But really need something like this.

 

Any help would be appreciated 

[Pat Stanford]

I can only think of two ways to accomplish this.  One is relatively easy, but has a manual component. The second requires a fairly sophisticated script to "interleave" the fixture database rows between the Position Rows.  And I don't think it will let you put the first fixture on the same row as the position name.

 

For the manual option, either user one of the User Fields or attach a custom record the the first Fixture in each position and manually enter the Hanging Position into that field for the first fixture.  Then in Column A, use the field that only has data from the first fixture.

 

For the scriptable version, you will need to write a script that will work with the DatabaseByScript function for the criteria of the database.  The script will have to handle all of the sorting as part of the script as you will not be able to Sort of Summarize the data in the scripted database. The idea would be to script adding a row for the position, then rows for each of the fixtures. Repeat the above for each position. Not especially hard but it can get tricky to make sure the sorting is correct.

 

If you want more information on DatabaseByScript, let me know.

[JamesB1]

Thanks Pat, I shall give this a try!

[JamesB1]

15 hours ago, Pat Stanford said:

I can only think of two ways to accomplish this.  One is relatively easy, but has a manual component. The second requires a fairly sophisticated script to "interleave" the fixture database rows between the Position Rows.  And I don't think it will let you put the first fixture on the same row as the position name.

 

For the manual option, either user one of the User Fields or attach a custom record the the first Fixture in each position and manually enter the Hanging Position into that field for the first fixture.  Then in Column A, use the field that only has data from the first fixture.

 

For the scriptable version, you will need to write a script that will work with the DatabaseByScript function for the criteria of the database.  The script will have to handle all of the sorting as part of the script as you will not be able to Sort of Summarize the data in the scripted database. The idea would be to script adding a row for the position, then rows for each of the fixtures. Repeat the above for each position. Not especially hard but it can get tricky to make sure the sorting is correct.

 

If you want more information on DatabaseByScript, let me know.

 By only adding the position to one fixture in the User field, the worksheet will then only show that one fixture and not the rest of the fixtures that actaully have that position. 

 

 

Column A is looking at User Field 1

Edited April 9 by JamesB1

[Scott C. Parker]

You'll need to turn off Summarize for that column.
Then, you'll need to use other columns to force sorting in the order you wish to have the info displayed.

[JamesB1]

Ah yes. 

However, doesn't resolve the issue of the worksheet only seeing one fixture in that hanging position. 

[Scott C. Parker]

 

3 hours ago, JamesB1 said:

For the manual option, either user one of the User Fields or attach a custom record the the first Fixture in each position and manually enter the Hanging Position into that field for the first fixture.  Then in Column A, use the field that only has data from the first fixture.

Please post a sample file showing how you used the User Field or a custom record mentioned above. It'll help us explain how to get where you need to be.

[JamesB1]

Thanks Scott, See below

HangingPositionWorksheets.vwx

[Pat Stanford]

Add an additional Column for 'Lighting Device'.'Position'. Sort on that column. Set the width of that column to Zero.