Experiencing Ref Issue

Greener_Power1 · 04-21-2020 05:06 AM

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)

WillowMobileSys

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