Zero suppression in door numbers

[sharla]

I know I have seen this before, but I can not find out where to change it right now. I have a room # that is 001. The Room tags are displaying correctly, but the door tags are not. Our door tags are set up to read the room number. Where do I find the setting that controls this for the door tags?

[sharla]

I've narrowed down the problem. For door numbers, we reference the room # and we have a manual definition for a suffix. Then we combine these two with a formula to produce the door number. The number appears correctly (001) in the room # category but once the formula adds the suffix, that is where the 00 is lost. Is there a fix for this situation? Is it because it's a formula?

[Chuckyd67]

The forumla I have always used simply shows the room number and suffix side by side.

However, I have never had your problem because we always begin room numbering at 101.

[dkoch]

What does your formula property look like?

What sort of suffix are you adding?

I do not have time to test this right now, but something like this, where all values are converted to strings, should work, provided that you can live with a string as the result of the formula property

"[roomnumberproperty]" & "[suffixproperty]"

[Chuckyd67]

David, shouldn't the door number actually be the room number?

[dkoch]

Yes, it should. Thanks for pointing that out. I fixed it in my original post.

[sharla]

Our RoomNumber is a location property def. and the Suffix is a manual prop. def. Using a formula to combine them produced: [RoomNumber][NumberSuffix]

In the Style Manager, the RoomNumber category reads the number correctly from the space, it's just in the formula category where it drops the two 00's.

I'm not sure I'm following what you mean by converting them to strings.

Our suffix's are usually "a", "b" ect if there are multiple doors in the room. This particular door does not have a suffix as it's the only door in the basement. I think if I try to delete the suffix for this one door tag, it would reek havoc on my schedule, wouldn't it? there are other doors in the project that are using suffix's.

[dkoch]

Our RoomNumber is a location property def. and the Suffix is a manual prop. def. Using a formula to combine them produced: [RoomNumber][NumberSuffix]

In the Style Manager, the RoomNumber category reads the number correctly from the space, it's just in the formula category where it drops the two 00's.

I'm not sure I'm following what you mean by converting them to strings.

Our suffix's are usually "a", "b" ect if there are multiple doors in the room. This particular door does not have a suffix as it's the only door in the basement. I think if I try to delete the suffix for this one door tag, it would reek havoc on my schedule, wouldn't it? there are other doors in the project that are using suffix's.

Your formula uses implied concatenation, which does not always give the desired results, as in this case. Use explicit concatenation, with the property references enclosed in pairs of double quotation marks. My generic example
"[roomnumberproperty]" & "[suffixproperty]"
would be
"[RoomNumber]" & "[NumberSuffix]"
for your specific case.

[sharla]

Beautiful! Thank you! That works perfectly.