Schedule Autofill

[Jessicas]

Hi All,

I'm looking for a way for a schedule to autofill a parameter. Is there a way that you have a room schedule and when you place a room it can auto fill a text project parameter? See attached schedule photo. What I want is that when I place a room it takes the perimeter of each room to tally the amount of feet of baseboard/crown moulding and can auto fill the first column with either word "Crown" or "Baseboard". We do not want to have to retype this for every project to save time. 

[barthbradley]

Not sure what you're wanting. Perimeter is already a parameter. You can rename in the Schedule to whatever you want, like "Baseboard for instance, or you can write a calculation parameter for "Baseboard" (e.g. =Perimeter).  

[Jessicas]

I want that blank box in the schedule to auto fill with the word "Baseboard" or "Crown" when the room is placed... these schedules are exported to excel where they are reformated and select items are turned into user select options. Then passed on to a sales person who can select the exact type of baseboard or crown moulding. 

[ToanDN]

It fills with the value of the element. You can set a Wall Sweep type to the name you want and use that type name for the schedule.

[barthbradley]

Wouldn't all the rooms shown in the Room schedule have "Baseboard" then? I mean, a Room Schedule is reporting rooms.  

[Jessicas]

See we dont actually draw the baseboards and crown, so the schedule currently takes the perimeter of each room placed to calculate a crown/baseboard length, and there's a text project parameter to label the length as baseboard/crown.

 @barthbradley All our rooms always have baseboard. We are a modular construction company and build the houses we draw.

[ToanDN]

I see. You can create a Room Key schedule to set the parameter to a fixed value.
https://knowledge.autodesk.com/support/revit-products/learn-explore/caas/CloudHelp/cloudhelp/2016/EN...

[barthbradley]

You say you "want that blank box in the schedule to auto fill with the word "Baseboard" when the room is placed", and you say "all our rooms always have baseboards".  What am I missing here?

[Jessicas]

Sorry the pictures didn't show up the first time i saw your reply... How did it show up like that for you with baseboard written? did you type it each time? 

@barthbradley - What I'm trying to say is when I currently place the room that column shows up empty and you have to manually type in the cell, that is the problem.  We want that when a room is placed it automatically fills that spot with the necessary word so that the issue of user error is reduced (1 person write base, the next misses a capital letter, another has a typing mistake and so on). We need that column for the excel file and it needs to be the same every time for the excel coding to work.

It may seem like a trivial thing to some people and thats alright. We work on 5+ projects a day each and this is to save time and the amount of opportunities for error. This schedule and a few others like it can save us up to 10 minutes a project, so if we can find a way for some items to populate simply by placing 1 item and not needing to type anything into schedules manually it would be really benificial to us.

[ToanDN]

You could select all the Rooms with baseboard and type in once.  Or group them as a single row in the schedule and type in once.

If you want automated then look into using Room style based on a Key schedule as I mentioned earlier.  Though it is more suited for more complex projects where you need various sets of finish across the projects.

[barthbradley]

---

@Jessicas wrote:

It may seem like a trivial thing to some people and thats alright. 

---

I never said it was trivial, just that I don't understand why you can't do automatically like I did.  I didn't type "Baseboard" 10 times. Every time a room is reported in the schedule, "Baseboard' shows up next to it automatically.  

[barthbradley]

...so what was the solution, @Jessicas?  

[Jessicas]

I dont understand what I'm missing then either.... Now I am mostly self taught on schedules and I think I've done a pretty good job for the most part but I'm obviously missing something then 

ToanDN soloution works but yours is ideal doing it on its own..... but how? What am i missing?

[barthbradley]

---

@Jessicas wrote:

I dont understand what I'm missing then either.... Now I am mostly self taught on schedules and I think I've done a pretty good job for the most part but I'm obviously missing something then 

ToanDN soloution works but yours is ideal doing it on its own..... but how? What am i missing?

---

Have @ToanDN explain it to you since you gave him the solution credit.  

[Jessicas]

@barthbradley - I took the soloution credit back already, I was settling with his idea since it would work, I didnt know yours did it automatically at that point, if your way does it automatically I want to learn how to do it.

[Corsten.Au]

Hi

You can change these parameters of the ROOM before placing the ROOM, and they will be consistent ..

I think the problem is you are not paying attention to these default parameters which are getting

placed and later ending up making manual changes..

SECONDLY, if you want some new parameter here, then CREATE a shared INSTANCE parameter, and

change the value to correct one and then PLACE the ROOM..

To have some clarity, you may create a dedicated Floor Plan, and COLOUR code the rooms as 

per your parameter value ( ex-Mould light Red, Crown - Light Yellow ), this will help you to keep a check as well..

There are multiple ways to achieve what you are looking for, but requirement is you need a way to

identify that parameter, sort and filter in Schedule or plan.. and assign correct value..

Cheers