hello Everyone
I have a problem how to set the selected value from the xls file to a certain field of the form. The problem is that the values in the table connected to the form are declared as numbers, and the data that is pulled from the xls file is a string. The error would be solved if you just changed the declared values of the table into a short text, but that is not an option for me at the moment, because the existing table is already quite large and it would be bad to damage it.
Before entering the fields of the form, I have the condition of checking if such data already exists in the table, if not, to enter it. That option works, but as soon as you need to set that value in the form field, an error appears.
I also have an example of my problem in the attachment, so if I was a little unreasonable, you can better understand the problem through an example
I have a problem how to set the selected value from the xls file to a certain field of the form. The problem is that the values in the table connected to the form are declared as numbers, and the data that is pulled from the xls file is a string. The error would be solved if you just changed the declared values of the table into a short text, but that is not an option for me at the moment, because the existing table is already quite large and it would be bad to damage it.
Before entering the fields of the form, I have the condition of checking if such data already exists in the table, if not, to enter it. That option works, but as soon as you need to set that value in the form field, an error appears.
I also have an example of my problem in the attachment, so if I was a little unreasonable, you can better understand the problem through an example