CSS Center an iFrame Horizontally and Verticallyhttps://joellipman.com/articles/web-development/css/css-center-an-iframe-horizontally-and-vertically.html

23 September 2019 has a height of 2000 pixels, the iframe gets aligned to the top of the parent... How? We're going to use a touch of CSS and instead of determining heights and alignment with JS. The following code will work with DIV layers but in this case, also works...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: en-GB

Zoho Deluge - First Monday of Month or Last Tuesday of Monthhttps://joellipman.com/articles/crm/zoho/zoho-deluge-first-monday-of-month-or-last-tuesday-of-month.html

27 September 2019 month is before the current date, then set it to the last Tuesday of next month. Why? This was a request by a client who instead of specifying the 1st of every month, or 15th of each month, to say the first Monday of the month (ignoring bank holidays)...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: en-GB

Zoho CRM/Creator - Common Errors & Gotchashttps://joellipman.com/articles/crm/zoho/zoho-crm-creator-common-errors-gotchas.html

06 February 2020 r_Response = invokeurl [ url :v_DataEndpoint type :GET connection: myConnector ]; Solution: My endpoint was specifying COM instead of EU as per the client's data center: v_DataEndpoint = "https://books.zoho.eu/api/v3/contacts?organization_id=123456789";...

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

AutoHotkey: App GUI Listview to Rename Fileshttps://joellipman.com/articles/automation/autohotkey/autohotkey-app-gui-listview-to-rename-files.html

08 July 2020 , *%A_ScriptDir%, 0, Select a folder to scan... if (SelectedFolder != "") { ; remove trailing slash (could use RTrim instead) SelectedFolder := RegExReplace(SelectedFolder, "\\$") GuiControl, Text, SelectedDir, %SelectedFolder% } else GuiControl, Text,...

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

Zoho Creator: Set Up Custom Domain for Customer Portalhttps://joellipman.com/articles/crm/zoho/zoho-creator-set-up-custom-domain-for-customer-portal.html

17 November 2020 to paying for another domain. If you want to put the customer portal on a subdomain (eg. "customerportal.joellipman.com" instead of "www.joellipman.com"), then please refer to your domain registrar's website on how to setup a subdomain. Here is the gist...

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

Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party APIhttps://joellipman.com/articles/crm/zoho/zoho-deluge-post-a-multi-dimensional-or-nested-array-to-a-3rd-party-api.html

03 February 2021 on line 86 Rather than assuming Zoho Deluge maps and lists are JSON variables, let's send a strange hack instead: m_NestedRequest = Map(); m_NestedRequest.put("auth[key]",v_AuthKey); m_NestedRequest.put("auth[secret]",v_AuthSecret);...

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

Zoho Projects: Add a Time Log to an Issue using Delugehttps://joellipman.com/articles/crm/zoho/zoho-projects-add-a-time-log-to-an-issue-using-deluge.html

30 April 2021 minutes). Error(s) Input Parameter Missing (6831): Can happen when there are either too many parameters or one is missing. Instead of abiding by the API documentation which was out of date at time of print, trial and error will resolve this or use our...

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

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

03 June 2021 utf-8 encoding will help but there will be times when you have lost the formatting and get weird question mark characters instead such as: . How? Ensure you are using the numbers on your numeric keypad and NOT the numbers at the top of your keyboard...

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

Zoho CRM & Zoho Books: Get SalesPersonshttps://joellipman.com/articles/crm/zoho/zoho-crm-zoho-books-get-salespersons.html

30 August 2021 or so trying to get the Zoho.books.getRecords() function to filter the sales persons, I gave up and used a for each loop instead. In the next snippet of code, I am getting the Zoho CRM record owner, looping through all salespersons in Zoho Books, and...

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

Zoho Creator: Prevent Endless Loops On User Input of a Fieldhttps://joellipman.com/articles/crm/zoho/zoho-creator-prevent-endless-loops-on-user-input-of-a-field.html

