Forums >> Revit Building >> Technical Support >> Revit 2016 Annotative Demo Tag Formula

HermanMunster

active

Joined: Fri, Dec 13, 2013
0 Posts

We have successfully created a demo annotative tag which populates our noteblock schedule. See attached. Any help on what the formula would be for the note number to read the note text in the parametere?

Right now it does however tag 001 is REMOVE EXISTING GLASS DOOR AND HARDWARE needs to be revised to tag 005 REMOVE EXISTING CANOPY AND STRUCTURE. We would like to revise the number in the tag and have the note automatically update.

What we want to achieve is editing the demo tag in plan and having the schedule populate. If the tag number revises the schedule updates.

See attached. And Thank you

Attached Images

Attached Files 145135_Note_Tag_Demo.rfa

This user is offline

Shatner86

active

Joined: Fri, Feb 24, 2012
2 Posts

Hey HermanMunster,

Not sure I'm following, but are you saying you want "Note Text" to change depending on what number is entered within "Note Number?"  You can do this with If formulas. Create an integer parameter; I called it 'UI'. Then create parameters (Text) and call them 'One', 'Two' etc. then within Text Note make an IF formula stating

if(UI = 1, One, if(UI = 2, Two, if(UI = 3, Three, "Enter Value")))

Within  Note Number repeat the above but replace parameter names with input, so:

if(UI = 1, "001", if(UI = 2, "002", if(UI = 3, "003", "No Value")))

That will allow you produce a output from a simple number, you can create as many options as you like. Whether this is the right way to go about this, pass. I just read your post and decided to see if i could find a workable solution.

In terms of the schedule, I would hide the "UI" and filter out the "No Values", but it depends on what you're trying to achieve.

Hope it helps.

Kind Regards,

Shatner86

Attached Images

-----------------------------------

"Try not to become a man of success, but rather to become a man of value"

-Albert Einstein

This user is offline

HermanMunster

active

Joined: Fri, Dec 13, 2013
0 Posts

Shatner thank you so much for your post. I will implement this and let you know how it works. Essentially we want to edit the tag in plan and have the noteblock update automatically based on the number. Have a great day

This user is offline

HermanMunster

active

Joined: Fri, Dec 13, 2013
0 Posts

Ok I can't get the value to work. What the heck am I doing wrong. See attached

Attached Images

This user is offline

HermanMunster

active

Joined: Fri, Dec 13, 2013
0 Posts

solved

