Hi everyone.
I have a webhook sending me a lot of information, one of them being:
“ReservationPrice”: “109,00”
I need to run a division based on the numeber of services within the same reservation and then send the result in the same format xxx,xx to GoogleSheet.
For example:
“ReservationPrice”: “109,00”
“ServiceCount”: “3”
I need to send 36,33 to Sheets.
Thank you so much in advance
Hey there,
what is the exact issue you are having with this? There is a division operator in Math functions you can use for this and you can use the parseNumber() and formatNumber() formulas to define the decimal spaces.
Welcome to the Make community!
Looks like the price is stored as a string because the decimal point is a comma. This means you need to convert it into a number before you can perform math operations.
To do that, you can use the built-in function parseNumber.
e.g.:
{{parseNumber(1.ReservationPrice; ",")}}
For more information, see the function documentation in the Help Center and do the tutorials in the Make Academy.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.