Search - Joel Lipman .Com

1. Zoho CRM: searchRecords with sorted results: / Zoho /; What? This is an article to document how to use the searchRecords function in CRM and to sort the results response. Why? This is unclear and not always working as coded below since each system ...; Created on 10 February 2022
2. Zoho Deluge: Sort a Map by a specific field: / Zoho /; What? This is a quick article to template some code to me on sorting a map variable in Zoho Deluge, specifically Zoho Creator. Why? I do this a lot but in the following example, I want to sort ...; Created on 29 January 2021
3. Sort an associative array by values in Javascript: / JavaScript /; What? An article on how to quickly adapt an array code and sort by its values. Surprising how many examples are on the web and everyone saying you're doing it wrong... Which is true but quite unhelpful. ...; Created on 29 September 2015
4. MS Excel - Sort pivottable column headings by date: / Excel /; What? This is a quick note to myself so that I never use parentheses in the column headings again. Basically I have a pivot table in Microsoft Excel 2010 with the projects down the left (in the first ...; Created on 12 April 2013
5. Sort order a dropdown list in MS InfoPath without programming: / Infopath /; ... you want the form to have (I included the IDs for functional purposes) Further down the "Create View" page, there should be a Sort section, specify the column to sort by. Save the view by clicking the ...; Created on 21 July 2011
6. Zoho Projects: Get All Events: / Zoho /; ... + "-" + v_ThisDateEvent_Day; v_ThisEventDateSort = v_ThisDateEvent_Year.toString() + v_ThisDateEvent_Month.toString() + v_ThisDateEvent_Day.toString() + v_ThisDateEvent_Hour.toString() + v_ThisDateEvent_Minute.toString() ...; Created on 22 July 2024
7. ZohoCreator: Using .toFile and Uploading to a Creator field: / Zoho /; ... 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(",", ...; Created on 25 March 2024
8. Zoho Books: Generate Bank Text File for Download: / Zoho /; ... a variable: // // initialize v_CSVString = "Bank Sort Code,Bank Acc. No,Account Holder"; v_CSVString = v_CSVString + "12-34-56,012345678,Joel Lipman"; // // convert to a TXT file (not a CSV...) f_BillsExport ...; Created on 02 October 2023
9. Zoho Deluge: Get All Orders from eBay: / Zoho /; ... = "GetOrders"; m_Headers.put("X-EBAY-API-CALL-NAME",v_ApiCall); m_Headers.put("X-EBAY-API-IAF-TOKEN",v_AccessToken); // // build params m_Params = Map(); m_Params.put("WarningLevel","High"); m_Params.put("ErrorLanguage","en_GB"); m_Params.put("DetailLevel","ReturnAll"); m_Params.put("OrderStatus","All"); m_Params.put("SortingOrder","Ascending"); m_Params.put("CreateTimeFrom",v_OrdersFrom); m_Params.put("CreateTimeTo",v_OrdersTill); // // ...; Created on 29 March 2023
10. ZohoAnalytics: Pivot Campaigns vs Contacts: / Zoho /; ... I always resort to a query when I get confused with the GUI: Query 1 Due to the limit of sub-query levels we can go down, I want to join this to the contacts data table. So I'm going to make this ...; Created on 20 March 2023
11. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... build params m_Params = Map(); m_Params.put("WarningLevel","High"); m_Params.put("ErrorLanguage","en_GB"); m_Params.put("DetailLevel","ReturnAll"); // // specify only the active list m_ActiveList = Map(); m_ActiveList.put("Include",true); m_ActiveList.put("ListingType","FixedPriceItem"); m_ActiveList.put("Sort","ItemID"); // // ...; Created on 01 March 2023
12. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... ":}]} I only resolved this by not using "endCursor" in my GraphQL and instead looped through the nodes to get the last cursor. Not sure if this meant any data was missing. Perhaps by forcing the sort cr ...; Created on 20 February 2023
13. Zoho Creator: Populate a Multi-Lookup: / Zoho /; ... hasn't been populated l_Appointments = Appointment[Zoho_Inventory_Package_Slips == null] sort by Added_Time desc range from 0 to 100; for each c_Appt in l_Appointments { // // get package references ...; Created on 18 August 2022
14. Zoho Books/Inventory: Trigger a workflow when an invoice has been paid: / Zoho /; ... = invoice.get("invoice_number"); v_BalanceDue = ifnull(invoice.get("balance"),0.0); // // search payments m_SearchCriteria = Map(); m_SearchCriteria.put("customer_id",v_CustomerID); m_SearchCriteria.put("sort_order","A"); m_SearchCriteria.put("sort_by","payment_number"); // // ...; Created on 17 August 2022
15. Zoho CRM & Creator: Download attachment and upload to Creator file field: / Zoho /; ... form to download the attachments and upload them to the Creator "Document" form: // // get attachments v_NoteAttachments = ""; m_SortCriteria = Map(); m_SortCriteria.put("sort_by","Created_Time"); m_SortCriteria.put("sort_order","desc"); l_Attachments ...; Created on 11 March 2022
16. Zoho Creator: eBay: Get Item Transaction: / Zoho /; ... include fixed price items m_Pagination = Map(); m_Pagination.put("PageNumber",v_Page); m_Pagination.put("EntriesPerPage",v_PerPage); m_Params.put("Pagination",m_Pagination); //m_ActiveList.put("Sort","ItemID"); m_Params.put("ItemID",p_ItemID); // // ...; Created on 22 January 2022
17. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; 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 ...; Created on 21 January 2022
18. Zoho Creator / eBay: Get all Active Products: / Zoho /; ... uncomment this when all products retrieved and to run this to just get latest products // m_ActiveList.put("Sort","ItemIDDescending"); m_ActiveList.put("Sort","ItemID"); m_Params.put("ActiveList",m_ActiveList); // // ...; Created on 13 October 2021
19. Zoho Creator / Shopify: Get all Active Products: / Zoho /; ... the function I came up with. It loops through a maximum of 2500 products sorted in order of ID ascending (starting with ID=0) retrieving 250 per call and using since_id to not list the same one twice ...; Created on 12 October 2021
20. Zoho CRM: Standard Setup for Tax Rates: / Zoho /; ... Tax" @ 20% and a "Zero Vat" @ 0% Click on "Save" and you've pretty much specified the tax rates that this CRM can use; but... do the next steps for users to be able to use these. Done, sorta To ...; Created on 02 September 2021