Search - Joel Lipman .Com

1. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... "Fn - eBay - Get Active Products" and give it the internal name as "fn_GetEbayActiveProducts" without any arguments. Something to note in the below is that it asks you to set an estimated number of products ...; Created on 01 March 2023
2. ZohoDeluge: Inserting a new line character in a CSV: / Zoho /; What? A super quick article on something that almost deserves its own article: using new lines in ZohoDeluge. Why? My use-case here is that I was generating a comma separated values (CSV) file ...; Created on 01 March 2023
3. Zoho Creator: Disable/Hide the add and delete subform row buttons: / Zoho /; ... on your CSS with regard to referring to elements by ID, so for example, if my subform is called "Item Details", then I would adjust the code to something like the following: // // CSS overrides v_CssNotes ...; Created on 28 February 2023
4. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo: / Zoho /; ... I don't know. Consider doing a Google search."); } } // // output return m_Response; Yields something like the following: Text-Davinci-003: (preceded ChatGPT API) // // initialize m_Respon ...; Created on 13 February 2023
5. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; ... = zoho.recruit.getRecords("Candidates",v_FromIndex,v_ToIndex,"Modified_Time","CANDIDATEID","asc","jl_recruit"); //info l_Candidates; // // sanity check to output that it did something info "Done: " + ...; Created on 08 February 2023
6. ZohoCRM: Import Attachments: / Zoho /; ... spinny progress animation or go and do something more productive: Ensure the CSV files are selected for mapping (in this case Attachments.csv and Contacts_001.csv - by the way, my Attachments.csv ...; Created on 16 January 2023
7. Zoho Analytics: Set Up a Widget Displaying Sales Person: / Zoho /; ... I select on a dashboard. First you will need a table or query that has a bunch of columns and rows with one of the columns containing the sale person name. Something like the following: With ...; Created on 24 October 2022
8. Zoho Creator: Populate a Multi-Lookup: / Zoho /; ... called "Zoho Inventory Package Slips" and I'm adding these to a Creator form called "Appointment", my code should be something like the following: // // get 100 most recent appointments where this field ...; Created on 18 August 2022
9. Zoho Books/Inventory: Trigger a workflow when an invoice has been paid: / Zoho /; What? An article on something that has taken me several days to get working: Get Zoho Books or Zoho Inventory that when an invoice is marked as paid, update 2 custom fields with the Payment Method, and ...; Created on 17 August 2022
10. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; ... port at the same time, something last I built a PC was not possible. However, it was suggested that a modern motherboard BIOS allows you to enable this. It's just a setting in the BIOS if your motherboard ...; Created on 12 March 2022
11. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... AuthToken (Multi Line) AuthToken Expiry (Date-Time) You should end up with something like this screenshot: * Some of these fields are unnecessary for this example but are used to accommodate ...; Created on 14 February 2022
12. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile): / Zoho /; ... wanted that if the status had changed to something else, the first-line agent would not be allowed to set it back to "New Lead". Automations and workflows could however (run as Administrators). Mapping ...; Created on 11 February 2022
13. ZohoCRM: Template: not being able to edit a text box: / Zoho /; ... the header section) but then they changed address and couldn't change the template. So they had something like: $ $ $ $ $ 11 My Street, My City, My State, My Zip, My Country They wanted to get ...; Created on 25 January 2022
14. 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
15. Zoho Creator: Copy Subform to other Subforms: / Zoho /; ... The form I have looks something like the following: and displays as something like this: The code I create a workflow that when the decision box "Copy Monday to the Other Days" is clicked it ...; Created on 17 November 2021
16. Zoho CRM & Deluge: Adding 10 minutes to a CRM Date Time field: / Zoho /; ... to add 10 minutes to a date/time field in ZohoCRM and wanted a refresher for use in a client system. The usual error is something similar to the following: { "code": "INVALID_DATA", "details": { ...; Created on 11 November 2021
17. Zoho Deluge: Today, Tomorrow, Day After but Skip Sunday: / Zoho /; ... PDT 2022,Fri Jul 29 00:00:00 PDT 2022 But if I were to maintain the idea above and skip a selected day, I would write something like the following: // // initialize list to hold valid appointment ...; Created on 02 November 2021
18. Zoho Creator: Change Radio into Tabs: / Zoho /; ... First, let's add a Notes field to the Creator form, I'm calling mine Note_CSS, then I have added a radio group called Tabs [NB: If you rename it from "Tabs" to something else, all CSS references need ...; Created on 22 October 2021
19. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attach: / Zoho /; ... type: GET connection: "joels_connector" ]; info r_Templates; // // yields something like: /* { "total_count": 5, "templates": [ { "created_time": "2019-08-28T16:30:33Z", ...; Created on 21 October 2021
20. Zoho Deluge: Generate List of TimeZones: / Zoho /; ... on) v_TimeZone = v_TimeZone.replaceAll(","," ", true); info v_TimeZone; l_TimeZones.add(v_TimeZone); } //info l_TimeZones; Yields something like: (GMT-10:00) Hawaii Time (GMT-8:00) Alaska ...; Created on 19 October 2021