Key Schedule for Door Schedule Comments

[kmarquis]

I'm setting up my door schedule and my Door Keyed Notes which read like this:

Note 1: Undercut Door 1"
Note 2: Magnetic Hold Open Device
Note 3: Floor Stop.

We have a column in the end of our door schedule where we reference these key notes called "COMMENTS". So the Comments column could read, "NOTE 1, NOTE 3" for example. I've used key scheules before and I'm comfortable with them but I'm wondering if I set up a couple instance text parameters in the doors so that users can pull from a list to pick the condition such as "UNDERCUT DOOR 1" and it will read on the door schedule "NOTE 1". This is easy when it's just one note but sometimes there are 2 or 3. Can I combine a text parameter to read NOTE 1, NOTE 3, NOTE 4?

[Alfredo Medina]

I think the key schedule continues to be the best option in this case. The other possibility is to use an integer parameter that represents the notes, and then you could set up an IF statement in a schedule that uses the integer value to change a string in a text parameter.

[kmarquis]

Thanks Alfredo but I have no idea how to execute this. Right now I have it set up so someone could pick only one of the several choices but if they have more than one it needs to be typed in manually without using the key schedule. Would you be willing to provide a more detailed example of set up? I'm really a novice at formulas. Thanks!

[Alfredo Medina]

i (integer parameter)
t (text parameter)

t =


if(i = 1, "Note 1", if(i = 2, "Note 2", if(i = 3, "Note 3", "none")))

or... t =


if(i = 1, "Undercut Door 1 inch", if(i = 2, "Magnetic Hold Open Device", if(i = 3, "Floor Stop", "none")))