Search - Joel Lipman .Com

1. 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
2. Google Event Ilustrations aka Flairs: / Google /; ... basketball bbq: bbq, barbecue, barbeque beer: beer, beers, Oktoberfest, October Fest, Octoberfest billiard: billiard bookclub: book club, reading bowling: bowling breakfast: breakfast, breakfasts, ...; Created on 05 December 2024
3. Zoho Analytics & Zoho People: Monitor DataSource Sync: / Zoho /; ... = m_DataSource.get("lastDataSyncStatus"); m_DataSourceInfo = m_DataSource; break; } } } //info m_DataSourceInfo; // // to email or not to email, that is the question, whether 'tis nobler ...; Created on 02 July 2024
4. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; ... = c_Quote.Email; } v_QuoteDate = c_Quote.Modified_Time.toString("dd-MMM-yyyy"); c_AddedBy = Staff[Zoho_Creator_User == zoho.loginuser]; if(c_AddedBy.count() > 0) { v_AddedBy = c_AddedBy.Name; } break; } } %> /* ...; Created on 07 May 2024
5. ZohoCreator: Basic Widget with Zoho Data: / Zoho /; ... for(var index in recordArr){ v_GreetingName = recordArr[index].Nick_Name; break; } ...; Created on 14 March 2024
6. Zoho Books: Generate Bank Text File for Download: / Zoho /; ... == 0) { l_DocumentResponse = r_Attachment.get("documents"); for each r_Doc in l_DocumentResponse { v_DocumentID = r_Doc .get("document_id"); break; } // // open/download the file immediatel ...; Created on 02 October 2023
7. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 characters: / Zoho /; ... tried sync contacts from Account record for each r_Result in r_SearchResults.get("contacts") { if(!isnull(r_Result.get("contact_id"))) { v_BooksCustomerID = r_Result.get("contact_id").toLong(); break; } } } } if(v_BooksCustomerID ...; Created on 18 September 2023
8. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; What? This is a not-so-quick article that queries an eBay order and creates the relevant ZohoInventory item, contact, sales order, package slip, shipment order, invoice, payment records... Why? ...; Created on 27 April 2023
9. Zoho Deluge: Get All Orders from eBay: / Zoho /; What? Following on from my article: ZohoCRM: Get All eBay Active Listings, this is how to get all the orders from a client's eBay. Why? Our use-case is a data migration from eBay to a fresh instance ...; Created on 29 March 2023
10. ZohoCRM: Get All eBay Active Listings: / Zoho /; What? Another one of these articles talking about getting all the active product listings from eBay for a specific client. Why? Our use-case scenario here is that we want to get an inventory ...; Created on 01 March 2023
11. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo: / Zoho /; ... add the answer text to the response map m_Response.put("text",m_Choice.get("message").get("content")); break; } } } } else { // store in response text m_Response.put("text"," ...; Created on 13 February 2023
12. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... generator) which the bot can break down into "tokens" and then match with its training data to generate the image. Quick recap on how to first start using the MidJourney Bot Signup to Discord.com ...; Created on 11 February 2023
13. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; ... each r_Check in l_CheckExists.get("data") { if(!isnull(r_Check.get("id"))) { v_CountExists = v_CountExists + 1; break; } } } if(v_CountExists == 0) { // ...; Created on 08 February 2023
14. ZohoCRM: Import Attachments: / Zoho /; ... == v_OriginalFilePath) { v_ForeignKey := StrReplace(a_ColumnValues[1], """", "") v_FKCount := v_FKCount + 1 SB_SetText("Foreign Row #" v_FKCount, 2) break } } ; find ...; Created on 16 January 2023
15. Zoho Analytics: Determine profits from invoices and purchase orders: / Zoho /; ... missing associated purchase orders altogether. I had to break this down into several queries to generate the dataset, then use these as pseudo-subqueries. The first task was to determine the cost ...; Created on 03 November 2022
16. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; ... Cable (White) 1 £19.99 Build & Cost Breakdown Initial Build Total (functional PC, onboard GPU, 32Gb RAM, Previous O/S): £1,099.81 Second Part Build Total (GPU, RAM doubled, Windows 11 Pro, other): ...; Created on 12 March 2022
17. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile): / Zoho /; ... = r_User.get("profile").get("name"); break; } } } } // // get field value that we want to check for v_LeadStatus = ""; if(!isnull(m_Webhook.get("record"))) { // // extract lead status v_LeadStatus ...; Created on 11 February 2022
18. Zoho CRM: searchRecords with sorted results: / Zoho /; ... stop looping if less than 200 records on this page if(l_SearchResults.size() < 200) { break; } } Method #2: zoho.crm.getRecords() // ****************** CODE USING GETRECORDS **************** // ...; Created on 10 February 2022
19. Zoho CRM: Template: Empty Space between Header and Line Items: / Zoho /; ... > Select the template with this issue Click on the "Edit HTML" icon in the top right of the editor: Find the code "page-break-inside" Change this from "avoid" to "auto": And optionally, ...; Created on 03 February 2022
20. Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng): / Zoho /; ... = r_TimeZone.get("display_value"); break; } } } } } } // // if not blank then we found the correct timezone picklist option if(v_CustomerTimeZone != "") { m_UpdateLead.put("Customer_s_Timezone",v_CustomerTimeZone); } // // ...; Created on 15 December 2021