Transmittal Show Sheet Scale

[bcoe]

Hi All,

 

I am trying to create a document transmittal using the Project Revision History > Create standard worksheet workflow. I've got it looking pretty perfect but I would like the default "Size" column to return the sheet scale instead. Is this possible?

[Pat Stanford]

I don't think there is. The Standard Worksheet format appears to be populated by a script that is buried deep in the Title Block Border library, so there is no good way to edit it.

 

If you could use the Database Worksheet instead of the Standard Worksheet you could go in and edit the data displayed by the database columns to show the Scale instead of the Sheet size.

 

 

='Title Block Sheet Data'.'Scale'

[bcoe]

Thanks, Pat. I originally started with the Database Worksheet and had the scale showing but my project has too many sheets to fit on a single page and I don't believe there's a way toget the Database Worksheet to spread across multiple pages like the Standard Worksheet.

[bcoe]

In case anyone finds this post I found a workaround which works for any project not using multiple files. I put a database worksheet over the top of the transmittal with the following headers;

='Title Block Sheet Data'.'Sheet Number'

='Title Block Sheet Data'.'Sheet Title'

='Title Block Sheet Data'.'Scale'

='Title Block Border'.'Current Revision Number'

In the advanced criteria for the database worksheet add a critria "Field Value, Page Number, <, (number of rows in the transmittal)". For the second sheet of the transmittal dupilicate the database worksheet and change the critera to be > (number of rows -1).
After executing the transmittal, recalculate the Database worksheet before publishing. And publish the sheet layer and not the worksheet.