Assuming each is required, the following 212 results were found.
-
Put the link name that we will use in code later (preferably in lowercase as it will lowercase it anyway) Scope: Enter each scope you need and click on the plus icon to add each one. Keep "Use credentials of login user" ticked. You should have something...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
the code to loop through all these matching records (and approved) and determine if it clashes with the requested dates: for each r_TimeOff in l_AllTimeOffs { if(!isnull(r_TimeOff.get("Employee_ID"))) { v_ThisStatus = r_TimeOff.get("ApprovalStatus");...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
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 someone may want to open this in Google Sheets or Microsoft...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
records if(v_ResponseCode == 3000) { v_RelatedListXML = ""; l_SearchResults = r_SearchResults.get("data").toJSONList(); for each r_Result in l_SearchResults { // init v_DateTill= "-"; v_QuoteTotalDisp= "-"; v_Index = v_Index + 1; v_RelatedListXML =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
after an hour or so trying to get the Zoho.books.getRecords() function to filter the sales persons, I gave up and used a for each loop instead. In the next snippet of code, I am getting the Zoho CRM record owner, looping through all salespersons in Zoho...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
{ l_Users = zoho.crm.getRecordById("users",r_DealDetails.get("Owner").get("id")); for each r_UserDetails in l_Users { m_UserDetails = r_UserDetails.toMap(); if(!isnull(m_UserDetails.get("Division"))) { v_DivisionID = ""; v_DivisionName =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
will all be done by the sales team via Shopify. So I select the following: (see: Shopify API Access scopes for more info on each):...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
date at 2:00am Run Daily Name the workflow Daily Delete Record Click on Create Workflow Give it the following code: for each r_ApplicableRecord in Inventory_Photo[Added_Time Developer Space > Connections Create Connection Give it the scope(s):...
- Type: Article
- Author: Joel Lipman
- Category: Ebay
- Language: *
-
if(!isnull(r_SearchResults.get("customerpayments"))) { l_SearchResults = r_SearchResults.get("customerpayments"); for each r_Result in l_SearchResults { if(!isnull(r_Result.get("payment_id"))) { // // invalid searches will return 200 results...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
0; l_CandidateSearch = zoho.recruit.searchRecords("Candidates","School Name|=|" + v_SchoolName,1,200,"ALL","zrecruit"); for each r_Candidate in l_CandidateSearch { if(!isnull(r_Candidate.get("CANDIDATEID"))) { v_CandidatePlacedCount =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Recruit
- Language: *
-
An article on the reasoning and steps to generate a dataset using Zoho's ANSI-SQL queries to generate the margins of each invoice in ZohoBooks. Why? We need to create a profits/losses dashboard in Zoho Analytics as we can't control the out-of-the-box...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
to CRM Contact records. There's first the preparation of an "Attachments.csv" file that needs the correct values in each column and the "Attachments.zip" containing the files to attach that needs some formatting as well: Note that any IDs used in the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
not want their operations team adding/deleting rows and instead simply specifying quantity (defaulting to zero) alongside each serviceable item. How? So at time of print, this is the only way I know: add a note field to inject some CSS into it and hide...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
to loop, so try and give a number higher than the actual number of products you have in your shop, it will stop when it's reached the end of the list as per eBay and not what you might have thought it was. /* Function: fn_GetEbayActiveProducts()...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
of an ANSI-SQL (ZohoSQL) query pivoting campaign results vs contacts. Why? Simply the client wanted a report on customers on each row and then the campaigns as columns. What we want: Contact Name Lead Source Campaign 1 Campaign 2 Campaign 3...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
= ceil(v_MaximumOrders / v_PerPage); l_AddPages = leftpad(" ",v_TotalNumberOfPages).replaceAll(" ",",").toList(); for each index v_Increment in l_AddPages { l_Pages.add(v_Increment + 1); } v_TotalNumberOfPages = l_Pages.size(); // // declare variables...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
+ v_BooksOrgID type :GET connection:"joel_books" ]; if(!isnull(r_Taxes.get("taxes"))) { for each r_Tax in r_Taxes.get("taxes") { m_Taxes.put(r_Tax.get("tax_percentage").toString(),r_Tax.get("tax_id")); } } l_DebugMessages.add("ZB Taxes: " + m_Taxes); //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Inventory
- Language: *
-
this variable name is in plural, but as a custom function within ZohoBooks, we know this is just 1 bill record, still... for each r_Bill in bills { v_BillID = r_Bill.get("bill_id"); } // // send attachment request r_Attachment = invokeurl [ url:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
p_TicketRef) { v_TicketRef = ifnull(p_TicketRef,""); c_TicketRecords = QC_Report_Table[Ticket_Number == v_TicketRef]; for each c_TicketRecord in c_TicketRecords { info "Ticket Ref: " + c_TicketRecord.Ticket_Number; v_CountImages = 0; v_CountNew = 0; for...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
= ifnull(r_Analytics.get("data"),Map()); l_DataSources = ifnull(m_ResponseData.get("dataSources"),List()); for each m_DataSource in l_DataSources { if(m_DataSource.get("datasourceName").equalsIgnoreCase("Zoho People")) { v_LastSyncTime =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *