Search - Joel Lipman .Com

1. Calculating Percentage: / eCommerce Systems /; I need to often be reminded of how to calculate a percentage. The context here is that I want a progress bar in one of my programs. To determine what percent a number is of a total number: (Progress ...; Created on 20 May 2010
2. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; ... (Display amount and then percentage beneath in smaller) Line Item Totals have been added to the above code retrospectively without proper testing. Aggregate of total amount may be unnecessary as this ...; Created on 07 May 2024
3. Zoho Books: System Values Maps: / Zoho /; ... + v_BooksOrgID type :GET connection:"zbooks" ]; for each m_Tax in r_Taxes.get("taxes") { m_Taxes.put(m_Tax.get("tax_percentage").toString(),m_Tax.get("tax_id")); } info m_Taxes; // // --------------------------------- // ...; Created on 07 November 2023
4. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 characters: / Zoho /; ... each r_Tax in r_Taxes.get("taxes") { m_Taxes.put(r_Tax.get("tax_percentage").toString(),r_Tax.get("tax_id")); } // // ---------------------- DETERMINE ZOHOBOOKS CUSTOMER ID ---------------------- if(!isnull(r_QuoteDetails.get("Account_Name"))) { v_AccountID ...; Created on 18 September 2023
5. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... each r_Tax in r_Taxes.get("taxes") { m_Taxes.put(r_Tax.get("tax_percentage").toString(),r_Tax.get("tax_id")); } } l_DebugMessages.add("ZB Taxes: " + m_Taxes); // // set chart of accounts to use v_Endpoint ...; Created on 27 April 2023
6. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; What? An article on how I can query all the orders for yesterday without using the eBay GUI Selling website. I've included the code to parse out the information as well. Why? Because I need this ...; Created on 28 February 2023
7. ZohoCRM: Import Attachments: / Zoho /; ... "," v_Col10 "," v_LogProcessNote "`r`n" FileAppend, %v_CsvLine%, %v_RunFolder%\Log.csv } LV_ModifyCol() LV_ModifyCol(5, 0) LV_ModifyCol(6, 0) v_ForeignKeyPercent := Round((v_FKCountTotal / ...; Created on 16 January 2023
8. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attach: / Zoho /; What? An article to save time where a customer wants to click a button to generate a merged document in Writer and attach it to the CRM record. Why? Our use-case is that we have a client who has ...; Created on 21 October 2021
9. Zoho CRM & Zoho Books: Get Books Currency and Tax IDs: / Zoho /; ... GET connection: "joel_books" ]; for each r_Tax in r_Taxes.get("taxes") { m_Taxes.put(r_Tax.get("tax_percentage").toString(), r_Tax.get("tax_id")); } info m_Taxes; // // set Tax ID for a sales order ...; Created on 24 September 2021
10. Zoho Projects: Deluge to Submit Custom Fields: / Zoho /; ... "duration_type": "hrs", "start_date": "11-12-2021", "end_date": "12-12-2021", "percent_complete": "0", "order_sequence": "4", "priority": "None", "custom_fields": m_Custom.toString() }; r_CreateResponse ...; Created on 17 June 2021
11. Zoho CRM: Update a custom field in line items / product details using REST API v2.1: / Zoho /; ... = List(); m_TaxOption1 = Map(); m_TaxOption1.put("percentage",20); m_TaxOption1.put("name","Sales Tax"); m_TaxOption1.put("value",v_LineItemTax); l_TaxOptions.add(m_TaxOption1); m_LineItem.put("line_tax",l_TaxOptions); } m_LineItem.put("total",5.94); m_LineItem.put("product_description","M ...; Created on 17 May 2021
12. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... the process would be: allow a user to apply for leave, then on save/submit, auto approve/reject the application based on a custom function that could calculate the percentage of staff who already booked ...; Created on 10 December 2020
13. Zoho Deluge: Adding / Removing Total Tax from a Quote Record: / Zoho /; ... ,2)); // // build up tax options l_TaxOptions = List(); m_TaxOption1 = Map(); m_TaxOption1.put("percentage",20); m_TaxOption1.put("name","VAT"); m_TaxOption1.put("value",v_TotalTax); l_TaxOptions.add(m_TaxOption1); m_TaxOption2 ...; Created on 20 August 2019
14. A for loop within a for loop in MS-DOS: / MS-DOS /; ... trust these more than my all-in-one GUI applications. How? Note: we're using the code in a DOS Batch program so our variables have to be prefixed with a double-percent rather than just the one: -- ...; Created on 03 October 2013
15. htaccess Rewrites SEF URL and submits to PHP: / Personal Home Page /; ... you don't use in your site structure. Slashes and underscores /_ are good (so regexp: /[^a-zA-Z0-9_\/]/). If you allow percents (%) or apostrophes (*) then you are asking for trouble. Note my redirect ...; Created on 05 September 2013
16. AwStats Data Parser (ADP): / Product Documentation /; So it's the end of the month again and I have to prepare a report for some investors. The idea of an infographic report has excited them to no end but because the end of the month didn't wait for me to ...; Created on 03 April 2013
17. Error 1065: Query was Empty: / MySQL /; ... been escaped. In all my cases this has been the percent sign (%) but I'm listing what needs to be escaped in SQL for future use: Character Description \0 An ASCII NUL (0x00) character. ...; Created on 13 December 2012
18. CSS Background Without Causing Scrollbars: / Cascading Stylesheets /; ... CSS overflow auto hidden etc. all to no avail. What I didn't want when I resize the web browser, a scrollbar! What worked for me: Specify the DIV layer width to be 100 percent of the page. Position ...; Created on 23 April 2011
19. SSRS Use T-SQL Like with a Parameter: / SQL Server Reporting Services /; ... roombookings rb WHERE rb.[GivenDate] BETWEEN @GivenDate AND @ToDate AND rb.[ContactName] LIKE '%'+@GivenName+'%' --WORKS! Enclose percent signs as strings. For anyone that thinks there ...; Created on 04 April 2011
20. URL passed settings in Reporting Services: / SQL Server Reporting Services /; ... configuration (defaults to 100%) http:///ReportServer/Pages/ReportViewer.aspx?%2fMYREPORTS%2fDemos%2fRB+Report+for+Me&rs:Command=Render &rc:Zoom=100% Note: Where 100% can be page width in percent or ...; Created on 11 February 2011