I've data in table_2 and ref to table_1. When...

[Arnaud_B]

I’ve data in table_2 and ref to table_1. When i read data from view, one adverstisement appear next to text. Why ?

[Arnaud_B]

OK. I’ve:

• 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)

[tony1]

@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?appGuidSt... References Between Tables help.appsheet.com

[tony1]

@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.

[Arnaud_B]

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.