Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library)https://www.joellipman.com/articles/google/upload-file-to-google-drive-with-php-curl-and-api-rest-v3-without-library-install.html

29 October 2018 programmatically: Prevent editors from changing access and adding new people :: Set by "writersCanShare" = false Disable options to download, print and copy for commenters and viewers :: Set by "copyRequiresWriterPermission" = true To do this, set the...

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

Minimal Privileges for MySQL Database Backup Cron Jobhttps://www.joellipman.com/articles/linux/cpanel/minimal-privileges-for-mysql-database-backup-cron-job.html

20 March 2019 +"\%Y-\%m-\%d"`.sql.gz Additional Others around the web have suggested the following but I don't have these options to grant and would have to grant them via a terminal/command line to MySQL. GRANT SELECT, LOCK TABLES, RELOAD, PROCESS, TRIGGER, SUPER,...

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

Zoho Deluge: Duplicate/Clone a Recordhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-duplicate-clone-a-record.html

17 March 2020 Under Developer Space click on "Connections" Under Pick your Service click on "Zoho OAuth" (NOT "Zoho" - there are 2 Zoho options) Give the connection a name such as "myZohoConnector" Tick the applicable Scope(s): for example:...

• 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 app belongs to or does. eg. "https://www.joellipman.com/" Authorized Redirect URIs: for this put in one of the following options, again, based on the clients datacenter: US datacenter: https://deluge.zoho.com/delugeauth/callback EU datacenter:...

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

Zoho People: Reject an Application for Leave in Deluge based on Criteriahttps://www.joellipman.com/articles/crm/zoho/zoho-people-reject-an-application-for-leave-in-deluge.html

10 December 2020 "Field name 'ApprovalStatus' is invalid " }, "status": 1 } } [Warning: Another red herring ahead] We tried various other options such as adding a tickbox that would be used in an approval workflow but ran into issues when trying to update the record: {...

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

Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-mapping-a-multi-user-or-multi-lookup-field-using-deluge.html

28 April 2021 line 1: r_Record = zoho.crm.getRecords then press Enter (DO NOT START TYPING FOR A MODULE NAME - LET THE SYSTEM POPUP YOUR OPTIONS AS PER THE FOLLOWING SCREENSHOT - USE ARROW KEYS OR MOUSE): As you can see from the screenshot above, there are modules...

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

Zoho Creator: Add a subform while creating a recordhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-add-a-subform-while-creating-a-record.html

14 July 2021 will be prepopulated using the method above. Clear subform of all its rows: input..clear(); Changing the picklist/dropdown options in a subform row (applies overall rather than per row): clear ..; ..

• 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 going to call mine Shopify Webhook Payloads Drag some fields onto the form, this is what I did: Event Type [Drop Down: with options "Order Update", "Inventory Update", "Product Update"] JSON Payload [Multi Line] 2. Joel's first Cheat: If your client has...

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

Zoho CRM: Standard Setup for Tax Rateshttps://www.joellipman.com/articles/crm/zoho/zoho-crm-standard-tax-rate-setup.html

02 September 2021 module that has line items and use the product When you click on the edit icon in the line item "Tax" you will see both options available to be ticked, the same popup will appear if you click on the edit icon in the header "Tax" (applies to subtotal)....

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

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

19 October 2021 A quick article to take a list of options from a HTML select element and convert to a Zoho Deluge list that will eventually be used to populate a dropdown. Why? Because I find myself doing this quite a bit and wanted a quick way of extracting a SELECT...

• 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 v_Css + ""; input.Form_Css = v_Css; } But wait we're not finished as there are the chevrons / less-than greater-than signs options to program into. For this simply append the following: else if(input.Calendar_Day_Select == "<") { // // set selected...

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

Zoho CRM & Creator: Download attachment and upload to Creator file fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-creator-download-attachment-and-upload-to-creator-file-field.html

11 March 2022 that will be the name of the file including its extension) Document (the file upload field) Downloaded (a picklist with the options "Downloaded" and "Pending Upload") Here's the code for the parent form to download the attachments and upload them to the...

• 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 get to see the list of ebooks currently assigned to your Kindle account, all of which are shown under the Content Other options shown include Devices, Preferences, and Privacy Settings. Click on the Devices heading to show the Device Summary Under...

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

Zoho Creator: Populate a Multi-Lookuphttps://www.joellipman.com/articles/crm/zoho/zoho-creator-populate-a-multi-lookup.html

18 August 2022 would think it similar to a picklist/dropdown where you simply add an option to the picklist and then specify which of the options are selected. In this case, simply giving it the IDs should work... but it doesn't. Assuming my multi-lookup field is...

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

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

06 March 2023 GPT Chat) Modify the name field to be an Auto-Number (I'm prefixing mine with CHAT- Add a pick list called "Role" with the options: "user", "assistant", "system". Add a file upload field called "Big Data" Add a single line field called "Title" (used as...

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

Zoho Inventory: Enable Tracking using the APIhttps://www.joellipman.com/articles/crm/zoho/zoho-inventory-enable-tracking-using-the-api.html

04 May 2023 longer, is do ensure you have Zoho Inventory enabled. But to flesh that out a little more along with setting the other options under "Advanced Tracking" // // get chart of accounts to use r_ChartOfAccounts = invokeurl [ url...

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

Zoho Creator: Render to PDF with margins and page numbershttps://www.joellipman.com/articles/crm/zoho/zoho-creator-render-to-pdf-with-margins-and-page-numbers.html

07 May 2024 with rowspans and the borders need to merge cells). But here we're simply going to use ZohoCreator and its PDF rendering options. What's wrong with just using CSS? It looks beautiful on ZohoCreator pages but then you hit the PDF button and it pretty...

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

Zoho Analytics: Create a Monitoring System with Imageshttps://www.joellipman.com/articles/crm/zoho/zoho-analytics-create-a-monitoring-system-with-images.html

25 July 2024 elsewhere, then this step is completely optional. Click on "Create" and select "New Table / Import Data": One of the last options on the "Import Your Data" page is "Enter Data Right Away": You'll be presented with a table of about 10 columns called...

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

ZohoCRM to ZohoBooks API: Rounding the cents or pennies when creating an invoicehttps://www.joellipman.com/articles/crm/zoho/zohocrm-to-zohobooks-api-half-a-cent-or-penny-off-when-creating-an-invoice.html

20 March 2025 solution. I wanted to use a regex rather than treat the number as a string and truncate it that way. Given the possible options of numbers given, it has to work with every number so here's both in Zoho Deluge Tryout: v_Rate = 12345.545; info "Rate: " +...

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

ZohoCRM Client Script: On Change of Dropdown: Subform Rewrite: REST Functionhttps://www.joellipman.com/articles/crm/zoho/zohocrm-client-script-on-change-of-dropdown-subform-rewrite-rest-function.html

01 April 2025 when I forget how to do this. The use-case here is that we have a dropdown/picklist on a CRM invoice record that has the options of "Deposit" and "Final Balance". This rewrites the invoice line items to represent a deposit or a final balance invoice...

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