I am having issues with dropsource showing large numbers with exponential notation such as 3.65e+6 when I displayed it in a text view or field.

This happens when we pull data from api such as data in bubble or through math js API. Is there a way to show the data in real numbers?

Second issue is if we performed another calculations based on the first data I pulled. For example I pulled data from the first API, say, 3.65e+6. I then try to perform another calculation from that number by multiplying it by 3. The results I have then 12, because it calculates 3.6*4. It should’ve been 3.6 millions times 4. Not 3.6 times 4.

Can anyone suggest how to handle this? How should I store these values in variable? What data types should I assign?

@sue when will the dropsource calculation be implemented? We are just trying to do simple calc and we hve to use outside API to do this and it handles numbers with exponential notation. This is quite frustrating.