Search - Joel Lipman .Com

1. How to make a HTML form post its variables to itself: / Hypertext Markup Language /; The Issue You have a PHP page which generates a HTML form. When the user submits the form, you want the same PHP page to process the data. Solution I've seen a lot of people write CGI requests but ...; Created on 17 September 2009
2. Zoho CRM & Zoho Inventory: Upload Image to Item Record using Deluge: / Zoho /; ... quick parsing instruction to get the eBay photos; this snippet stores the URL of each picture in a list variable: l_Pictures = x_MainNode.executeXPath("//Item/PictureDetails/PictureURL/text()").toXmlList(); / ...; Created on 21 June 2022
3. 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
4. ZohoCRM & Xero Real-Time Invoices: Receive Webhook: / Zoho /; ... in your function) m_Payload = crmAPIRequest; // // initialize response variable m_Response = Map(); // // get xero signature v_XeroSignature = "SIGNATURE_FAIL"; if(!isnull(m_Payload.get("headers"))) { if(!isnull(m_Payload.get("headers").get("x-xero-signature"))) { v_XeroSignature ...; Created on 10 January 2022
5. Zoho Creator/Deluge: UnPredictable exception, Invalid statement found: / Zoho /; ... The Solution/Cause So quite simply, I'm using 2 for each loops and this is one of those scenarios where you need to store the loops into different variable names: // select a bunch of creator records ...; Created on 17 November 2021
6. Zoho Creator: Copy Subform to other Subforms: / Zoho /; ... another row (declare as many rows as required) = .(); // assigning values for various subform fields in the row . = ; . = ; // declare a variable to hold the collection of rows = Collection(); .insert( ...; Created on 17 November 2021
7. Zoho CRM: Get Unique Values of a Text Field: / Zoho /; ... the Zoho Deluge team... Well, they realised they would get the same results, and then suggested looping through all records and creating a distinct list variable... But what if there are 20000+ records? ...; Created on 08 October 2021
8. Zoho Deluge: Calculate Days, Hours, Minutes, Seconds between two Timestamps: / Zoho /; ... Deluge. How? We're going to make use of the .toLong() function applied to a datetime datatype variable which will return the Unix seconds. // the now time v_NowTime = zoho.currenttime; // // ...; Created on 21 September 2021
9. ZohoCRM: zoho.crm.searchRecords only returns certain records: / Zoho /; What? This is an article to hopefully resolve for you quicker than it took me, why a zoho.crm.searchRecords() returns some of the records but omits others. Why? The use-case was that we were creating ...; Created on 29 July 2021
10. Zoho Creator: Receive JSON via a Shopify Webhook: / Zoho /; ... replace the my_owner and my_app with your Zoho Creator owner and app name respectively) Update 2022: I've included the code to verify the webhook came from Shopify: // // declare response variable back ...; Created on 15 July 2021
11. Zoho Creator: Add a subform while creating a record: / Zoho /; ... form is called "Quotes" and my subform is called "Line_Items": // initialize variables // ... this is a demo so ... do your own ... // // get source data r_QuoteDetails = zoho.crm.getRecordById("Quotes", ...; Created on 14 July 2021
12. Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party API: / Zoho /; ... on line 86 Rather than assuming Zoho Deluge maps and lists are JSON variables, let's send a strange hack instead: m_NestedRequest = Map(); m_NestedRequest.put("auth[key]",v_AuthKey); m_NestedRequest.put("auth[secret]",v_AuthSecret); m_NestedRequest.put("data[member_id]","123456"); m_NestedRequest.put("data[channel_name]","shopify"); m_NestedRequest.put("data[item_name]","Joel ...; Created on 03 February 2021
13. 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
14. Expecting ZC_SUBFORM_250 expression found COLLECTION: / Zoho /; ... for inserting a row into a subform: // declare a variable to hold the collection of rows = Collection(); // declaring the row = .(); // assigning values for various subform fields in the ...; Created on 19 October 2020
15. AutoHotkey: Get Media Information and Display: / AutoHotkey /; ... ) { ; v.90 By SKAN on D1CC @ goo.gl/jyXFo9 Local Static xDetails If ( sFile = "" ) { ; Deinit static variable ...; Created on 07 August 2020
16. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Books: / Zoho /; ... to work on the CRM record: // assuming I have a creator form called "myForm" // that the ID of the record is the value of the variable "myRecordID" // that a subform exists in the form called "Attachments" // ...; Created on 15 May 2020
17. Zoho Deluge - Compare time and currenttime with timezone: / Zoho /; What? This is a quick article to demonstrate how to compare two datetime values with the timezone specified. Why? A client's ZohoCRM had a different timezone setting than the user a script would ...; Created on 13 January 2020
18. Zoho Deluge - Get Refresh/Access Token API v2: / Zoho /; ... // NOTE: convert this to a JSON Array r_RecordUpdate = invokeUrl [ url :v_EndPoint type :PUT headers: m_Header parameters:m_Data.toString() ]; // NOTE: convert parameters variable to a string ...; Created on 17 July 2019
19. CSS Printing - Page Break Inside with Headers and Footers: / Cascading Stylesheets /; ... and the next page has a table which is of variable length. Fine when the table was short and didn't have many rows. But the client will pick up the phone to you when the table has too many rows to fit ...; Created on 22 February 2019
20. Google Drive API v3 - OAuth2 using Service Account in PHP/JWT: / Google /; ... logic and highlight any changes you may need to make. 1. First: the variables are in arrays Well mostly. Simply because we'll be working with JSON data and this encodes/decodes easily into PHP ...; Created on 02 February 2019