Locations: building & floors

[#1]

Whenever I think that there's a better way, usually there is... I'm thinking that the issue of buildings and floors -must- have been dealt with before. I can't figure out "Advanced Reference Qualifiers". I think that simply using locations & parents would be fine BUT I can not figure out how to show the parent of the location.

We've set up our "Locations" so that each location is a building.
We'd like to have floors associated within each location like so:
Wall St office (Location)
15 (floor)
16 (floor)
Broadway office (Location)
2 (floor)
15 (floor)
What's the right way to do this...?
I would like this data to reside in cmn_locations, but display on a User record so that we know where a person's building and floor is. We'd also like to show the Caller's office & floor on an Incident. It seems pretty basic, but darned if I can figure it out.
And evenutaully, we'd like to add rooms to the floors like so:
Wall St office (Location)
15 (floor)
rm108 (room number)
rm109 (room number)

[Valor1]

In lieu of re-importing all your locations, you could make a calculated field, and set it as the display value of the table.

You have:

- Wall St
   - 15th floor
   - 16th floor
     - Room 108

Use the "name" field on sys_user as an example of calculated field.
Create a field called "Complete location" of a string type, and personalize the field dictionary. mark it "Display" and "Calculated."
Put this in the "Calculation" entry:

if(!current.parent.nil()){
   current.parent.getDisplayValue() + " - " + current.name;
}

This will result in a display value of "Wall St - 16th floor - Room 108"
If that's too long to display, You could do "Wall St - 16/108" by the following

if(!current.parent.nil()){
   if(current.paren.getDisplayValue()indexOf(' - ') >0){
      current.parent.getDisplayValue() + "/" + current.name;
   }
   else {
      current.parent.getDisplayValue() + " - " + current.name;
   }
else{
   current.name;
}

...Or am I not understanding what you're trying to accomplish?

[#3]

Valor --
Thanks for your patience and replies... I appreciate your input.
I'm not really after a single field showing Bldg - Floor - Room, though that is an interesting approach. Also, I don't mind having to do bulk loads or re-loads (that's something I feel very comfortable doing).
I think the crux of my problem is that I want to display the following
on User table, a Location, Floor, and Room as dependent fields, referenced from the Location table
on Incident table, display those dependent fields for the Caller

And I think what I'm not getting (maybe "refusing to get" would be more accurate!) is that you can't reference dependent fields.
John

[Valor1]

If you want something like the image attached, you will have to make a number of changes..

1. add a "location type" field on your location table, with dropdown list options of "Site," "Building," and "Floor"

2. on your user table, add 3 fields: "Site location," "Building," and "Floor." You will need to add a basic reference qualifier to each of these with "u_location_type=xxxx"

3. On your incident form (or whereever) show the related fields caller.site, caller.building, and caller.floor...

Is this what you're going after?

[Earl L]

I know this is an old thread, but I used the technique suggested here for calculating a field for building, floor, room as suggested by Valor. When I'm using this in the incident default view it seems to work correctly, i.e. allows me to see the calculated value when I do a location search and it saves the record correctly (hovering over the info icon displays the correct building, floor room) but the location doesn't display in the form otherwise (see image attached).

I've set the calculated field to be the display value for the table, and as I said the lookup/search and assignment of the location to the incident all apear to work fine but without the calcuated value displaying on the incident form it's of limited use.

Does anyone know, does this require a client/UI script in order to display the calculated value on the incident form?

Earl