Search - Joel Lipman .Com

1. Zoho Creator: Prevent Endless Loops On User Input of a Field: / Zoho /; ... every time we want to tweak the code. There are also cases we don't want to use a standalone function as we want the code to read from the input fields dynamically and in real-time. To this end, I create ...; Created on 19 September 2021
2. PHP Issue: simplexml_load_string parser error : Input is not proper UTF-8, indicate encoding !: / Personal Home Page /; ... in PHP with the function simplexml_load_string(). The error I get is something similar to: PHP Warning: simplexml_load_string(): Entity: line #: parser error : Input is not proper UTF-8, indicate encoding ...; Created on 02 August 2016
3. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... initialize v_Response = previousParam; m_Response = Map(); m_Response.put("todo","prompt"); l_Messages = List(); // // capture latest message from user v_Message = ifnull(userInput,""); m_Thread ...; Created on 06 March 2023
4. Zoho Creator: Disable/Hide the add and delete subform row buttons: / Zoho /; ... the displayed note of "Add your Note here...") input.CSS_Overrides = v_CssNotes; Additional If you don't want to apply this to the every subform on that form, you will need to brush up a little ...; Created on 28 February 2023
5. ZohoCRM: Import Attachments: / Zoho /; ... Set program Defaults ; -------------------------------------------------------------------------------------- #NoEnv #Warn SendMode Input SetWorkingDir %A_ScriptDir% #SingleInstance force v_Company ...; Created on 16 January 2023
6. Zoho Inventory: Mark a package slip as delivered and shipped: / Zoho /; ... check the form was ticked and there is a package ID specified if(input.Mark_as_Complete && input.Zoho_Package_ID != "") { v_PackageID = input.Zoho_Package_ID; r_PackageSlip = zoho.inventory.getRecordsByID("packages",v_BooksOrgID.toString(),v_PackageID,"ab_inventory"); if(r_PackageSlip.get("package") ...; Created on 14 July 2022
7. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... OnSubmit > click on Create Workflow Select you want to run some Deluge Script and plug in the following code if(!isnull(input.Zoho_Inventory_ID)) { // // specify your own Inventory/Books organization ...; Created on 31 March 2022
8. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; ... "it's a poor workman who blames his tools". Let's make do with what we have. The 2 Acer monitors only have DVI and VGA inputs. The 3 Dell monitors can daisy chain with a combination of DisplayPorts and ...; Created on 12 March 2022
9. Zoho CRM & Creator: Download attachment and upload to Creator file field: / Zoho /; ... = v_NoteAttachments + "" + v_DateAdded + " " + v_LinkToDownload + " "; } } v_NoteAttachments = v_NoteAttachments + ""; input.Note_Attachments = v_NoteAttachments; Here's the code at the end of ...; Created on 11 March 2022
10. Zoho Creator: Radio group into Calendar Carousel: / Zoho /; ... (eg. "Wednesday9March"), which yields the following: Then I get rid of the label with the following CSS: label.zc-Calendar_Day_Select-label Then get rid of the round circles for radio inputs ...; Created on 09 March 2022
11. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile): / Zoho /; ... ******************************************************************************* Function: fn_Validate_LeadStatusChange Trigger: Function executed when a record is changed Inputs: ...; Created on 11 February 2022
12. Zoho Creator: eBay: Get Item Transaction: / Zoho /; ... can use the following code, note that the parameter is the eBay Item ID: void API.fn_eBayQuery_GetItemTransaction(int p_ItemID) { /* Function: fn_eBayQuery_GetItemTransaction() Input: ...; Created on 22 January 2022
13. 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
14. ZohoCRM & Xero Real-Time Invoices: Receive Webhook: / Zoho /; What? So this is an article expanding on my article Zoho Deluge - Connect to Xero API and explores how instead of a schedule, we can get Xero to tell ZohoCRM whenever an invoice or contact gets updated ...; Created on 10 January 2022
15. Zoho Creator/Deluge: Calculating with Timezone Offset: / Zoho /; ... System_Date_Time_End, Agent_Date_Time_Start, and Agent_Date_Time_End: // defaults v_AppointmentDuration = 30; // // get customer's requested time v_CustomersRequestedTime = input.Customers_Requested_Time.toTime(); v_CustomerTimeZoneName ...; Created on 07 December 2021
16. Zoho Creator: Copy Subform to other Subforms: / Zoho /; ... runs the following deluge script: // only run if true if(input.Copy_Monday_to_the_Other_Days) { // init c_Tuesday = Collection(); c_Wednesday = Collection(); c_Thursday = Collection(); ...; Created on 17 November 2021
17. Zoho Creator: Change Radio into Tabs: / Zoho /; ... = v_Css + ".zc-Tabs-label"; v_Css = v_Css + ""; input.Note_CSS = v_Css; Yields Then aligning these radio options horizontally: v_Css = ""; v_Css = v_Css + ".zc-Tabs-label"; v_Css = v_Css ...; Created on 22 October 2021
18. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... held in v_ListingPublishKey and lastly, my datacenter is .COM: URL Syntax #1 // works in eBay v_ImageSrc = "https://creator.zoho.com/file" + zoho.appuri + "Portal_Listing_Report/" + input.ID + "/Main_Photo/image-download/" ...; Created on 17 October 2021
19. Zoho Creator: Two submit buttons on a non-stateless form with 2 different redirects: / Zoho /; ... > Click on "New Workflow" Choose your form Run when a record is "Created or Edited" When to trigger workflow is "User input of a field" Choose Field "Save & Close" Name the workflow "OnSubmit_SaveClose" ...; Created on 27 July 2021
20. Zoho Creator: Assign an integration field value with an integration value: / Zoho /; ... with .toLong(). Say I have an integration field on my form called "CRM Account" with field link name "Account"; Then I have a workflow on user input of the field to save this directly to the record; ...; Created on 27 July 2021