Search - Joel Lipman .Com

1. Zoho CRM: Template: Empty Space between Header and Line Items: / Zoho /; What? A very quick article on how to deal with an issue where a CRM template has been used and where the table of line items appears on a separate page (and to remind me of the CSS to fix this). Why? ...; Created on 03 February 2022
2. CSS Printing - Page Break Inside with Headers and Footers: / Cascading Stylesheets /; What? I saw a lot of articles that would cover this but I wanted an example which includes headers and footers and how to get an automatic page-break-inside to not overlap these. Fine on screen but ...; Created on 22 February 2019
3. 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
4. MS Excel - Sort pivottable column headings by date: / Excel /; What? This is a quick note to myself so that I never use parentheses in the column headings again. Basically I have a pivot table in Microsoft Excel 2010 with the projects down the left (in the first ...; Created on 12 April 2013
5. Mootools - How to contain a menu sidebar between header and footer: / MooTools Framework /; ... The complexity is due to content also being dynamically resized in height. What? Basically I have a menu in a sidebar, I don't want it to overlap the header nor the footer.I have a content page next ...; Created on 10 August 2012
6. SSRS Repeat Headers in PDF Report: / SQL Server Reporting Services /; The Problem I've set some tablix headers but when I request the same report in PDF format, the tablix headers only appear once on the first page. Every subsequent page simply displays the report header ...; Created on 26 October 2011
7. Crystal Reports: Exporting to Excel omits column headers: / Excel /; If you've been to the point where you're exporting a report to Excel, and only some of the column headers appear, then try this: I googled this for ages and found different suggestions ...; Created on 03 June 2010
8. Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Template: / Zoho /; ... to in this solution; namely the webhook response needs to have a header and a body. The 2nd caveat is a concern around security. It is difficult to guess a customer's Zoho ID; some might say almost ...; Created on 04 November 2024
9. Zoho Workdrive: Getting Team Folder ID: / Zoho /; ... that header has to be added otherwise you get a blank response: m_Header = Map(); m_Header.put("Accept","application/vnd.api+json"); v_Endpoint = "https://www.zohoapis.com/workdrive/api/v1/teamfolders//folders"; r_TeamFolderInfo ...; Created on 11 September 2024
10. Zoho Analytics: Create a Monitoring System with Images: / Zoho /; ... into an image. Even if this is filled with URLs for images stored on remote websites, it helps to preview the images. Right-click on the header of the 2nd column and select "Format Column": I changed ...; Created on 25 July 2024
11. Zoho Projects: Get All Events: / Zoho /; ... send to. Here's some code to get the last 50 events: // // *********************************** // get Zoho Projects information v_BaseURL = "https://projectsapi.zoho.com"; v_Heading = ""; // // ...; Created on 22 July 2024
12. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; ... your own here) v_ZA_WorkspaceID = "123456000000789012"; v_ZA_ViewID = "123467000009876543"; v_ZA_OrgID = "20240709007"; // // build up request to send m_Header = Map(); m_Header.put("ZANALYTICS-ORGID",v_ZA_OrgID); m_Params ...; Created on 09 July 2024
13. Zoho Analytics & Zoho People: Monitor DataSource Sync: / Zoho /; ... "Scheduler" header information such as the name, description, start date/time, frequency, and timezone. While you're here, click on "Connections" at the top of the IDE (where you paste the code) and ensure ...; Created on 02 July 2024
14. Zoho Books / Inventory: Get Item Rate from a Price Book/List: / Zoho /; What? A quick article on how to get the pricebook entry using Zoho Deluge for a specific product in your ZohoBooks or ZohoInventory instance. Why? This took me the best part of an hour to determine ...; Created on 23 May 2024
15. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; ... margin on render, I wrap the whole lot inside a DIV layer with the key attribute zcpage-spacing: ... ... ... The Quick Answer: the header This ...; Created on 07 May 2024
16. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... = zoho.encryption.hmacsha256(v_ClientSecret,v_Data,"base64"); // // retrieve Shopify's Hmac SHA256 from the header v_ShopifyHash = ""; if(m_Payload.get("headers") != null) { if(m_Payload.get("headers").get("x-shopify-hmac-sha256") ...; Created on 22 April 2024
17. ZohoCreator: Basic Widget with Zoho Data: / Zoho /; What? A follow on from my article Zoho Creator: Create a Widget which uses JavaScript back from 2020 with a few adjustments now in 2024. This widget will only work within Zoho Creator. If you want ...; Created on 14 March 2024
18. ZCRM Client Script: Correct Decimal Fields OnLoad: / Zoho /; ... The workaround for staff is to round this up manually and then save the record. But this can be an annoying overhead, especially if it can be auto-corrected with a client script. Pre-amble For ...; Created on 13 December 2023
19. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Report: / Zoho /; ... a data table in ZohoAnalytics to hold the attachments Create an Excel spreadsheet or CSV file with the headers: Ticket ID, Attachment ID, Image URL, Created Time, Modified Time Add a dummy row with ...; Created on 05 December 2023
20. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRM: / Zoho /; ... has the scopes as specified in the function header. Also note, that this Zoho instance is in the EU datacenter (zoho.eu) rather than the US datacenter. The most important tweak in order for the below ...; Created on 05 December 2023