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.
App formula =
[Building (REF)].[Building (Text)]&" Floorplan "&[Floor (Number)]
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)]) ) )
That’s all! Let’s use the new app.