Value in field cannot be converted to type "Ref"

When there are only numbers in a reference table ( 1 2 3 ) all works fine but when these numbers in this reference table are changed into a combination of number and letter, for example “P 1” the field can be scanned by appsheet (P 1 is shown) and the reference works fine but when the new entered data is synchronised then Appsheet says; Value in field cannot be converted to type “Ref”. Synchronisation is not completed then.
How can this be solved? In this case a combination of letters and numbers are neseccary to be sure the correct label is scanned.

Michel.

I fixed this by setting “label” to “on” in the columns settings.

2 Likes