topic Schedule formula in Revit Architecture Forum

Schedule formula

Anonymous — Thu, 16 Nov 2017 21:52:10 GMT

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.

Re: Schedule formula

ToanDN — Thu, 16 Nov 2017 21:54:53 GMT

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

Re: Schedule formula

Anonymous — Sat, 18 Nov 2017 09:37:31 GMT

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)]

Re: Schedule formula

ToanDN — Sat, 18 Nov 2017 09:44:52 GMT

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

Re: Schedule formula

Stanis-74 — Sat, 18 Nov 2017 11:12:24 GMT

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

Re: Schedule formula

Anonymous — Sat, 18 Nov 2017 14:33:21 GMT

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?

Re: Schedule formula

Anonymous — Sat, 18 Nov 2017 14:53:01 GMT

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

Re: Schedule formula

Stanis-74 — Sat, 18 Nov 2017 15:55:25 GMT

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.

Re: Schedule formula

ToanDN — Sat, 18 Nov 2017 17:22:09 GMT

@Anonymous

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

Re: Schedule formula

Anonymous — Sat, 18 Nov 2017 18:47:39 GMT

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

Re: Schedule formula

Stanis-74 — Sat, 18 Nov 2017 18:57:16 GMT

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

Re: Schedule formula

Anonymous — Sat, 18 Nov 2017 21:07:13 GMT

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

Re: Schedule formula

ToanDN — Sun, 19 Nov 2017 06:33:18 GMT

@Anonymous

Well done!