Welcome to Portal

?Unknown\pull-down

Welcome to Zoho Cares

Bienvenido a Soporte de Zoho

Search our knowledge base, ask the community or submit a request.

I have several functions I've written in Zoho Projects that take one or more currency fields as input parameters (arguments).  These functions have been working just fine for months, and I made no changes to any of them.  Today (Jan 21, 2025) I noticed they were not working.  They may have stopped working earlier than this, but today was the first I noticed it.

The currency field no longer seems to act like a number, but text.  Previously, if this field was 0, I would see a 0 and could do math on that, or more specifically, do field.toDecimal().  Now the argument comes through as a dash ("-").  Also, if i have, say "$1,000.00" in the field, the argument shows as "$1,000.00" and if I try to cast it to a decimal I get an error that says, "Unable to convert the input text to decimal".

I'm working with support on this, but need this solved ASAP and so am hoping someone has a good solution for me.  This is causing some serious issues for us


1 user has this problem.
4 Replies
Reply
  • 23 days ago

Hello, George! 

Thanks for bringing this to our notice. We are analysing the above case with our engineering team and will apprise you here or via the support ticket. 

  • 23 days ago

George, 

 The API format of the currency field was updated a few months ago as {"column_name":"UDF_DECIMAL2","formatted_value":"\u20ac 100,000","label_name":"Currency3","value":"100.00"}

Instead of field.toDecimal(), you can use field.get("value").toDecimal() and check how it works. Also, when the currency field doesn't hold any values, then it will not be included in the response. 

Please make these changes and share your feedback with us. If the problem persists, share the API code with us via email to support@zohoprojects.com

Thanks

This does not address the question I asked.  This response implies that I am using the API to get the currency field.  I stated in my initial post that I am using the ARGUMENTS that are available in a custom function.  T



his my function worked just fine until something changed.  It appears as if the currencyValue variable now comes in as a text field as i can strip the dollar sign and comma and then do math on it.  But this should not have to be done.  I should be able to do math directly on the currency field.

What needs to be done to fix this?

  • 21 days ago

George, 

Thanks for clarifying it. 

Based on customer feedback, we have recently modified the email template to display the currency values appended with a dollar sign for enhanced clarity. However, this modification does not impact the API's ability to extract the numerical values for calculation purposes.

Reply to George FehrenbachA
/* */
  • 12
  • Insert
  • Plain text
Add Comment
(Up to 20 MB )