19 September 2021 If your MD5 value is different, then it means there was a change. If not then it is unlikely that any change was made. Instead, I need to add an additional field called "eTag_Title", check if the new MD5 is different, if it is then I proceed with the...

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

Zoho CRM: Schedule a Call using Delugehttps://joellipman.com/articles/crm/zoho/zoho-crm-schedule-a-call-with-deluge.html

18 November 2021 to check the JSON that is being returned for API names... If that were the case, it would have been a 5 minute job. Instead, it's turned into over an hour of figuring this out. So here's a working snippet of code: // test to get the JSON response format...

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

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

10 January 2022 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 in Xero. Why? I used to use ZohoCRM schedules to pull...

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

Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL)https://joellipman.com/articles/crm/zoho/zoho-creator-shopify-api-integration-oauth-2-0-update-2022.html

14 February 2022 inventoryItem { id } product { id } } } } }" Change from \"sku:" + v_SearchSKU + "\" to \"sku:'" + v_SearchSKU + "'\" So instead of: query: "sku:ABC 123" send query: "sku:'ABC 123'" The final graphQL for product id, variant id, inventory id, quantity,...

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

Zoho Creator: Radio group into Calendar Carouselhttps://joellipman.com/articles/crm/zoho/zoho-creator-radio-group-into-calendar-carousel.html

09 March 2022 + v_CssIndex + "'] span{background-color:#FF1493 !important;}"; // make boxes align horizontally instead of vertically v_Css = v_Css + "div.zc-Calendar_Day_Select .choice-table-cell{float:left}"; v_Css = v_Css + "div.zc-Calendar_Day_Select...

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

Zoho CRM & Zoho Inventory: Upload Image to Item Record using Delugehttps://joellipman.com/articles/crm/zoho/zoho-crm-zoho-inventory-upload-image-to-item-record.html

21 June 2022 How? We're not going to go into detail on how to parse an eBay response here (see my other articles on eBay webhooks). Instead, all we want is the URL of an image to be downloaded, then uploaded to the Zoho Inventory or Zoho Books item record. Well I...

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

Amazon Kindle: Send PDFs to your Kindlehttps://joellipman.com/amazon/kindle/amazon-kindle-send-pdfs-to-your-kindle.html

29 June 2022 approved. Follow steps 1 – 5 as stated under Finding your Kindle email address. However, click on Preferences this time, instead of Devices. Scroll down and select the Personal Document Settings Scroll down again and select the Approved Personal...

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

Zoho Desk: Re-enable Desktop Notifications after clicking on "Not Now"https://joellipman.com/articles/crm/zoho/zoho-desk-re-enable-desktop-notifications-after-clicking-on-not-now.html

20 July 2022 Why? I'm not sure when this prompt is supposed to prompt you again. A client of ours had accidentally clicked on "Not Now" instead of clicking on the "Enable". Documented below is how to get this to prompt you again. How? This largely depends on whether...

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

Zoho CRM / Deluge: Send an email with a CRM Quote using a given CRM templatehttps://joellipman.com/articles/crm/zoho/zoho-crm-send-an-email-with-a-crm-quote-using-a-given-crm-template.html

18 August 2022 the top right and selecting "Send Mail" then selecting which inventory template to use... This is too many steps for some. Instead, we've been asked to create a button that sits on the view page of a record and the staff simply click on and it does all...

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

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

03 November 2022 Additional Here are some other queries that are required for the above but you may want to use the out-of-the-box modules instead: Sometimes, a salesperson or user might be generating an invoice on behalf of the account manager (person who manages the...

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

ZohoCRM: Import Attachmentshttps://joellipman.com/articles/crm/zoho/zohocrm-import-attachments.html

16 January 2023 filenames herein. Perhaps if you were doing this over several imports, you could use the same filenames, I didn't try this, instead my program generates a unique MD5 for each file with the filename appended. Because of MS Windows 11 limitations (any MS...

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