If I go to my .xlsx table that my data is connected to and change the format of a column to 'Number' rather than 'General', my forms will all return errors such as:
Invalid value '100' for field 'xyz', expected a number.
I cannot find where in the advanced fields where I can specify the format of the card output when the form is submitted. Is there a way to fix this?
You could switch the TextInput control format property to number instead of Text.
"
Format – Whether the user input is restricted to numbers only or can be any text
"
Further, we may switch the string format into number by Value function, under the DataCard Update property, switch the formula as below:
Value(DataCardValue.Text)
Which should convert the string into Number.
Regards,
Michael
It didn't work. I should mention I'm using a "Rating" control card
I switched the Update field to
Value(Rating.Value)
It makes zero sense why this wouldn't work but it's still returning "Invalid value '3', expecting a number"
Edit: It didn't work for a standard text box input control card either. It works if I save the column type in the table as 'General' but the formatting seems to constantly switch around.
User | Count |
---|---|
222 | |
98 | |
95 | |
55 | |
34 |
User | Count |
---|---|
272 | |
108 | |
106 | |
60 | |
60 |