Does anybody knows how to make an column that...

Does anybody knows how to make an column that scan qr codes but only accept certain values? i have it on text and scanneable but it let me put text instead of the qrโ€ฆ

0 2 287
2 REPLIES 2

No you can not force them to use the camera. They will always be able to enter text. However, your can restrict the values allowed with a well constructed valid_if statement.

Would a SELECT statement work? Basically checking that the text was on a list of pre-approved codes?

I tried that but when i entered a random 10 character text (my qr codes are just that, saved in a users table against the users details) it accepted it, but then threw up a NaN errorโ€ฆ presumably as it couldnโ€™t reference details stored against that code.

I would have expected it to refuse the SAVE.

Any ideas?

Top Labels in this Space