Display Feeds to major Social Networkshttps://www.joellipman.com/articles/web-development/display-feeds-to-major-social-networks.html

16 May 2016 embedding the page comes up. Go to Instagram and open the video/picture to embed Click the 3 dots (ellipsis) at the bottom right of the description. Click Embed From the box that appears, Copy & Paste the code into your blog or website HTML. YouTube Go...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

MS Excel - Split Workbook into separate files per sheethttps://www.joellipman.com/articles/microsoft/excel/ms-excel-split-workbook-into-separate-files-per-sheet.html

11 February 2019 Insert > Module and paste below code ' Ensure your cursor is blinking in the "RunAll" subroutine (displays RunAll in the top right) ' Press F5 to run the code. ' You will be prompted for the total range (eg. $A1:$W36000) ' And then prompted for the...

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

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

23 September 2019 screen/viewport in pure CSS (no JavaScript allowed). This CSS centers it by its center point rather than the top/bottom/left/right outline. Why? On a mobile, a client's site uses an external page embedded by iframe. When the app within the iframe has an...

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

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

08 July 2020 List ; 0x1000 adds a grooved border ; 0x200 aligns horizontal to left and vertically centered (0x201: center center, 0x202: right center) Gui, Add, Text, w350 h28 x120 y11 -Multi vSelectedDir gBrowseFolders 0x1000 +0x200, %DefltDir% Gui, Add, Button,...

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

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

14 July 2020 different articles out there and discussion forums that do 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...

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

Zoho Deluge: Setup an API Connection for InvokeURLhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-setup-an-api-connection-for-invokeurl.html

12 August 2020 inventory, subscriptions as these are simillar), go to edit a custom function and click on the "Connections" link to the top right of a function: If this is your first connection, simply click on the "Go To Connections" button Select "Custom Service"...

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

Zoho Creator Page: Toggle On/Off Switch: Hide/Display a Divhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-page-toggle-on-off-switch-hide-display-a-div.html

22 October 2020 padding-left: 14px; background-color: white; color: #ff7058; } .onoffswitch-inner:after { content: "Photo View"; padding-right: 18px; background-color: #ff7058; color: white; text-align: right; } .onoffswitch-switch { display: block; width: 18px;...

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

Zoho Creator: Create a Widget which uses JavaScripthttps://www.joellipman.com/articles/crm/zoho/zoho-creator-create-a-widget-which-uses-javascript.html

24 October 2020 the root html file along with the path (do not forget the leading slash or your widget will error) Click on "Create" (bottom-right of your screen) Now go to a Creator page (new or existing), select "Widgets" and drag your new Widget to the page: Don't...

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

Zoho Creator: Receive JSON via a Shopify Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-receive-json-via-a-shopify-webhook.html

15 July 2021 to copy the url to clipboard. 3. Set up the Shopify webhook Log-in to your Shopify as an admin Go to Settings (left sidebar right at the bottom) Click on Notifications Scroll all the way down the page until you arrive at Webhooks Click on Create webhook...

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

Zoho Creator: Two submit buttons on a non-stateless form with 2 different redirectshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-two-submit-buttons-on-a-non-stateless-form.html

27 July 2021 0 rgb(107 71 244 / 33%); border-radius:5px; width:100px; max-width: 100px !important; min-width: 100px !important; float: right !important; margin-right: 40px !important; } .zc-Save_and_Close-group label:hover{ background-color: #613DEA; } In Workflow >...

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

Zoho CRM & Zoho Bookings Issue: Full Name appears in Last Name (first name first name last name)https://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-bookings-full-name-appears-in-last-name.html

01 September 2021 applying the fix. So the fix is a setting: Login to Zoho Bookings as the admin Click on the settings cog icon in the top right corner Navigate to the appropriate workspace Click on Registration Form Configure the field for Guest Users Hover over "Name"...

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

Zoho CRM: Template: Empty Space between Header and Line Itemshttps://www.joellipman.com/articles/crm/zoho/zoho-crm-template-empty-space-between-header-and-line-items.html

03 February 2022 Setup > Customization > Templates > Inventory > Select the template with this issue Click on the "Edit HTML" icon in the top right of the editor: Find the code "page-break-inside" Change this from "avoid" to "auto": And optionally, add to the "" tag...

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

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

08 February 2022 = 12.000; info v_Test2.toString().replaceAll("(\\.\\d*?[1-9])0+$", "$1", false); // yields 12.000 So this isn't quite right, so let's get a regex that rounds numbers up but pays attention to where the decimal point is: v_Test3 = 12.000; info...

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

Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile)https://www.joellipman.com/articles/crm/zoho/zoho-crm-using-a-function-for-validation-rules.html

11 February 2022 to first-line agents also wouldn't help as some of the options should be selectable. Two separate fields weren't quite right either: 1 as read-only (permission only to higher level) and 1 picklist as selectable means that the first-line agent would be...

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

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

14 February 2022 Click on "Save" Click on "Install App" button in the top right Confirm by clicking on "Install" button in the popup You will be shown your Admin API access token > Store this in the Access Token field of your Creator form. If your app needs the...

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

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

09 March 2022 week which they can then click on to select a particular day. Some navigation is required in the form of a left arrow and right arrow to see previous or next weeks respectively. What I have: What I want: How? This was achieved using some CSS and then...

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

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

29 June 2022 and password. After you have logged in, look for the menu option Account and Lists which should show somewhere along the top right of the home screen. Under Account and Lists, look for Your devices and content > Manage Devices. You will get to see the...

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

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

20 July 2022 version 100 and is correct at time of print. Open Chrome Web Browser Click on the vertical ellipsis/3 dots icon int the top right Click on “Settings” Click on “Privacy and Security” Click on “Site Settings” If the ZohoDesk activity appears then click...

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

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

18 August 2022 Why? Yes you can do this already by going to the record, clicking on the ellipsis or three horizontal dots button in the top right and selecting "Send Mail" then selecting which inventory template to use... This is too many steps for some. Instead,...

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

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

24 October 2022 the sale person name. Something like the following: With these kind of columns available to you: Click on Widget in the top right Under "Data Column", select any field in your table/query which is not the one to display Under "Group By", select the...

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