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

27 July 2021 the workflow "OnSubmit_SaveClose" Add your deluge code that should: Validate the fields (checks mandatory fields have been entered) for example: // // check mandatory fields have been entered l_Errors = List(); if(isnull(input.Record_Name)) {...

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

ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM recordhttps://joellipman.com/articles/crm/zoho/zohoflow-zohosign-retrieve-a-zoho-sign-document-request-and-add-attachments-to-crm-record.html

17 October 2022 built into Zoho Flow that will accept as parameter the document_id and request_id. It then retrieves the Deal Reference (entered by an office signee) on the ZohoSign document and searches for the relevant Deal record in CRM. Why? A client wants that...

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

Zoho CRM: Manage a subform using Client Scripthttps://joellipman.com/articles/crm/zoho/zoho-crm-manage-a-subform-using-client-script.html

09 December 2022 l_NewSubformRows = new Array(); for (i = 0; i...

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

Zoho Webhooks & Shopify API: Keep Disappearinghttps://joellipman.com/articles/crm/zoho/zoho-webhooks-shopify-api-automatically-restore.html

22 April 2024 ID and a client secret and resulted in an access token // the client secret used when generating the access token should be entered here v_ClientSecret = "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"; // // store the record in ZohoCreator // I have a custom...

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

GDPR Privacy Policyhttps://joellipman.com/static-items/gdpr-privacy-policy.html

14 February 2019 under the rules then prevailing of the American Arbitration Association. The arbitrators' award shall be binding and may be entered as a judgment in any court of competent jurisdiction. To the fullest extent permitted by applicable law, no arbitration...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Project Plan for Freelance Websitehttps://joellipman.com/articles/web-development/project-plan-for-freelance-website.html

25 February 2010 or clients. Startup Meeting For you to discuss: Aims / Objectives Deadlines / Milestones Target Audience (Internally Centered? / Customer Focused?) Outsources? (Is JoelLipman.Com Project Manager? other 3rd-parties?) Contacts within Client company?...

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

SQL Queries for Statisticshttps://joellipman.com/articles/database/mysql/sql-queries-for-statistics.html

13 December 2010 itself is the index page loaded for any page in the Wiki system. It logs the IP address (VisitorIP), the URL (VisitorURL) entered via the browser useragent (VisitorUAgent), the User ID (VisitorID, 0 if not logged in) and of course the Timestamp...

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

Sort order a dropdown list in MS InfoPath without programminghttps://joellipman.com/articles/microsoft/infopath/sort-order-a-dropdown-list-in-ms-infopath-without-programming.html

21 July 2011 a SharePoint List (datasheet) and when I made my form dropdown read from the list, it just put elements in the order that I entered them in the datasheet. Googling this led me to browse MSDN for an hour before I realised all those experts were using...

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

Inline Labels in Form Fields using Javascripthttps://joellipman.com/articles/web-development/js/inline-labels-in-form-fields-using-javascript.html

21 August 2012 I've added some code to trim the values. If the user types two spaces, then we want the field to understand this as "no one entered anything", treat it as empty. this.value.split(' ').join('') -- split this value into an array separated by the delimiter...

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

Licence GNU/GPLhttps://joellipman.com/static-items/licence-gnugpl.html

03 April 2009 or (b) primarily for and in connection with specific products or compilations that contain the covered work, unless you entered into that arrangement, or that patent license was granted, prior to 28 March 2007. Nothing in this License shall be construed...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Error 1065: Query was Emptyhttps://joellipman.com/articles/database/mysql/error-1065-query-was-empty.html

13 December 2012 the usual suspects. Developers will have told the system what to do when newline, carriage returns and tab characters are entered in the data. Those who are security-conscious will also make their system escape apostrophes (') and double-quotes ("). But...

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

Client Services: Website Development Agreementhttps://joellipman.com/static-items/client-services-website-development-agreement.html

15 November 2013 agreed: Parallel running with legacy systems – testing and confirmation that both systems are operational, data needs to be entered in both systems. (this is only necessary if this is an upgrade or replacement of an existing system). Warranty checks...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Transferring Apps (purchases) from iPhone 4s to 5s on a Windows PChttps://joellipman.com/articles/apple/ios/transferring-apps-purchases-from-iphone-4s-to-5s-on-a-windows-pc.html

03 November 2013 default to a different backup so click on the dropdown to make sure it's the one you just made). Enter the password you entered when creating the Encrypted Backup. Wait for the restore to complete. The new phone will restart but you have to wait for the...

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

Convert foreign characters to English alphabethttps://joellipman.com/articles/database/mysql/convert-foreign-characters-to-english-alphabet.html

13 June 2016 -()\-.]' Joomla! Additional My Joomla website needed the following code to display the above foreign characters as entered into the Joomla administrators console with accents and all: html_entity_decode(htmlentities($ftext, ENT_COMPAT,'UTF-8', true),...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• 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 keyboard are enabled. Which numbers you might ask? Well every character is built of a collection of digits that are to be entered in their specific order. Search for "Alt Codes" or "Symbol Codes" in a search engine for a full list. Meanwhile, here's...

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

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

08 February 2023 and scope. Error(s) Encountered: {"code":"4401","message":"Unable to populate data, please check if mandatory value is entered correctly."}: Check your connection string. {"code":"9832","message":"Mandatory parameter(s) missing"}: Not sure why as the...

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

ZohoCRM: Integrate ChatGPT to ZohoZIAhttps://joellipman.com/articles/crm/zoho/zohocrm-integrate-chatgpt-to-zohozia.html

06 March 2023 and datasets. Planning Need to ensure data fed into a session is not shared or available to external sources once entered into OpenAI. If I train OpenAI on a dataset, can that data be accessed by external sources? No, if you train OpenAI on a dataset,...

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

Zoho Deluge and Wordpress/WooCommerce API: Get All Productshttps://joellipman.com/articles/crm/zoho/zoho-deluge-and-wordpress-woocommerce-api-get-all-products.html

15 April 2024 all the products from a WooCommerce instance on a client's Wordpress website. Why? A client of ours wants the information entered against products in their WooCommerce to display on their estimates in Zoho Books; such as product image, product name,...

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

ZohoDeluge: eBay marketplace account deletion/closure notificationshttps://joellipman.com/articles/crm/zoho/zohodeluge-ebay-marketplace-account-deletion-closure-notifications.html

13 March 2025 code. So I created a function within ZohoCRM to return the challenge and made it into a REST API function with a zapikey. I entered the URL ZohoCRM gives me as the endpoint for the eBay challenge. Here's my function in full as a webhook: string...

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