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

19 June 2023 to remove the block on changes to a system field in ZohoCRM. Why? Our use-case today is that a customer wanted to map the Postal Code or Zip from a Lead record to an opportunity (or Deal) record. If you are using custom fields, then just ensure that the...

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

Convert to Proper Case in T-SQLhttps://joellipman.com/articles/database/t-sql/convert-to-proper-case-in-t-sql.html

04 June 2014 Examples of usage: SELECT ufn_ProperCase([Surname]) FROM employees Additional: Note how the above doesn't convert postal codes, specifically British postcodes, which isn't included in the examples above because the function was only going to be applied...

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

Android: Replace return key with done, go, send...https://joellipman.com/articles/google/androidos/android-replace-return-key-with-done-go-send.html

03 November 2014 // No suggestions/autocorrect textEmailAddress // valid email address textPersonName // name of a person textPostalAddress // standard postal address textPassword // password type field textVisiblePassword // um... textPhonetic // text that will sound...

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

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

14 July 2021 Billing_Address.district_city=v_AddressCity Billing_Address.state_province=v_AddressCity Billing_Address.postal_Code=v_AddressZip Billing_Address.country=v_AddressCountry Line_Items=c_LineItems ]; From the documentation Additional Note that any...

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

ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.https://joellipman.com/articles/crm/zoho/zohocrm-to-zohobooks-please-ensure-that-the-shipping_address-has-less-than-100-characters.html

22 September 2021 { "address": "Test Street", "street2": "Test Street 2", "city": "Test City", "state": "Test State", "zip": "Test Postal Code", "country": "Test Country" } } However, if you try forcing the billing or shipping address in you should get the following...

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

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

25 January 2022 like: ${Organization.Organization Name} ${Organization.Street} ${Organization.City} ${Organization.Country} ${Organization.Postal Code} 11 My Street, My City, My State, My Zip, My Country They wanted to get rid of the "11 My Street, My City, My State,...

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