View Full Version : 2017 Create Parameter to Report Last Four Digits of Sheet Number
KoryCox
2018-01-09, 02:14 AM
The project I'm working on requires a long and complicated sheet numbering code. Naturally, this makes a mess of callout bubbles, section heads, etc. I want to create a parameter in the section head family that will report only the last four digits of the sheet number.
An example of the text that fills the "Sheet Number" parameter field:
C01-FCS-AR-A200
What I would like to show in the section head:
A200
How would you approach this?
I know excel has a "Right" function whereby you specify how many characters from the right you want to report. I am hoping to find a similar way in Revit.
david_peterson
2018-01-10, 02:42 PM
Dynamo is about the only way I can see this functioning and it'll be a 2 or 3 step process.
You can use Dynamo to get all of the views on sheets, get the parameter data needed from those views (Element ID and Referencing sheet) and dump that out to excel.
Set up the excel sheet as you've mentioned above and fill out that data column.
Then use Dynamo to slam that data row back into the parameter you created.
Another approach may be similar, but creating a shared sheet parameter that you can use in the tag so the parameter data doesn't live in the view, but is written to the sheet.
If the sheet number changes you'll need to run the dynamo graph again, but that actually sounds a lot easier to me now that I think about it.
Have Dynamo get all the Sheets in the project and return the sheet number, then use excel to generate the last 4 digits. and Dynamo to slam it back in.
Before I would do any of this I would make sure the building owner is ok with it. The last 30 or 40 projects I've worked on where the building number was part of the sheet numbering scheme, it was required to have that number listed as the reference.
Check out the DynamoBim.com page and search around in the forums. Someone may have already developed the solution.
KoryCox
2018-01-10, 06:18 PM
I thought about doing it with shared parameters also. That was going to be my next test.
Of course doing it that way, Dynamo isn't even necessary. Once the parameter is setup I can export the sheet list out to Excel, use the RIGHT function to get the last four digits then re-import using the BIMLink plug-in from Ideate.
Hang on, I'm trying this now. Can I even use Shared Parameters in a section head family? The button to add a new parameter in the label properties is grayed out.
david_peterson
2018-01-10, 06:25 PM
Looks like you'll need to force a parameter to it as well.
I thought you could add shared sheet parameters to it, but it doesn't look like you can.
Everything is grey'd out so they might be hard coded and locked.
There might be ways around this, but it would require some out of the box thinking and I'm still not sure it's possible.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.