Similar configuration different reference display results

AppSheet AppSheet Q&A
1

Hi.
I have the following relations.

2X_4_4f4edd43e7f5620ddcb127fcd1b4e54b81093f82.png
2X_4_4f4edd43e7f5620ddcb127fcd1b4e54b81093f82.png1116×874 33.8 KB

I obtain the expected relation and display from a Client record showing its related Commande. Unfortunately I cannot say the same from Tâch (Side note I do no know why on this graph the name is Tâch instead of Tâches)

On the scenario below I expect 3 results but I get 5.
The reference is REF_ROWS(“Commandes”, “Tâches ID”)
Where should I look to fix this?

2X_9_91e569a9e29eb3143c24eb3663d1a7210a7bd221.png
2X_9_91e569a9e29eb3143c24eb3663d1a7210a7bd221.png3459×1663 535 KB

2

I found the issue. It was related to the column Tâches set to number instead of Text.

Is it normal that a column set as Key can display text data while being set as a Number and fail the condition in a SELECT/Dereference?

2 Likes