Text field ID not accepting text, just numbers

[Anonymous]

I have a text field ID of type text. Data source for this field is SQL table with coulmn ID, type varchar(50).

Problem is that this field is not accepting text or characters like -. Even though it is of type text. Only numbers can be inputed.

Other column with type text works fine with mixed text/number/chars. Only this ID column is problem.

If I create a new record for ID in SQL table with mixed text/numbers, it is acceepted without problems.

More in screenshots:

ERROR ON INPUT

SQL COLUMN

PROPERTIES OF TEXT INPUT

[timl · Accepted solution]

Hi @Anonymous 

I would try recreating this data card in order to reset it. That might clear the problem.

If you select the properties of the form and click fields > edit fields, you can delete the card and click 'add field' to add it again.

[Anonymous]

This did the trick.