Hi,
Weโre fairly new to the building of apps. So far weโve been going fine but seem to have hit an issue with Ref in Columns.
Weโre trying to Ref one table to another, weโre achieving the card view of the table weโre referencing. But no returns are showing. When we then view the data in the tables tab. Itโs showing the refโd column/rows as empty. So isnโt able to link the two together to get a return answer.
Any help would be appreciated. (Image is attached)
Hi @Greener_Power1! Welcome to the AppSheet Community!
We really need to see how the two tables are defined and then the definition of the Ref column.
Looking at the image you supplied, it appears to indicate that the Note field is the key column. That definitely is not going to work. Though that may not directly affect the Ref column it does question if the tables are setup correctly.
In a nutshell, at a minimum, the table you are using as the Ref source must have a key column. I recommend having a dedicated column used ONLY for the key and then using the UNIQUEID() function to set this value automatically for any new rows.
In the table that is referencing the source, include the desired column, set its type to โRefโ and then set the source table.
Please ask any questions. You can also refer to the article below for more information
If you need to limit what values show on the dropdown
User | Count |
---|---|
43 | |
26 | |
25 | |
14 | |
11 |