How to manage multiple floor plans in AppSheet?
AppSheet is a great solution for engineering industry. Thanks to the map function with its own background, we can mark the details on the building plan (or another image).
We may often have to manage multi-storey facilities.
In this post, I will show you how to create an application for managing multiple floors in the building quickly and efficiently.
- You will need 3 basic tables in which we can add new information at will.
- Buildings – for storing information about the building
- Floor plans – for storing the map backgrounds
- Entries – to create an entry using the building and its floor plan
Tables and columns
Buildings
Let the building name in the Buliding (Text) column be the key and label (AppSheet’s settings)
After linking this table with others, two additional ones will automatically appear: the related floor plans and entries.
Floorplans
Let’s assign the floor plans for the building.
Next, select the building, define the number of the storey and attach the map in raster format (JPG or PNG)
The key and label will be added to the virtual column, the formula of which is:
App formula =
[Building (REF)].[Building (Text)]&" Floorplan "&[Floor (Number)]
Entries
In this table we will store the results of our work with the app. We will be able to choose which building and floor our entry applies to, i.e. the location on a given map background.
The third column with the „XY” type will store the coordinates in text form. We need to define what map background the application should display.
Background image for the XY coordinates =
[Floorplan (REF)].[Floorplan (Image)]
After linking this table with others, an additional table with related entries will automatically appear.
Additionally, we want the application to filter the stories. In the form, we want to select only the floors of the building we choose.
The Valid If field of the Floorplan (REF) column is used for this:
Valid If =
FILTER(
"Floorplans",
AND(
ISNOTBLANK([Building (REF)]),
([Building (REF)] = [_THISROW].[Building (REF)])
)
)UX
We will need 3 views to ensure basic functionality.
Feel at ease and choose your favorite view. In this example, I use the following division:
Feel at ease and choose your favorite view. In this example, I use the following division:
How it works – workflow
That’s all! Let’s use the new app.
- Add the new building (you can always add all information you need by creating new columns to the table)
- Add floor plans to the building. Choose the buliding from these you added and the number of the floor. Attach the image.
- Create the first entry! Choose the building and the storey. The map will show automatically. Mark the location on the map
Conclusion
Feel free to build your own app! It’s really easy.
Inne wpisy
19 lipca 2023
Znasz osobę w swoim zespole, która wydaje się być dobra we wszystkim? Mam na myśli dosłowną definicję słowa "dobry". Nie mistrzowski. Dobry.
1 lipca 2023
Ależ ten czas mija!
Pod koniec roku 2020 po raz pierwszy napotkałem na AppSheet. Uwierzcie lub nie, ale wtedy poczułem, że to będzie dla mnie coś dużego.
19 czerwca 2023
Co-mentoring lub mentoring odwrócony to świetny sposób na rozwój umiejętności i zdobycie nowej perspektywy na prowadzenie biznesu w dobie nowoczesnych technologii.
17 czerwca 2023
Drugi kurs dla praktyków (szczególnie dla PM-ów, analityków biznesowych, studentów czy deweloperów) składający się z 8 modułów kończący się egzaminem.
17 czerwca 2023
Rynek chmury rozwija się w niezwykłym tempie. Wiele osób (w tym ja) widzi ogromny potencjał w działaniu cloud-native. Również w sferze Hardware!