I use the same form to add new fields and edit in my data table in sql.
When I am editing a value, the error below is occurring and I am not editing the value in the data table (PS: when I add a new value, the error does not occur):
I deleted the form and repeated the calls, but still giving the same error, could someone help me?
Please review your Update property on the datacard for the column that is causing the error. Make sure you are providing a numeric value for all the fields that require a numeric and that it is not being altered for when you edit a record. In other words, if you are doing some condition to check if the form is in edit or new mode and providing a value, make sure that you are providing the right type for each mode.
I hope this is helpful for you.
Thank you for your attention.
I have already checked all the update properties of my form.
I have a condition in a datacard, the formula used in Default is:
but its update is with the formula below:
And the error is occurring in the entire form, not in a specific field.
Yes, it is complaining about the entire form, but the issue appears from the error to be coming from at least one column that is trying to be converted. To fully track it down, I would recommend using the Monitoring Tool in the designer and see what the request and responses are from the back end system.
Without further information about that particular datacard, I am assuming you have a Dropdown (not a combobox) in the datacard and that you have provided the Default property of that Dropdown and not the Default property of the Datacard. The Datacard should be ThisItem.someColumnName where some column name is the name of the column in your datasource.
IF this is indeed the offending column (again, try to verify with the Monitor Tool) then please supply the Items property of the DropDown and any relevant information about that datasource.
the dropdown values are the ones informed in the previous post, sorry for not making it clear. But, send again (in this dropdown I have a view that has the name and id and saved in the main table):
I checked with that monitoring tool and it resulted in the point where the error happens:
and the response:
if you can help me with this information. Thanks !