What?
A quick article to remind me on how create an multi-level ordered list that indents and aligns correctly.
Why?
I'm finding that I need to do this quite often for some clients who want to ...
What?
Trying to export a STU record but I want to use the XET template I created rather than the pre-installed XML export formats. When I try to export using data format XET, the system has never heard ...
... straightforward form
FormatTime( TimeString, Format )
{
FormatTime, FormattedTime , TimeString, %Format%
return Formattedtime
}
The following function is to convert a given SQ ...
Just a quick note as I use this function in various scripts. This adds the 1000th separator comma:
FormatAddCommas(val) {
Result:=val
StringLen, OutputVar, Result
NumLoop ...
I could just remember to search wikipedia for "Date (Unix)" or search my site for "Unix". This was easier.
Source: Wikipedia: Date (Unix)
Format specifiers (format string starts with +)
...
Thought I'd add a note as I was getting confused with the built-in function "FormatDateTime()". The example is shown as:
=FormatDateTime(Fields!BirthDate.Value, DateFormat.ShortDate)
The ...
I'm beginning a list as I've just spent an age trying to get PHP output to create a text file. Then my client showed me how she then opens the text file in Excel, so I said we could get the script to ...
... specify a date (so excludes hours, minutes and seconds). For demonstration purposes, I'm going to be using the European date format so DD/MM/YYYY.
The Solution
This is what I use to convert a given ...
What?
A quick article on retrieving all the products from a WooCommerce instance on a client's Wordpress website.
Why?
A client of ours wants the information entered against products in their WooCommerce ...
... information to your Zoho instance via API. No need for the Zoho Widget SDK.
Why?
At time of print, I felt the documentation was a little sparse on how to connect a JS widget to the data held in Zoho ...
...
How?
So I'll go over what happens in the real world process; then cover some technical information; and even include the function that makes it work:
Business Process
Customer visits website to ...
... else use the current value
var v_ProductWeightFormatted = fn_CountDecimals(v_ProductWeight) > 2 ? parseFloat(v_ProductWeight).toFixed(2) : v_ProductWeight;
// set the field value to the formatted ...
... in Zoho Analytics
Right-click on the "Image URL" column and select "Change Data Type" > select under Data Type: "URL"
Right-click on the "Image URL" column again and select "Format Column" > Select under ...
... v_Pages;
Additional
Urlencoding or not didn't have much affect on the above but it is recommended you do as it did work if the criteria were encoded...
The criteria is in the same syntax format ...
... :DELETE
connection:"zbooks"
];
Caveat(s)
The delete process may need to be in a schedule: you can use a custom module in ZohoBooks to store the necessary information of what to delete.
Undocumented ...
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.