Search - Joel Lipman .Com

1. Added a Launcher and Unduplicater: / Products /; Just a note to say that I've added two more programs which I regularly use to my download section on this website. As always, these are free to download and include the source codes under the GNU/GPL ...; Created on 19 May 2010
2. Zoho Creator: Error Code 2945: EXTRA KEY FOUND IN JSON: / Zoho /; ... zoho.appname, "Quote", m_QuoteRecord, m_Blank, "my_creator_connection"); // // SUCCEEDS: with r_Create = ,"message":"Data Added Successfully"} Source(s): Zoho Creator / API Status Codes Zoho Community ...; Created on 04 October 2023
3. Zoho Deluge: Get the Week Number if Week starts on a Monday: / Zoho /; ... // returns 2020 You should also pad single digit week numbers if we're going to store a year week value: v_ThisCurrentWeekNumber = if(zoho.currentdate.toString("u").toLong() == 7,zoho.currentdate.subDay(1),zoho.currentdate).toString("w"); v_ThisCurrentWeekNumberPadde ...; Created on 06 July 2023
4. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... if payment has already been recorded before creating a new one. - Fixed reference_number being included on customer payment. Date Modified: 2023-03-21 (Joel Lipman) - Added if conditions ...; Created on 27 April 2023
5. Zoho Deluge: Get All Orders from eBay: / Zoho /; ... Date Created: 2023-03-29 (Joel Lipman) - Initial release Date Modified: 2023-03-29 (Joel Lipman) - Added in ability to list errors and query order line item IDs (ErrCode: ...; Created on 29 March 2023
6. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; ... or that has been added to the system based on the business hours set at the organization level in ZohoCRM. How? Using an invokeURL, the key here is you'll find them in the settings; so check that ...; Created on 28 March 2023
7. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; ... that were in practice added to the same function and that worked at time of print. Note that this uses the old Trading API as the new API is only available in Sandbox??? I won't go into how to generate ...; Created on 28 February 2023
8. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... } } } The Deluge Code So this is a Zoho Creator function that I'm going to call API.fn_ShopifyQuery_UpdateAllProducts() and it will be added to a nightly schedule. It's aim is to recover all ...; Created on 20 February 2023
9. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... on how to do this: Youtube - Matt Wolfe - Install Stable Diffusion Locally. Ok it isn't MidJourney... But it's free. Defaulting some parameters to be added to every prompt /prefer suffix This ...; Created on 11 February 2023
10. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; ... each r_Data in r_Associated.get("data") { if(!isnull(r_Data.get("id"))) { // // search by record name to see if we've already added this record before // note the endpoin ...; Created on 08 February 2023
11. Zoho CRM: Manage a subform using Client Script: / Zoho /; ... value in a field, a row would be added to a subform contained herein. How? Well I won't go in to detail on how to add a client script, this article is just to show the snippet of code used in the ...; Created on 09 December 2022
12. Zoho Recruit: Rollup Number of Recruit Candidates to CRM Account: / Zoho /; ... helpful on the CRM record to see how many candidates had been placed at this particular CRM Account. We added several fields which get populated when a candidate was modified in ZohoRecruit. How? ...; Created on 19 October 2022
13. Zoho CRM / Deluge: Send an email with a CRM Quote using a given CRM template: / Zoho /; ... into a PDF using a customer's template. // // initialize (this is code added to a button so should alert user if no email was specified) v_OutputMessage = ""; v_TemplateID = "123456789012345678"; // // ...; Created on 18 August 2022
14. Zoho Creator: Populate a Multi-Lookup: / Zoho /; What? This is a very quick article with a code snippet on how I added to a multi-lookup field. Why? Using a multi-line or text is possibly a quicker solution and when using a desktop interface, ...; Created on 18 August 2022
15. Zoho Books/Inventory: Trigger a workflow when an invoice has been paid: / Zoho /; ... the Payment Date. Why? This was requested by a customer and the problem happened in that the workflow would simply not trigger when the invoice was paid. The customer had added 3 custom fields: ...; Created on 17 August 2022
16. Amazon Kindle: Send PDFs to your Kindle: / Kindle /; ... as you would any other reading stuff. It’s true you need to go through an initial set-up process which essentially boils down to getting your email ID added to the approved list as well as finding out ...; Created on 29 June 2022
17. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... one way, in other words, listings on eBay get downloaded to Zoho Inventory but not vice-versa. Then there's an added delay of 4 hours. Then item specifics in eBay's listings don't get parsed into custom ...; Created on 31 March 2022
18. Zoho CRM & Creator: Download attachment and upload to Creator file field: / Zoho /; ... r_CheckIfDocumentAlreadyExists.ID]; v_DateAdded = r_NewDocumentRecord.Added_Time.toString("E, d MMM yyyy HH:mm"); } else { r_Document = insert into Document [ Added_User=zoho.loginuser Document_Name=r_Attachment.get("File_Name") Document_File=r_Download Downloaded="Downloaded" Parent_Record=v_CrmContactID.toString() ]; r_NewDocumentRecord ...; Created on 11 March 2022
19. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeros: / Zoho /; What? A very quick article on a cool snippet of code, another regular expression, I've been trying out to round up a number or at least to remove the trailing zeros. I could have added this to my Zoho ...; Created on 08 February 2022
20. Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng): / Zoho /; ... record; use Zoho's GeoCode function to convert this into a latitude and longitude, then we're going to use a free TimeZone API (one that returns a timezone given a lat/lng). The added feature is that we ...; Created on 15 December 2021