I have an app that allows technicians to install Beacons, Aggregators, and Gateways for a hotel property. The tech must select the Building of the Property, the Floor, and the Area (hotel room, suite, bathroom, hallway, etc.) in which the installation will occur.
Once the tech selects the building and floor, he is then presented with the โAreasโ and must select whether heโs installing a beacon, aggregator or gateway. Sometimes the tech forgets at this point what building and floor he selected. Since you cannot display a header at the top of the screen for a table view, I thought of including an inline action to popup the building and floor selected. There are probably other ways to accomplish the same thing, but nonetheless.
I created a table view called โLocationโ and ordered the 3 columns โBuildingโ, โFloorโ, and โAreaโ. I created an inline action called โDisplay Locationโ with a building icon.
In the โDisplay Locationโ action, Iโm using the following syntax to only show the building, floor and area of the record Iโm on:
LINKTOROW([_THISROW],โLocationโ)
However, Iโm getting everything when I click the building icon:
Whatโs wrong with the syntax or what am I missing. It seems like a simple issue (i.e., to EASILY display the building and floor), but Iโm stumped. Thanks.
Solved! Go to Solution.
The Location view had been a table view. which displays an entire table regardless. Using LINKTOROW() with a table, deck, or gallery view with any row reference is (as far as I can tell) equivalent to using LINKTOVIEW(), which takes no row reference.
What I would do is in the table where the beacons etc are recorded iโd add 3 virtual columns to record the name of the โBuildingโ, โFloorโ, and โAreaโ. Then you can display these either the first table view. But also theyโd be availble in the form when adding a beacon etc.
You could combine them into 1 column with CONCATENATE if this makes it easier to read
Thank you Simon! Yea, I thought of that, but based on the way I will be receiving the data (and the model Iโve set up), Iโm trying to avoid adding virtual columns.
Change the Location view type from table to detail.
Thank you. That worked! Iโve decided to create a separate field, though, as I think that makes more sense, to show the bldg and floor on the table view. I wish you could add a heading at the top of the table view (like you can for a deck view).
For understanding purposes, isnโt the reason the LINKTOROW() didnโt work is because it needed the Row ID of the Location table?
So it should be expressed as
LINKTOROW([_THISROW].[Location Row ID],โLocationโ)
If you donโt have the Location table Row ID (e.g. its a UNIQUEID()), then you can use LINKTOFILTEREDVIEW() and specify the filtering criteria to narrow the rows down to the single row you wished.
Somebody correct me if I am wrong.
The Location view had been a table view. which displays an entire table regardless. Using LINKTOROW() with a table, deck, or gallery view with any row reference is (as far as I can tell) equivalent to using LINKTOVIEW(), which takes no row reference.
Ok. Good to know. I didnโt take the time to play it this time - too busy!!
This is what Iโm here for.
Steve youโre the best! You too John!
User | Count |
---|---|
31 | |
25 | |
22 | |
22 | |
15 |