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

17 November 2020 level and equal number of steps as verifying by CNAME; or by uploading a HTML verify file which I tend to forget to delete afterwards and involves just as many steps to instruct the client. I use CNAME as I find it easier and it is a step we need for...

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

Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attachhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-writer-button-to-merge-template,-send,-and-attach.html

21 October 2021 and ensure that none of the fields have a slightly transparent red background (if they do, then add the field again and delete the one highlighted in red - alternatively give it a unique name in the record). Then map the fields using the dot syntax, add...

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

Reminder on SSRS row separatorhttps://www.joellipman.com/articles/microsoft/ssrs/reminder-on-ssrs-row-seperator.html

26 October 2011 a grouping icon Now select the column that has just been created (usually "Group1") by clicking the grey part above it Delete this column. Check that the grouping grey part (a giant parenthesis) is still there. Right-click on the grey header of the...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Modifying columns in a tablehttps://www.joellipman.com/articles/database/modifying-columns-in-a-table.html

24 July 2013 column to an existing table (giving it datatype char(2) and allowing NULL) ALTER TABLE myTable ADD myColumn CHAR(2) NULL -- Delete a column ALTER TABLE myTable DROP COLUMN myColumn -- Reorder a column ALTER TABLE myTable MODIFY COLUMN misplacedColumn...

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

ZohoCRM: Template: not being able to edit a text boxhttps://www.joellipman.com/articles/crm/zoho/zohocrm-template-not-being-able-to-edit-a-text-box.html

25 January 2022 Street, My City, My State, My Zip, My Country" but when editing the template, they couldn't put the cursor in there or even delete the box the address was in. How? So you're going to say this is a strange issue and an even stranger fix, but I've tested...

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

Zoho CRM: searchRecords with sorted resultshttps://www.joellipman.com/articles/crm/zoho/zoho-crm-searchrecords-with-sorted-results.html

10 February 2022 v_PerPage = 200; // // get other products with the same name (set in order of oldest first and keep only first one, delete the others) m_Params = {"select_query":"select id, Product_Name from Products where Product_Name = '" + v_SearchName + "' order by...

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

Zoho Inventory & eBay Picture Services: UploadSiteHostedPictureshttps://www.joellipman.com/articles/crm/zoho/zoho-inventory-ebay-picture-services-uploadsitehostedpictures.html

31 March 2022 > Schedules > New Workflow Set the Start date and time to tomorrow's date at 2:00am Run Daily Name the workflow Daily Delete Record Click on Create Workflow Give it the following code: for each r_ApplicableRecord in Inventory_Photo[Added_Time Developer...

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

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

16 January 2023 0 v_FilesToProcessCount := 0 v_FKCountTotal := 0 v_PKCountTotal := 0 GuiControlGet, v_FolderToSearch, , MySelectedFolder LV_Delete() ; create directory and log file FileCreateDir, %v_RunFolder% v_CsvLine := StrReplace(v_ListViewHeaders,"|", ",")...

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

ZohoCRM Webhook: Create ZohoInventory Records from an eBay orderhttps://www.joellipman.com/articles/crm/zoho/zohocrm-webhook-create-zohoinventory-records-from-an-ebay-order.html

27 April 2023 2023-03-29 (Joel Lipman) - If an eBay order comes through as cancelled, then void the sales order, void the invoice, delete the package and shipment. - Added chart of accounts lookup to set purchase account for an item: now ticks purchase information...

• 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 CREATE RESPONSE FOR " + v_ItemID; info r_CreateItem.get("message"); Error(s) Encountered items with opening stock cannot be deleted, set the opening stock to zero: Guess who's going to have their opening stock set to zero, save the record, then delete...

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

Zoho CRM: Change System Field Lengthhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-change-system-field-length.html

19 June 2023 the DIV the field is in and double-click on the INPUT element (specifically the disabled="disabled" attribute), then press delete/backspace to remove the attribute. Also remove the class names "disableEditProp" and "eventNone". You should get the...

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