Assuming each is required, the following 209 results were found.
-
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: *
-
Modified"}); // // build up related list rows l_RelatedListData = List(); for each m_DataRow in l_DataRows { // double-check in case books has returned 1st page rather than filtered rows if(m_DataRow.get("SO ID") == v_SalesOrderID) { m_Details = Map();...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
r_UpdateBooksInvoice.get("message"); } It's a cop-out I know, but it beats the accounts staff having to enter the adjustment each time. The create invoice process would be treated the same. The below are all the various methods I tried to resolve this...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *