... evaluate (specify here your dates [time set to midnight])
v_timeFrom = zoho.currenttime.subDay(0).toString("yyyy-MM-dd'T'00:00:00.000'Z'");
v_timeTill = zoho.currenttime.addDay(1).toString("yyyy-MM-dd'T'00:00:00.000'Z'");
//
// ...
... zoho.currenttime.toString("HH:mm:ss");
//
// loop through our list for this page
for each r_Candidate in l_Candidates
{
v_CountTotal = v_CountTotal + 1;
v_CandidateZohoID = ifnull(r_Candidate.get("CANDIDATEID"),0);
r_Associate ...
... my list to populate
l_CheckDates = List();
//
// loop through generated list and add dates
for each index v_Index in l_GeneratedList
{
if(v_Index>0)
{
l_CheckDates.add(zoho.currentdate.addDay(v_Index).toString("yyyy-MM-dd"));
}
} ...
... check the form was ticked and there is a package ID specified
if(input.Mark_as_Complete && input.Zoho_Package_ID != "")
{
v_PackageID = input.Zoho_Package_ID;
r_PackageSlip = zoho.inventory.getRecordsByID("packages",v_BooksOrgID.toString(),v_PackageID,"ab_inventory");
if(r_PackageSlip.get("package") ...
What?
Well known by most but this serves as a quick reminder to myself and anyone else on how to embed a form or a report into a Zoho Creator page.
Why?
Cos
How?
The below is a template ...
... // convert to xml and replace root nodes
x_Params = m_Params.toXML();
x_Params = x_Params.toString().replaceFirst("","");
x_Params = x_Params.toString().replaceFirst("","");
info x_Params;
//
// s ...
... field
clear Calendar_Day_Select;
input.Calendar_Day_Select:ui.add("<");
for each index v_DateIndex in
{
input.Calendar_Day_Select:ui.add(zoho.currentdate.addDay(v_DateIndex).toString("EEEE") + ...
... e Meeting");
//
// the start time
m_ScheduleMeeting.put("Start_DateTime",zoho.currenttime.addBusinessDay(1).toString("yyyy-MM-dd'T'HH:mm:ss","America/New_York"));
//
// the end time
m_ScheduleMeeting.put("End_DateTime",zoho.currenttime.addBusinessDay(1).addMinutes(30).toString("yyyy-MM-dd'T'HH:mm:ss","America/New_York"));
//
...
... that in the following regex, and if using Zoho Creator, you need to replace the double-backslash with a single backslash:
v_Test1 = 12.300;
info v_Test1.toString().replaceAll("(\\.\\d*?[1-9])0+$", ...
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 ...
... use Zoho built-in GeoCode function to return latitude and longitude
r_GeoCode = zoho.map.geoCode(l_LeadAddress.toString(","));
//
// get timezone from a free third-party API given lat/lng
l_Params ...
... Start Starts Second Sunday in March at 2:00
DST End Ends First Sunday in November at 2:00
//
// Starts Second Sunday in March at 2:00
v_FirstMonthDate = toTime(zoho.currentdate.toString("yyyy") ...
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.