Results 1 to 4 of 4

Thread: Create Parameter to Report Last Four Digits of Sheet Number

  1. #1
    Active Member
    Join Date
    2012-04
    Location
    Los Angeles, CA, USA
    Posts
    84
    Login to Give a bone
    0

    Default Create Parameter to Report Last Four Digits of Sheet Number

    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.

  2. #2
    Super Moderator david_peterson's Avatar
    Join Date
    2002-09
    Location
    Madison, WI
    Posts
    5,687
    Login to Give a bone
    0

    Default Re: Create Parameter to Report Last Four Digits of Sheet Number

    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.

  3. #3
    Active Member
    Join Date
    2012-04
    Location
    Los Angeles, CA, USA
    Posts
    84
    Login to Give a bone
    0

    Default Re: Create Parameter to Report Last Four Digits of Sheet Number

    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.

  4. #4
    Super Moderator david_peterson's Avatar
    Join Date
    2002-09
    Location
    Madison, WI
    Posts
    5,687
    Login to Give a bone
    0

    Default Re: Create Parameter to Report Last Four Digits of Sheet Number

    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.

Similar Threads

  1. 2015: Converting a text parameter to a Number parameter
    By valejandro_ibarra in forum Revit Architecture - Families
    Replies: 5
    Last Post: 2019-04-25, 05:49 PM
  2. Diesel Code return last 2 leters/digits of sheet title...
    By cad user in forum AutoCAD Fields
    Replies: 3
    Last Post: 2014-12-13, 03:45 AM
  3. 2013: Adding Parameter to Revision Cloud to create report
    By Chris.Partin in forum Revit Structure - General
    Replies: 4
    Last Post: 2013-07-23, 10:22 PM
  4. Create Sheet Lists and Total Sheet Count for Subsets in Sheet Set Manager
    By autocad.wishlist1734 in forum AutoCAD Wish List
    Replies: 0
    Last Post: 2008-10-12, 06:30 PM
  5. Show View Number and Sheet Number in the same field?
    By kkinchen in forum AutoCAD Fields
    Replies: 3
    Last Post: 2007-03-19, 05:48 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •