Schedule formula

[Anonymous]

thanks in advance.

I am trying to created an override formula. I need some help.

I have a door type, in this case a storefront door, which is apart of difference storefront groups. 

I want to be able to do an instance override frame type, for certain frame types (storefronts) with out having to duplicate a storefront door each time. the same door goes into different size storefront frame systems.

I would like this to show up in the schedules.

[ToanDN]

Make the Frame Type an instance parameter instead of a type parameter.

[Anonymous]

I am trying to create a calculated parameter formula like this in my door schedule

IF(OR([DOOR SCHEDULE - FRAME TYPE OVERRIDE]),yes= [DOOR SCHEDULE - FRAME INSTANCE (Override)], no=[DOOR SCHEDULE - FRAME TYPE (Type)]

[ToanDN]

Is FRAME TYPE a text parameter? If so, it doesn't work in a formula.

[Stanis-74]

make screenshoot on your family types window. 

formula "yes/no" can`t be based on "text" parametr. there is no needs to wright "yes" in condition "yes" in "yes/no" formula  (same for "no")

revit formula syntax: https://www.revitforum.org/tutorials-tips-tricks/1046-revit-formulas-everyday-usage.html

[Anonymous]

yes it is, so whats a work around to achieve this. I'm sure there a way to set something up like this without having to create a new frame stype for every storefront door.

Is the formula not going to read the frame style text because its an instance and not a type?

[Anonymous]

Stanis-74, I overlooked your comment he it is.

Yes I have been looking over that page, but I haven't been able to figure out what I am doing wrong

[Stanis-74]

i`m not sure that understand you right, but chek this:

here in feild "Choose..." you need to number of type that you want to use. name of the types i write in field "result".

if it is not what you need, please, explain step by step what you have now and what you want.

[ToanDN]

@Anonymous

Use number or integer for Frame Type so the formula can work.

[Anonymous]

So you are creating a formula inside the Door itself and not in the schedules?

[Stanis-74]

please, explain step by step what you have now and what you want.

[Anonymous · Accepted solution]

All,

I have successfully figured out the formula to add with the help of someone else.

if you look at the .png files I added to create the parameters what I did next was go to my door schedule and created an additional "Add calculated Parameter"

there I created a formula with

Discipline: Common

Type: text

Formula: if([DOOR SCHEDULE - FRAME TYPE OVERRIDE], [DOOR SCHEDULE - FRAME INSTANCE (Override)], [DOOR SCHEDULE - FRAME TYPE (Type)])

What this does is when the door frame type override is checked, it refers to the instance, if its not it check it will reference the type

[ToanDN]

@Anonymous

Well done!