Hello, in all columns that are of type ref,...

references
(Tiago Maciel) #1

Hello,

in all columns that are of type ref, a yellow triangle appears as in the image. How can I resolve this situation?

(GreenFluxLLC) #2

The yellow triangle indicates that the value in your ref-column does not match any of the key-column values for the reference table.

It looks like you are storing the name or label, instead of the key value from the referenced table. Column type ‘ref’ works by storing only the key-value, and linking to an entire row from another table. This will still display the label-column you want from the referenced table, even though the stored value is a key.

(Aleksi Alkio) #3

…and this can happen quite easily if you for example change your key column (in those related tables).

(Tiago Maciel) #4

@GreenFlux@Aleksi_Alkio So how can I solve the problem?

(GreenFluxLLC) #5

@Aleksi_Alkio is right. This happens easily if you change a column type to type-ref, but the column doesn’t actually contain valid keys from the reference table. So you could fix it by individually editing each row and replacing the text with the appropriate key value.

(Tiago Maciel) #6

@GreenFlux how I do that