I’ve data in table_2 and ref to table_1. When i read data from view, one adverstisement appear next to text. Why ?
DESCRIPTION_FIELD in TABLE_1. - I set a REF type to TABLE_2 in this field
When i add new row in TABLE_1, the DESCRIPTION_FIELD dropdown show me UNIQUEID() key of TABLE_2 …
if i set an app formula to my DESCRIPTION_FIELD like =select(TABLE_2[Descriptor], true) then i’ve this exclamtion point who appear.
if don’t set app formula, no exclamation point but my data is wrong (it is the uniqueid() key value)
@Arnaud_B I don’t completely understand. But the yellow triangle means there’s a broken reference. You may want to read up on table references, keys, and row labels.
help.appsheet.com - References Between Tables https://help.appsheet.com/data/columns/row-labels https://help.appsheet.com/data/columns/what-is-a-key https://www.appsheet.com/samples/This-app-shows-the-difference-between-keys-and-row-labels?appGuidString=53280014-1d95-4d1f-93e5-a2a2e9be53a5 References Between Tables help.appsheet.com
@Arnaud_B Also, the SELECT expression returns a list of values. If you know that it returns a single value, you can use ANY(SELECT(…)) to access it.
What i understand: when i make a ref to another table, return value is the key row. The problem is the key row is uniqueid(). And the value i want in return is long text.