Search - Joel Lipman .Com

1. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... a new Product Image Joellipman.com: Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments) Joellipman.com: Zoho Deluge: Get Image Uploaded in Creator Form Joellipman.com: ...; Created on 17 October 2021
2. Zoho Creator / eBay: Get all Active Products: / Zoho /; ... Map datatype. How? I'm not going to go into detail on how I create an access token to query the eBay Trading API as you can read this in my article: Joellipman: Zoho Creator: Push to eBay Listings. ...; Created on 13 October 2021
3. Zoho CRM: Get Unique Values of a Text Field: / Zoho /; ... = invokeUrl [ url :"https://www.zohoapis.eu/crm/v2/coql" type :POST parameters: m_Params.toString() connection: "joels_coql_connection" ]; // // output info r_Coql; But ...; Created on 08 October 2021
4. Zoho Books: Display Sales Order Shipping Address on Package Slip: / Zoho /; ... $ $ and in my Sales Order: BILLING ADDRESS SHIPPING ADDRESS ------------------- ------------------- Test Company Joels PO Box 1 Test Street 1 Different Street Test ...; Created on 07 October 2021
5. Zoho CRM: Upload a Product Photo using Deluge: / Zoho /; ... photo to CRM: // init v_AppOwner = "joel_the_awesomest"; v_AppName = "joels_app"; v_ReportName = "My_Report"; // specify your CRM record ID for this product v_CrmProductID = 1234567890123456789; // ...; Created on 27 September 2021
6. Zoho CRM & Zoho Books: Get Books Currency and Tax IDs: / Zoho /; ... check the URL for whether it will be https://books.zoho.eu or https://books.zoho.com. You will also need your own CRM to Books connection name (joel_books) with scope to read settings: // our made ...; Created on 24 September 2021
7. ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.: / Zoho /; ... url: v_Endpoint type: PUT parameters: m_ShippingAddress.toString() connection: "joels_connector" ]; info r_UpdateSO; } } Source(s): Zoho Community ...; Created on 22 September 2021
8. Zoho CRM & Zoho Bookings Issue: Full Name appears in Last Name (first name first name last name): / Zoho /; ... in the last name field and creating a contact called "Firstname Firstname Lastname" (eg. "Joel Joel Lipman" - when Joel is not my middle name). How? This is a setting that is enabled by default in ...; Created on 01 September 2021
9. Zoho CRM & Zoho Books: Get SalesPersons: / Zoho /; ... snippet of code, I am getting the Zoho CRM record owner, looping through all salespersons in Zoho Books, and retrieving the salesperson_id. Also I have a connector to ZohoBooks called "joel_books". The ...; Created on 30 August 2021
10. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines): / Zoho /; ... sample data v_Test = "00011,Joel Lipman,\"Flat 8, House Corner\",Brummieland"; // regex to replace a comma found between 2 double-quotes to a string of your choice v_FormattedString = v_Test.replaceAll("(\"[^\",]+)[,]([^\"]+\")","$1|mySpecialComma|$2",false); info ...; Created on 26 August 2021
11. Zoho CRM & Zoho Books: Custom Related Lists Deluge: / Zoho /; ... = zoho.creator.getRecords(v_OwnerName,v_AppLinkName,v_ViewLinkName,v_Condition,1,100,"joels_connection"); v_ResponseCode = ifnull(r_SearchResults.get("code"),500).toLong(); // // if found records if(v_ResponseCode ...; Created on 30 July 2021
12. Zoho Deluge: Zoho Bookings Get Available Slots: / Zoho /; ... = zoho.bookings.getWorkspaces("joels_connector"); l_Workspaces = r_WorkspaceResults.get("response").get("returnvalue").get("data"); for each r_Workspace in l_Workspaces { if(!isnull(r_Workspace.get("id"))) { v_WorkspaceName ...; Created on 23 June 2021
13. Zoho Projects: Deluge to Submit Custom Fields: / Zoho /; What? A super quick article to demonstrate an example where we create a project with custom fields. Why? At time of print, the documentation on the Projects API would only show responses rather ...; Created on 17 June 2021
14. Zoho CRM: Update a custom field in line items / product details using REST API v2.1: / Zoho /; ... , "Modified_By": { "name": "Joel Admin", "id": "123456" }, "Created_Time": "2021-05-17T11:02:59+01:00", "id": "98498465735491156", "Created_ ...; Created on 17 May 2021
15. Zoho Projects: Add a Time Log to an Issue using Deluge: / Zoho /; ... > Connections) Click on "Add Connection" and click on "Zoho OAuth" Give a lower connection name, eg. "joels_connector" Select the scope ZohoProjects.timesheets.ALL as a minimum (or CREATE/READ): ...; Created on 30 April 2021
16. Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Deluge: / Zoho /; ... creating a record in a module that contains a lookup m_Create = Map(); m_Create.put("Name","Joels Amazing Test"); r_Create = zoho.crm.createRecord("Tests", m_Create); // now take the ID that was created ...; Created on 28 April 2021
17. Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party API: / Zoho /; ... "data": { "member_id": "123456", "channel_name": "shopify", "item_name": "Joel's Awesome Life", "item_price": "priceless" } } What Zoho sends to the 3rd-party API: Sending a map request ...; Created on 03 February 2021
18. Zoho Deluge: Sort a Map by a specific field: / Zoho /; ... Joel 1977-11-14T12:30:00+00:00 8949 Anonymouse 1923-10-16T15:00:00+00:00 335448 Amazing 1997-07-05T23:15:00+00:00 What I want: id name date --------------------------------------------- 335448 ...; Created on 29 January 2021
19. Zoho Deluge: Convert Map to HTML Table without a FOR loop: / Zoho /; ... NameLast NameID Joel Lipman 1 Another Person 2 How? This is a bit of a dirty solution and as long as "id" is not your first column (because "id" can be found in names like "David") it will work. ...; Created on 11 January 2021
20. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... Created: 2020-10-27 (Joel Lipman) - Initial release - Workflow to calculate 80% dept workforce - Returns response as popup - Cancels submit with ...; Created on 10 December 2020