Hi, I am using a WhatsApp bot as my source of data, and I receive inputs in various regional languages through webhook.
For the fields declared as type NUMBER, I am not to store the incoming data from webhook of different language as it gives Field "Amt_Spent_New" cannot accept the provided value: Could not parse number. (Attached screenshot below)
If I convert the NUMBER type field to TEXT, I am able to store the data but not perform operations on it
How can I tackle this use case?
Any advice or help is much appreciated!, Thank you