zespiresdevlopers3

Hi Kris,
Thanks for your findings and the suggestions.
Appreciate your quick response on the ticket.
Kind Regards

Hi Kris,
Thanks for your reply.
Yes, Voucher Number is a text field.
And below is the attached Form code for your testing please.

https://docs.google.com/document/d/1Imqtk602eVJZxJGQeUjYWe5CGtlpwZYA3sdgEIsq3c4/edit?usp=sharing

Thanks

Hi Patrick,
Thanks so much for the script.
As per your suggestion, we used this script and are able to successfuly fixed this issue.
Now the cells with numbers are getting populated correctly, but we observed one new issue due to this script: the date fields are also getting converted into Numeric values. As we see the script is for both number and date field conversion.
Could you please provide the script only specific to the nummber field and not the date field?
Attaching screenshot for your reference.
Thanks in advance!

https://prnt.sc/da7LM7pQR27V

can you tell me how to use this script

can you send the steps of the script where to add