As the title suggests, I’m using some REF_ROWS() formulas for one of my tables “Asset_reports”.
In this table I have a column “UID” acting as the key. In a few other tables, I have the same “UID” column which is of type Ref pointing back to this table, acting as a foreign key. Naturally Appsheet automatically creates virtual list columns with a REF_ROWS() formula in the original table, pointing to these tables, but for some reason, the formulas don’t return any rows from these tables.
I double checked the backend data, and am 100% sure, that I have rows in these tables where the content of the “UID” column matches the “UID” column of some rows in the original table “Asset_reports”.
Any ideas to why this is happening? Let me know if you need more information.