Linktoform() and passing data to a referenced dropdown form

[MarLew]

Hello,
I am using the inbuilt database and I have three tables:
EQUIPMENT
CTRL_AAA
CTRL_BBB
Column SN is in EQUIPMENT and referenced in CTRL_AAA and CTRL_BBB

In my action I have this :
LINKTOFORM(SWITCH([TYPE],"AAA",CTRL_AAA,"BBB",CTRL_BBB,CTRL_AAA),SN,[SN])

When SN gets to the form it looks like this:

The SN value sent does not arrive in the Form as one of the preset references in the drop down list.
I think this must be some sort of type/format problem but I can't pin point it.
Any ideas?

[jballester]

Hi, 

You can check that the data value, format, in the SN column in the target table (CTRL_AAA or CTRL_BBB) is the same as in the source table (EQUIPOS).

[MarLew]

In AppSheet Database EQUIPEMENT is Text

Also in the Appsheet app tab

and CTRL_AAA is Reference

and in the AppSheet App tab

Surely when one column is a reference of the other they both have the same type... right?

[MarLew]

Thx for the reply,
Yes the SN in EQUIPMENT is TEXT and the SN in CTRL_AAA & CTRL_BBB is a reference to SN in EQUIPMENT which I suppose is of the same type.

I tried this too but to no avail : LINKTOFORM(SWITCH([TYPE],"GERBEUR",CTRL_GERBEUR,"CHARIOT ELECTRIQUE",CTRL_CHARIOT_ELEC,"CHARIOT GAZ",CTRL_CHARRIOT_GAZ,CTRL_GERBEUR),"SN",TEXT([SN]),"6c569d84-608b-48c6-acd8-25505579c5cd")

So in the end (and it's a little frustrating) I took the reference off the SN in CTRL_AAA & CTRL_BBB tables

[Steve]

Everything you've said and shown about the AppSheet Database configuration is irrelevant. What matters is the app's configuration. Please post screenshots of the configurations of the SN columns from the app editor. Please also post screenshots of the column list screens for the tables that include at least the key columns and the SN columns.