What?
This is an article to demonstrate how to handle commas in a CSV file that were enclosed between two double-quotes. I've added to this the handling of new lines or carriage returns in between a ...
What? This is a quick note on how to reduce a whole bunch of CSS into a single line without unnecessary spaces and new lines. Why? What I have:
#copyright a{
margin: 10px 0 0 85px;
box-shadow: ...
... Report in ZohoCreator
l_CsvLines = List();
l_ApplicableProducts = Products[Display_in_Widget=="Yes"] sort by Product_Name;
for each c_Product in l_ApplicableProducts
{
l_CsvRow = List();
l_CsvRow.add(c_Product.Photo);
l_CsvRow.add(c_Product.Product_Name.replaceAll(",", ...
... Team", and "Sales Team".
Save and Close
Setup: Specify Pipeline Options
Login to ZohoCRM as a system administrator > Go to Setup > Pipelines
Using the "Standard" layout, let's simply create ...
What?
A super quick article on something that almost deserves its own article: using new lines in ZohoDeluge.
Why?
My use-case here is that I was generating a comma separated values (CSV) file ...
... which they called "Candidate Ref" and their own reference for the JobOpening called "Vacancy Ref". The below outlines the custom module we created and how we populated with associated candidates:
The ...
... if this doesn't work, enable one of the following 2 lines
//r_File.setParamName("attachment");
//r_File.setParamName("file");
r_File.setFileName(v_DocumentName);
r_Attach = zoho.crm.attachFile("Deals",v_DealID,r_File);
info ...
... connection from Zoho Creator to Zoho Inventory
3 lines icon in the top-left of your Creator (in edit this application mode)
Then go to Setup > Connections > Add Connection
Select Zoho OAuth and specify ...
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 ...
... if statement to all fields? Well no again, just compare on the workflow of the audit change. Something along the lines of:
Add an Audit Change field: This will contain the code triggered when one ...
... a Zoho ID) and UDF_CHAR7 (which is a text/string name field). Note that in the below snippet, I've put m_Params into separate lines for display purposes but actually it should be all on one line:
m_Custom ...
... REST via API (see what I did there?), we need a Zoho Oauth2 connection in Zoho Books.
In Zoho Creator, go to Setup (3 horizontal lines in top left if in edit mode » pops up the side bar to go to Home ...
... yields Joe\'s \"Amazing\" Skill \& \ Grunt
Replace new lines in returned JSON (invalid in Zoho):
v_MyString = "{"MyKey":"MyValue
"}";
// the long way (and cos the regex for this isn't working)
v_FormattedString ...
... sake of search-engine friendliness. There are no silver bullets here but I want to block any character that isn't a letter, a number or an underscore.
How?
Suppose the following exists as a MySQL ...
What?
This is an article explaining the code needed to write a PHP script which generates an access token for a service account which in turn is used to list files in a team's Google Drive.
This is ...
... first array
Day_Name = Day_Names.get(Day_Abbreviations.indexOf(Day_Abbreviation));
Reducing the code lines but using the same technique as above:
Day_Names = List:String();
Day_Abbreviations ...
... 2018".
Why?
Well there's a long a way to do it (but reliable). But being limited to the lines of code you can run (ref. "Maximum number of executable statements", anything that reduces the number ...
... is:
A long heading that wraps over several lines
When I shrink the browser, I get a heading like this:
I want this to happen:
The code of this is the addedn overflow:hidden;height:1%;:
A ...
... if first item is blank (allows for blank excel lines)
if(column_values[0] != ''){
// remove any/all double-quotes in this column value // found this method ...
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.