Pure JS - Display Time Elapsed & Remaininghttp://mail.joellipman.com/articles/web-development/js/pure-js-display-time-elapsed-remaining.html

30 October 2018 was the last token created. How? So almost pure JS. I'm working out the seconds remaining and seconds elapsed in PHP first then passing these as two variables to the below code but you could get your values from anywhere: On page load, the seconds...

• Type: Article
• Author: Joel Lipman
• Category: JavaScript
• Language: *

Zoho Deluge: Get Image Uploaded in Creator Formhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-get-image-uploaded-in-creator-form.html

14 July 2020 cover this but it takes me so long to find the solution with the right syntax. How? So I'm going to start with 1 method and then update this article with other methods. Method #1: Display and access without login So the quickest is to have a form that...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Windows 10: Shortcut Apps to Settingshttp://mail.joellipman.com/articles/microsoft/windows-os/windows-10-shortcut-apps-to-settings.html

30 July 2020 that page or save myself a click... How? To test any of the following, type the windows key and select "Run..." ( + R). Then type the value in the 2nd column "App to Run" then OK to run it: Settings Page App to Run Settings Homepage ms-settings:...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments)http://mail.joellipman.com/articles/crm/zoho/zoho-creator-download-file-from-zohocrm-field-type-file-upload-not-attachments.html

02 February 2021 I have a client with ZohoCRM who upload a PDF (can be any file but is usually a PDF) to a custom module in their CRM; I then need the customer from the customer portal in a ZohoCreator app to be able to download this file. How? The trick to doing this...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Windows OS: Alt Codes / Symbols / Special Charactershttp://mail.joellipman.com/articles/microsoft/windows-os/windows-os-alt-codes-symbols-special-characters.html

03 June 2021 the ALT key (preferably the one on the left of the spacebar and not the Alt Gr often found on the right of the spacebar) then press the numbers in the numeric pad (while still holding down the ALT key), then let go of the ALT key. Remember: This will...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.http://mail.joellipman.com/articles/crm/zoho/zohocrm-to-zohobooks-please-ensure-that-the-shipping_address-has-less-than-100-characters.html

22 September 2021 you to get the ID of the Shipping Address... But let's say I don't know how to create a shipping address and retrieve its ID then here's the method I use: Create the sales order in ZohoBooks (either in Zoho Deluge or however you're doing it), then...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM: Upload a Product Photo using Delugehttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-upload-a-product-photo-using-deluge.html

27 September 2021 I want to update the photo in the CRM record. How? So we have to do the usual which is download the photo using invokeUrl then we set the paramname not to attachment but to file. We then use another invokeUrl to upload the photo to CRM: // init...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM: Get Unique Values of a Text Fieldhttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-get-unique-values-of-a-field.html

08 October 2021 Having spoken to Zoho and raised with 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? The...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Generate List of TimeZoneshttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-generate-list-of-timezones.html

19 October 2021 a quick way of extracting a SELECT list in someone else's form. How? So, let's copy the HTML select into a text editor, then escape the double-quotes, then prepend with a list declaration and append with a end of list suffix; loop through removing HTML...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Today, Tomorrow, Day After but Skip Sundayhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-today,-tomorrow,-day-after-but-skip-sunday.html

02 November 2021 function .addBusinessDay() but that excludes Saturdays which my client still works on. How? We're going to get today's date, then use the .addDay(), check none of these are a Sunday, and move the next few days along: thisDate = '2021-10-30'; v_Today =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM & Xero Real-Time Invoices: Receive Webhookhttp://mail.joellipman.com/articles/crm/zoho/zohocrm-xero-real-time-invoices-receive-webhook.html

10 January 2022 CRM record creation here } } } } } } } } // // return return {"crmAPIResponse":m_Response}; If you don't get an OK message then check your CRM code matches as above (with different v_Webhook_Key). If it still doesn't work then try solution #2: using a...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: eBay: Get Item Transactionhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-ebay-get-item-transaction.html

22 January 2022 an access token for eBay which I documented on how you can generate one in my article: Zoho Creator: Push to eBay Listings. Then you can use the following code, note that the parameter is the eBay Item ID: void API.fn_eBayQuery_GetItemTransaction(int...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Regex Rounding and/or Removing Trailing Zeroshttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-regex-rounding-and-or-removing-trailing-zeros.html

08 February 2022 possible so we don't breach a statement execution limit in the Zoho app function. How? If we're not going to use loops, then the next best thing I'm aware of is a regular expression. So the first expression I came up with worked to a certain point but...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Inventory: Mark a package slip as delivered and shippedhttp://mail.joellipman.com/articles/crm/zoho/zoho-inventory-mark-a-package-slip-as-delivered-and-shipped.html

14 July 2022 != null) { v_ShipmentID = r_PackageSlip.get("package").get("shipment_order").get("shipment_id"); // // if blank then create one if(v_ShipmentID == "") { m_Params = Map(); m_Params.put("date",zoho.currentdate.toString("yyyy-MM-dd"));...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Analytics: Set Up a Widget Displaying Sales Personhttp://mail.joellipman.com/articles/crm/zoho/zoho-analytics-set-up-widget-displaying-sales-person.html

24 October 2022 one to display Under "Group By", select the field that has the value you want to display. Under "Show Value As", select Max Then click on the "Settings" tab and do the following: Under Primary Value - Label, enter the static text you want to display...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Analytics: Determine profits from invoices and purchase ordershttp://mail.joellipman.com/articles/crm/zoho/zoho-analytics-determine-profits-from-invoices-and-purchase-orders.html

03 November 2022 or missing associated purchase orders altogether. I had to break this down into several queries to generate the dataset, then use these as pseudo-subqueries. The first task was to determine the cost of each item purchased; including shipping and tax....

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoRecruit: Create Linking Table for Candidates and Associated Job Openingshttp://mail.joellipman.com/articles/crm/zoho/zohorecruit-create-linking-table-for-candidates-and-associated-job-openings.html

08 February 2023 who has been associated to what job. In Zoho Recruit reports (Analytics), you can include the "Associate" module which then allows you to link the Candidates to the Job Openings; but my client needed to be able to query this via API and the "Associate"...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Disable/Hide the add and delete subform row buttonshttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-disable-hide-the-add-and-delete-subform-row-options.html

28 February 2023 seen on the front-end of the application but it must not be removed by Creator). If you know the code to remove this field, then you know what I mean. In Workflow mode: add a workflow to the form whenever it is created or edited, on load of the form; I...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM: Get All eBay Active Listingshttp://mail.joellipman.com/articles/crm/zoho/zohocrm-get-all-ebay-active-listings.html

01 March 2023 or stock check of all the products that are currently listed in a client's eBay store; we want to get the stock level and then use this data to synchronize with data held in Zoho Inventory... How? So we're going to use a ZohoCRM function to get this...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Determine if Daylight Savings are in effecthttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-determine-if-daylight-savings-are-in-effect.html

03 July 2023 If you're lucky enough to build an application for a client based in a country that changes its clocks twice a year, then I'm opening this article without a 100% certain solution as I need to wait about 4 months until I can confirm this works. Why? I've...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *