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

(Arnaud B.) #1

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.) #2

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)

(Tony Fader) #3

@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

(Tony Fader) #4

@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.) #5

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.