topic Re: Concatenate Field in Schedule in Revit Architecture Forum

Concatenate Field in Schedule

rmarkowitz — Sat, 12 Oct 2019 00:02:04 GMT

Hi All -

I understand in Revit 2018 and up you can create a field in a schedule that allows you to concatenate multiple parameters into a single field (Length, Width, and Height into LxWxH, for instance). What I want to do is concatenate the mark numbers of several instances into 1 field.

Lets say I have instances of a family with marks 01, 02, 03, and 04. 01 and 02 have a parameter set to A and 03 and 04 have a parameter set to B. When I create a schedule by the lettered parameter, I want a column to show all instances' marks in that parameter (The row for A would show 01, 02, etc. and the row for B would show 03, 04, etc.).

Is there a way to do that? Thanks very much in advance.

Re: Concatenate Field in Schedule

bin — Sat, 12 Oct 2019 02:39:36 GMT

You will need Dynamo for this.

Re: Concatenate Field in Schedule

barthbradley — Sat, 12 Oct 2019 17:35:56 GMT

Why not assign another Parameter to the scheduled elements that holds the "A" and "B" value, and the Sort and Group your Schedule by this Parameter?

Re: Concatenate Field in Schedule

bin — Sat, 12 Oct 2019 18:30:59 GMT

I think I misread your post, @barthbradley is right, just sort your schedule with that named parameter(A&B)

Re: Concatenate Field in Schedule

Ziqq — Sun, 13 Oct 2019 02:06:09 GMT

Hello

You can play with the formating

Rather than Concatenate, just place the values next to each other in the columns

and get rid of grid line so that it looks like one value.