Search - Joel Lipman .Com

1. Include a carriage return in a column heading: / SQL Server /; Applies To: MS SQL Server 2008 R2 MS Windows 7 Enterprise (Client) MS Excel 2010 What? A really quick note on how to insert a carriage return or new line into the column name/alias (the header). ...; Created on 07 July 2014
2. Zoho Creator: Input Color Picker: / Zoho /; ... v_CssStyle = v_CssStyle + ""; input.Note_ColorPicker_Css = v_CssStyle; Step 4: Popup and Dismiss Color Picker To do this, we add one more option on the radio options which includes a button. ...; Created on 14 October 2024
3. Zoho Workdrive: Getting Team Folder ID: / Zoho /; ... Getting the team folder information Use the team_folder_ID or if it is a subfolder, then use the team_subfolder_id Ensure the scope for your connection includes WorkDrive.teamfolders.READ and note ...; Created on 11 September 2024
4. Zoho Analytics: Create a Monitoring System with Images: / Zoho /; ... now I can go back to my query and expand on it a little to include the other datasources (CRM Tables): SELECT 'CRM Accounts' AS "DataSource", date(t1."ModifiedTime") AS "Date", t1."RecordID" ...; Created on 25 July 2024
5. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Lead: / Zoho /; ... contact. $se_module (String): The API name of the parent module that the contact is associated with. This key is mandatory when you include Who_id and What_Id. FREQ (String): Defines the frequency ...; Created on 14 May 2024
6. Zoho Deluge and Wordpress/WooCommerce API: Get All Products: / Zoho /; ... How? So first, this article shows you how to setup an API connection, and then we'll include the code to count the total number of products, and then finallly show the code to loop through all the ...; Created on 15 April 2024
7. ZohoCreator: Using .toFile and Uploading to a Creator field: / Zoho /; ... file to be hosted within Zoho Creator for use by a JS widget that will download the CSV (in this case a Text *.txt) file for use by a dynamic auto-suggester dropdown; one of those fancy ones that includes ...; Created on 25 March 2024
8. ZohoCreator: Basic Widget with Zoho Data: / Zoho /; ... receive and pass to the JS widget. the HTML You may note that I have additional CSS and JS files. I like to keep the copies local (especially if the hosting is included) so the app doesn't suddenly ...; Created on 14 March 2024
9. Zoho Books: Error 7008: There are no contact persons associated with this Invoice: / Zoho /; ... need to mark as sent as sending via the above will automatically do that in ZohoBooks. } } } Additional You can include a parameter in the request when creating an invoice which is sent = ...; Created on 07 March 2024
10. Zoho Creator: Get Images in Report to be Exported to PDF: / Zoho /; What? This is an article to document how to produce a report which when exported to PDF will display images without a user wall. Why? Our client needs to send a report to suppliers that include ...; Created on 26 January 2024
11. ZCRM Client Script: Correct Decimal Fields OnLoad: / Zoho /; ... Type is "Page Event" Event is "onLoad" Click "Next" Method 1 This includes a function which counts the number of decimals. I didn't need to use this method for my client; just rounding the decimals ...; Created on 13 December 2023
12. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRM: / Zoho /; ... a rather rich HTML email signature with a profile photo included. When sending an email from CRM, they want CRM to include this rich signature (different per user) at the bottom of the email message. ...; Created on 05 December 2023
13. ZohoCRM: Using Criteria with Module Record Count: / Zoho /; ... API v2.1: I have a connection in ZohoCRM with the required scopes: ZohoSearch.securesearch.READ AND ZohoCRM.modules.quotes.READ, Include ZohoCRM.settings.layouts.READ or ZohoCRM.settings.ALL as well; ...; Created on 14 November 2023
14. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 characters: / Zoho /; What? Another article on something I learned today despite never running into this issue before; but sending a billing/shipping address included in a request to create or update an estimate in ZohoBooks ...; Created on 18 September 2023
15. Zoho Deluge: Get the Week Number if Week starts on a Monday: / Zoho /; ... but in the United Kingdom, the week generally starts on a Monday. So let's say there's a schedule that has to be run weekly and include all the orders of a specific week... Just to confuse everyone ...; Created on 06 July 2023
16. Zoho Inventory: Enable Tracking using the API: / Zoho /; ... key here to enable inventory tracking m_CreateBooksItem.put("item_type","inventory"); // // other less important values to include re purchase information m_CreateBooksItem.put("product_type","goods"); m_CreateBooksItem.put("reorder_level",0); m_CreateBooksItem.put("available_stock",v_QuantityAvailable.toLong()); m_CreateBooksItem.put("initial_stock",v_Quantity.toLong()); m_CreateBooksItem.put("initial_stock_rate",v_ItemPrice.toDecimal()); m_CreateBooksItem.put("inventory_account_id",m_Accounts.get("Inventor ...; Created on 04 May 2023
17. Zoho: Email Deliverability / SPF / DKIM / DMARC / Toolkit: / Zoho /; ... Authentication, click on "Validate Records" Note the DKIM and SPF values as well as the subdomain value: DKIM Subdomain: 1522905495316._domainkey. DKIM Value: k=rsa; p= SPF Value: v=spf1 include:one.zoho.eu ...; Created on 04 May 2023
18. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... StaticAlias) - Resolved fix of inventory adjustment level (Error:9205:Insufficient Stock) - Resolved fix of overpaid amount (Include Shipping Cost in SO) Date Modified: 2023-03-16 (Joel ...; Created on 27 April 2023
19. ZohoDeluge: Check Shipment Status via DHL API: / Zoho /; ... and then I'll include the code to query the shipment status based on a tracking number. Becoming a DHL Developer Browse to https://developer.dhl.com/user/register to Signup Complete the form with ...; Created on 21 March 2023
20. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... build params m_Params = Map(); m_Params.put("WarningLevel","High"); m_Params.put("ErrorLanguage","en_GB"); m_Params.put("DetailLevel","ReturnAll"); // // specify only the active list m_ActiveList = Map(); m_ActiveList.put("Include",true); m_ActiveList.put("ListingType","FixedPriceItem"); m_ActiveList.put("Sort","ItemID"); // // ...; Created on 01 March 2023