Search - Joel Lipman .Com

1. Zoho Creator: eBay: Get Item Transaction: / Zoho /; What? This is the function to get the line item order/transaction from eBay if you give it the eBay Item ID as a parameter. Why? Mostly for debugging but here's the code that will quickly get the ...; Created on 22 January 2022
2. MySQL Transactions in PHP: / MySQL /; ... changes to the data. This where transactions are useful. We can run the queries, then check if some conditions are met before committing the changes in the data: $mysqli->begin_transaction(); $mysqli->query ...; Created on 14 December 2016
3. ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM record: / Zoho /; ... of field "Deal_Ref" from the ZohoSign Document Request v_DealRef = ""; if(!isnull(r_RequestDetails.get("requests"))) { if(!isnull(r_RequestDetails.get("requests").get("actions"))) { l_Actions ...; Created on 17 October 2022
4. Zoho CRM / Deluge: Send an email with a CRM Quote using a given CRM template: / Zoho /; ... = "https://zohoapis.com/crm/v2/settings/inventory_templates/" + v_TemplateID + "/actions/print_preview?record_id=" + p_QuoteID + "&print_type=pdf"; f_FileRequest = invokeurl [ url :v_Url ...; Created on 18 August 2022
5. Zoho Books/Inventory: Trigger a workflow when an invoice has been paid: / Zoho /; ... when Status is "Paid" Just once or every time is "Everytime" Actions is a custom function called "fn_invoice_updatepaymentmethod" But this wouldn't work despite being as per the documentation (see ...; Created on 17 August 2022
6. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... Another REST API CRM function which generates an eBay Access Token for me r_Response = getUrl("https://www.zohoapis.eu/crm/v2/functions/fn_ebay_getaccesstoken/actions/execute?auth_type=apikey&zapikey=1003."); if(!isnull(r_Response.toMap().get("details"))) { if(!isnull(r_Response.toMap().get("details").get("output"))) { v_AccessToke ...; Created on 31 March 2022
7. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; ... I'm going to show you the code first of how to parse the eBay Transaction data and then the code to create a Shopify Order: Parse an eBay Transaction Notification (XML) x_ResponseBody = input.Payload.getJSON("body"); v_MainNodeName ...; Created on 21 January 2022
8. ZohoCRM & Xero Real-Time Invoices: Receive Webhook: / Zoho /; ... = ""; v_AccessToken = ""; r_Response = getUrl("https://www.zohoapis.com/crm/v2/functions/fn_api_getxeroaccesstoken/actions/execute?auth_type=apikey&zapikey="); if(!isnull(r_Response.toMap().get("details"))) { if(!isnull(r_Response.toMap().get("details").get("output"))) { v_AccessToken ...; Created on 10 January 2022
9. Zoho Deluge: Text (SMS) reminder using Twilio API (LocalSense): / Zoho /; ... Reminder 1 Hr Before" When is "On a Date/Time" based on "Call Start Time" with execution date "On" the date and execution time "1 hour before". Condition 1: rule is applied to all calls Action is the ...; Created on 16 December 2021
10. Zoho CRM: Schedule a Task: Timesheet Reminder: / Zoho /; What? A quick article to demonstrate code that creates a task in CRM based on the time logged against an Event/Meeting. Why? As developers, we're keep account of our time and we are currently ...; Created on 02 December 2021
11. Zoho CRM: Schedule a Call using Deluge: / Zoho /; ... = "FREQ=NONE;ACTION=EMAILANDPOPUP;TRIGGER=DATE-TIME:" + v_ReminderDate.toString("yyyy-MM-dd'T'HH:mm:ss") + "-05:00"; m_ReminderAlarm = Map(); m_ReminderAlarm.put("ALARM",v_ReminderStr); m_CreateTask.put("Remind_At", ...; Created on 18 November 2021
12. Zoho Creator: Change Radio into Tabs: / Zoho /; ... workflow Load of the form Name the workflow, I'm calling mine OnLoad Add New Action > Deluge Script: And I add the following to my deluge script, to remove the label "Tabs": v_Css = ""; v_Css ...; Created on 22 October 2021
13. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; ... API... Why? A follow on from my article Zoho Creator: Push to eBay Listings. I have a Creator app that needs to receive the orders from an eBay account as soon as the order or transaction is made ...; Created on 20 September 2021
14. Zoho CRM: Standard Setup for Tax Rates: / Zoho /; ... have this selectable for users in their transactional modules (quotes, sales orders, invoices, purchase orders), you need to modify each product record (can be done with "Mass Update") to give them the ...; Created on 02 September 2021
15. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines): / Zoho /; ... m_Record.toString(); } Without a regex solution and the replacement back to commas then the above outputs: Actions Do you want to get rid of the annoying escaped double-quotes ...; Created on 26 August 2021
16. Xero API: Send Multiple Invoices: / Xero /; ... [ { "Type": "ACCREC", "Contact": { "ContactID": "abcdef01-2345-6789-abcd-ef012345678" }, "Reference": "TEST Invoice (DO NOT ACTION) 1", "DueDate": "2021-09-13", ...; Created on 15 August 2021
17. Zoho CRM: Update a custom field in line items / product details using REST API v2.1: / Zoho /; What? This is a quick article documenting how to update custom fields in a line items or product details section of a transactional module such as Quotes, Sales Orders or Invoices using code: Zoho Deluge. ...; Created on 17 May 2021
18. Zoho Deluge: Sort a Map by a specific field: / Zoho /; ... = v_DatePart + " " + v_TimePart; l_SortingKeys.add(v_SqlDateTime); m_UnsortedRecords.put(v_SqlDateTime, r_Record); } } // // now sort list in descending order and action each record l_SortedKeysDesc ...; Created on 29 January 2021
19. Zoho Creator: Button on Report for Merging Multiple Selected Records: / Zoho /; ... + v_LineItemTotalVat; v_Total = v_Total + v_LineItemTotal; } // // other actions you want to do after all quotes looped through // } Save your function and click on "Done" ...; Created on 06 December 2020
20. Zoho Creator: info/alert/modal/popup notification for any user: / Zoho /; ... on the action using values from the form invoking it but for generic messages you could get the "Notify" page to read from a form/report: Click on the plus icon to create a new form Select a blank form, ...; Created on 06 November 2020