What?
This is an article detailing the client script to fix any fields which exceed their decimal places limit in ZohoCRM.
Why?
So we have a customer that has some decimal fields on the products ...
... I tend to use Excel to reduce the decimal point to only 7 decimal places (for importing to a database where DECIMAL(10,7) ).
Merging the lot
If B1 contains the coordinates and there is a space ...
... ---------- -----------
Task 1 0.14 1:00:00
Task 2 0.07 0:30:00
Task 3 4.80 34:15:00
Excel needs the decimal number to be representative of a 24 hour slot. ...
... data types are picklist, id, owner_lookup, user_lookup, lookup, phone, email, date, datetime, text, textarea, integer, currency, decimal and double.
You can search for a maximum of 10 criteria (with same ...
What?
This is a not-so-quick article that queries an eBay order and creates the relevant ZohoInventory item, contact, sales order, package slip, shipment order, invoice, payment records...
Why? ...
What?
Following on from my article: ZohoCRM: Get All eBay Active Listings, this is how to get all the orders from a client's eBay.
Why?
Our use-case is a data migration from eBay to a fresh instance ...
What?
Another one of these articles talking about getting all the active product listings from eBay for a specific client.
Why?
Our use-case scenario here is that we want to get an inventory ...
... as 10.00%. And they need the decimal because sometimes they might offer 12.5%. But when it displays in a template, it isn't that pretty to look at: Instead, could they have 10% to display instead of 10.00%, ...
What?
This is an article documenting how to parse the notification from eBay and using it to create an order in Shopify.
Why?
Previously, we would receive an eBay notification and create an ...
... " + r_Event.get("eventType");
//
// get the xero ID of the record (hexadecimal)
v_Xero_ResourceID = r_Event.get("resourceId");
//
// do different things based on the category of the update
if(r_Event.get("eventCategory").containsIgnoreCase("CONTACT"))
{
/ ...
... record under "Attachments".
As a quick outline of the below:
Create a connection to Workdrive/Writer
Get the Merged Template ID (hexadecimal)
Create the all-in-one button and function to generate ...
What?
This is an article to document how I downloaded an image held in a Zoho Creator form, and sent it to an API wanting the publicly accessible link or URL of the image.
Why?
I've got some other ...
What?
This is an article to document a function used in Zoho Creator to retrieve the Product IDs of all the active products in a client's eBay store.
Why?
The use-case was that I wanted to retrieve ...
... of the fields is changed
Add an eTag field: Will hold a 32 hexadecimal character string / a hash of the fields to monitor
Add the if statement to compare etags on your main workflow.
Other fields ...
... p_QuoteID is the ID of the quote):
// init Map
m_UpdateQuote = Map();
//
r_QuoteDetails = zoho.crm.getRecordById("Quotes", p_QuoteID);
v_SubTotal = r_QuoteDetails.get("Sub_Total").toDecimal() * ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.