... has not been tested extensively. Do not use if you are unsure it is calculating correctly. I use these to store the values in a table that can be double-checked at a later date.
Source(s):
Joel ...
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 ...
What?
This is an article to quickly demo a couple of snippets of code to display values in a custom related list as well as to display empty custom related lists.
Why?
Because I keep forgetting ...
... every month"...
How?
Rather than just babble on about it, here's the code, replace what you need just noting that I'm enclosing each value with double-quotes because the values might have commas and ...
...
The Code to read, parse, create a holding record and generate a link for the customer portal user to click on:
// accessing zoho.eu (not zoho.com) so adapt the 2 values
v_CreatorBaseUrl = "https://creator.zoho.eu";
v_ZohoApisDC ...
... on the action using values from the form invoking it but for generic messages you could get the "Notify" page to read from a form/report:
Click on the plus icon to create a new form
Select a blank form, ...
... for inserting a row into a subform:
// declare a variable to hold the collection of rows
= Collection();
// declaring the row
= .();
// assigning values for various subform fields in the ...
What?
A quick article on converting a Map (associative array with keys and values) into a URL string to pass as URL parameters.
How?
Let's first define a map:
m_Payload = Map();
m_Payload.put("client_id","my-unique-client-id");
m_Payload.put("redirect_uri","https://www.joellipman.com");
m_Payload.put("response_type","code");
m_Payload.put("scope","my_api_scopes");
m_Payload.put("prompt","login");
Great! ...
What?
This is a quick article to demonstrate how to compare two datetime values with the timezone specified.
Why?
A client's ZohoCRM had a different timezone setting than the user a script would ...
What
A more comprehensive post on some other regex (regular expressions) to format values in Zoho.
How?
The following will remove any non-digits:
v_MyString = "Hello World 123";
v_MyFormattedString ...
... we want to achieve:
1 year 2 months 3 weeks 4 days 5 hours 6 minutes 7 seconds // full string
1 year 3 weeks 5 hours 7 seconds // where shown values are not zero
Actually ...
What?
This is an article documenting how to access ZohoCRM with API v2 using PHP and cURL. The first few functions are to manage OAuth v2 and generate the refresh and access tokens. The second snippet ...
... but you could get your values from anywhere:
On page load, the seconds remaining and elapsed are specified
JS then takes over and runs the time
var seconds_remaining = ;
var seconds_elapsed ...
... for quick tweaks to the database values after a migration.
-- Replace stringtofind with the string you want to find
-- Replace stringtoreplace with the string you want to replace with
-- REPLACE ...
... actually works...
- Trimmed any spaces from posted data and html code.
- Used revolvermaps.com selection of "width x height" values.- Date Uploaded: Fri, 30th Jul 2010
...
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.