Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines)https://www.joellipman.com/articles/crm/zoho/zoho-deluge-handle-commas-between-quotes-in-a-csv.html

26 August 2021 v_DataCSV = "1,Joel Lipman,Kings Castle,England\n"; v_DataCSV = v_DataCSV + "11,General Dogsbody,\"Flat 8, House Corner, My Street\",Brummieland\n"; v_DataCSV = v_DataCSV + "64,Elephant Man,\"123 New Street,\nNew York City\",USA\n"; f_CSVfile =...

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

ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 charactershttps://www.joellipman.com/articles/crm/zoho/zohobooks-code-15-ensure-billing-address-has-less-than-100-characters.html

18 September 2023 // // initialize v_BooksOrgID = 123456789; v_BooksCustomerID = 0; m_CreateEstimate = Map(); l_CrmBillingAddress = {"Billing_Street","Billing_Street_2","Billing_City","Billing_State","Billing_Code","Billing_Country"}; l_CrmShippingAddress =...

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

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

22 September 2021 "discount": 0, "quantity": 1, "description": "A test product description" } ], "shipping_address": { "address": "Test Street", "street2": "Test Street 2", "city": "Test City", "state": "Test State", "zip": "Test Postal Code", "country": "Test Country" }...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• 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 address and couldn't change the template. So they had something like: ${Organization.Organization Name} ${Organization.Street} ${Organization.City} ${Organization.Country} ${Organization.Postal Code} 11 My Street, My City, My State, My Zip, My Country...

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

Zoho CRM: Permission Denied for Quote Conversion Mappinghttps://www.joellipman.com/articles/crm/zoho/zoho-crm-permission-denied-for-quote-conversion-mapping.html

02 September 2021 a super admin in CRM, I am denied permission to access the Quote Conversion Mapping page... Why? I wanted to map a billing street 2 and shipping street 2 from the Account module to the Quote module, then on convert, to map these to the Sales Order in...

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

Zoho Books: Display Sales Order Shipping Address on Package Sliphttps://www.joellipman.com/articles/crm/zoho/zoho-books-display-sales-order-shipping-address-on-package-slip.html

07 October 2021 my Sales Order: BILLING ADDRESS SHIPPING ADDRESS ------------------- ------------------- Test Company Joels PO Box 1 Test Street 1 Different Street Test City Another City Test State Test Zip Another State Another PostCode Test Country A different...

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

Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng)https://www.joellipman.com/articles/crm/zoho/zoho-crm-deluge-get-timezone-based-on-geocoded-address-lat-lng.html

15 December 2021 v_CustomerTimeZone = ""; // // build up address from Lead to geocode l_LeadAddress = List(); if(!isnull(r_LeadDetails.get("Street"))) { l_LeadAddress.add(r_LeadDetails.get("Street")); } if(!isnull(r_LeadDetails.get("City"))) {...

• 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 the header This repeats the header on every page. The key here is the HTML attribute zcpage-headerhtml: My Company Ltd Test Street, Test County TEST1 ZIP1 +44 (0)1234 567890 sales@mycompany.com QUOTE The Quick Answer: the footer This repeats the footer...

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

Forum Ruleshttps://www.joellipman.com/static-items/forum-rules.html

31 May 2009 not allowed to create more than one thread per topic. No Posting Personal Info - You may not post your last name, or your street address on TEU. This is because this information then becomes accessible to anyone. No Threatening to Leave the Board - Due...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• 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 v_ContactSname = r_ContactDetails.get("Last_Name"); v_AddressLine1 = r_ContactDetails.get("Street"); v_AddressCity = r_ContactDetails.get("City"); v_AddressState = r_ContactDetails.get("State"); v_AddressZip = r_ContactDetails.get("Zip");...

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

Joel's Reference to MidJourney v4 Promptshttps://www.joellipman.com/graphic-design/joel-s-guide-to-midjourney-prompts.html

11 February 2023 Documentary Photography Event Photography Fashion Photography Pet Photography Portrait Photography Sports Photography Street Photography Travel Photography Wedding Photography Manmade Objects Architecture Fine Art Photography Food Photography Product...

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *

Google Event Ilustrations aka Flairshttps://www.joellipman.com/articles/google/google-event-ilustrations-aka-flairs.html

05 December 2024 plan week, plan quarter, plan day, plan vacation, week planning, vacation planning pride: dyke march, christopher street day, gay parade, gay pride, gayglers, gaygler, lesbian march, lesbian parade, lesbian pride, euro pride, europride, world pride,...

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