if(Number = 1, "REMOVE EXISTING EXTERIOR CURTAIN WALL  SYSTEM ", if(Number = 2, " REMOVE EXISTING CONCRETE CURB", if(Number = 3, " REMOVE EXISTING CONCRETE BLOCK WALL IN ITS ENTIRETY ", if(Number = 4, " REMOVE EXISTING STUD WALL SYSTEM IN ITS ENTIRETY ", if(Number = 5, " REMOVE EXISTING INTERIOR PARTITION IN ITS ENTIRETY", if(Number = 6, " REMOVE EXISTING CONCRETE  WALL", if(Number = 7, " REMOVE EXISTING INTERIOR CLADDING STONE STAINLESS STEEL PLASTER ", if(Number = 8, " REMOVE EXISTING EXTERIOR CLADDING", if(Number = 9, " ALL EXISTING PRECAST PANELS ON COLUMNS TO BE REMOVED TO STRUCTURE INCLUDING INSULATION AND MEMBRANE.", if(Number = 10, " REMOVE EXISTING CONCRETE  WALL", if(Number = 11, " REMOVE EXISTING FACE BRICK IN ITS ENTIRETY ",if(Number = 12, " REMOVE EXISTING SIDING IN ITS ENTIRETY", if(Number = 13, " REMOVE EXISTING DOOR FRAME AND HARDWARE",  if(Number = 14, " REMOV REMOVE EXISTING DOOR ,SIDELIGHT,FRAME AND HARDWARE ", if(Number = 15, " REMOVE EXISTING OVERHEAD DOOR FRAME AND HARDWARE ", if(Number = 16, " REMOVE EXISTING GLASS DOOR AND HARDWARE ", if(Number = 17, " REMOVE  EXISTING REVOLVING DOOR AND HYDRAULIC ASSIST EQUIPMENT LOCATED IN THE PARKADE BELOW ", if(Number = 18, " REMOVE EXISTING DOOR STOPS",  if(Number = 19, " REMOVE EXISTING DOOR THRESHOLD AND INFILL AS REQUIRED",  if(Number = 20, " REMOVE EXISTING WINDOW, FRAME AND HARDWARE ", if(Number = 21, " REMOVE EXISTING GLAZING, FRAME AND HARDWARE ", if(Number = 11, " REMOVE EXISTING WINDOW COVERINGS",  if(Number = 22, " REMOVE EXISTING CANOPY AND STRUCTURE", if(Number = 23, " REMOVE EXISTING SOFFIT AND SUPPORT STRUCTURE ", if(Number = 24, " REMOVE EXISTING GUARDRAIL", if(Number = 25, "    REMOVE EXISTING HANDRAIL", if(Number = 26, " REMOVE EXISTING MEZZANINE AND STRUCURE ASSOCIATED",  if(Number = 27, " REMOVE EXISTING GATE,HARDWARE AND ENCLOSURE ", if(Number = 28, " REMOVE EXISTING FLOORING AND SETTING SYSTEM DOWN TO EXISTING CONCRETE SLAB. LEVEL EXISTING CONCRETE FLOOR SLAB TO ACCEPT INSTALLATION OF NEW  FLOOR FINISH", if(Number = 29, " REMOVE EXISTING STAIRS, HANDRAILS AND GUARDRAILS IN THEIR ENTIRETY", if(Number = 30, " REMOVE EXISTING STAIR AND HANDRAIL", if (Number = 31, " REMOVE EXISTING ESCALTOR AND ASSOCIATED EQUIPMENT. INFILL ESCALATOR PIT AS REQUIRED", if(Number = 32, " REMOVE EXISTING PARAPET IN ITS ENTIRETY", if(Number = 33, " REMOVE EXISTING PARAPET CAP ", if(Number = 34, " REMOVE EXISTING GARBAGE ENCLOSURE ", if(Number = 32, " REMOVE EXISTING GARBAGE BINS AND TURN OVER TO OWNER ", if(Number = 35, " REMOVE EXISTING ASPHALT PARKING AREA ", if(Number = 36, " REMOVE EXISTING WHEEL STOPS ", "End" ))))))))))))))))))))))))))))))))))))

This user is offline

Shatner86

active

Joined: Fri, Feb 24, 2012
2 Posts

HermanMunster, 

Yeah sorry a screen shot might have explained the parameter method more easily. However seems you got the text method nailed! The advantage of using parameters to hold the text is that it'll be alot easier to edit should you to. 

Also, in case you haven't noticed. Number 14 has a typo:

 if(Number = 14, " REMOV REMOVE EXISTING DOOR ,SIDELIGHT,FRAME AND HARDWARE ",

"REMOVE EXISITING DOOR, SIDELIGHT, FRAME AND HARDWARE"

Kind Regards

-----------------------------------

"Try not to become a man of success, but rather to become a man of value"

-Albert Einstein

This user is offline

HermanMunster

active

Joined: Fri, Dec 13, 2013
0 Posts

Cheers Shatner.

This user is offline

marmiketin1

active

Joined: Wed, Aug 19, 2015
0 Posts

It might be more effective to set a text parameter for each string you want as your note text.

ex. one = " REMOVE EXISTING EXTERIOR CURTAIN WALL  SYSTEM "

     two = " REMOVE EXISTING CONCRETE CURB "

then your formula would be if(Number = 1, one, if(Number = 2, two, if(Number = 3, three, if ...

this way you would more easily be able to see what each note number is as they would be referenced outside of the if statement. this would also allow you to more easily edit a note if needed instead of trying to find it in that string of nested if statements.

This user is offline

Shatner86

active

Joined: Fri, Feb 24, 2012
2 Posts

Hey marmiketin1,

This is I said at the start. But both routes works. 

Kind Regards,

Shatner86

-----------------------------------

"Try not to become a man of success, but rather to become a man of value"

-Albert Einstein

This user is offline

HermanMunster

active

Joined: Fri, Dec 13, 2013
0 Posts

I agree with both and for ease I have created the formula as a word document so I can see what is what and then paste it into the formula. I am very grateful for all the feedback

This user is offline

Revit 2010 family parameters formula and room tag

4

ROOM TAG AREA FORMULA

3

Massing appears when exporting from revit 2016 to navisworks 2016

2

Specific Demo/Plan notes

0

Revit 2016

12