LinkedIn
Twitter
Hi All,
I want to make a building inspections app for multiple buildings, with the functionality of listing all the cracks on an XY/Map layout. It’s only possible to include one layout per table/worksheet, so for different buildings, I have to create multiple tables/worksheets.
I want my Buildings View to list all the buildings, and if you go into the building Detail, it shows you related cracks, like below:
The issue I have now is as follows: The Related Cracks column must change depending on the building that is opened, but I can’t seem to get this to change based on the building. What currently works for a single building, is the following:
But that REF_ROWS formula can’t change the source table. I tried using REF_ROWS(concatenate(“Cracks_”, [Shorthand Name]), “Building”), where the concatenate function calls the specific name of each table (Shorthand Name is defined upon creation of each building, and is used for numbering purposes as well), but Appsheet gives me the error “Function ‘REF_ROWS’ should have exactly two parameters, a table name and a column name of Ref type”.
Is it possible to change referenced to different tables, or is this functionality not supported?
If it’s not supported, are there any other suggestions for the XY/Map layout functionality for different buildings?
Thanks in advance
