Search - Joel Lipman .Com

1. The greatest invention in IT: / IT Support /; Not a useful note and more of a personal opinion then factual, but beyond the inventors of the Internet or any hardware has to be the following notion from IBM: a 1976 research report by Lance A. ...; Created on 13 September 2012
2. Zoho Analytics: Create a Monitoring System with Images: / Zoho /; ... in column 2: In the textarea / multi-line box, and to the right of it, I click on the "ZohoAnalytics Image URL" value to copy it into the textbox: Great! Now the next step makes the value ...; Created on 25 July 2024
3. Zoho Projects: Get All Events: / Zoho /; ... The above is great on a test system where you don't have many events, but what if this the system has far more than 50 events, past or upcoming? Here's the code to get a single event record by its record ...; Created on 22 July 2024
4. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; ... could be the same under price total. Where a price is applied, values should be retained in decimal format with currency symbol prefixed if value is greater than zero. Source(s): To convert Page ...; Created on 07 May 2024
5. ZohoCRM: Using Criteria with Module Record Count: / Zoho /; ... + ")AND(Valid_Till:greater_than:" + encodeUrl("2023-11-01") + "))"; v_Endpoint = "https://www.zohoapis.com/crm/v5/Quotes/actions/count?criteria=" + v_CountCriteria; r_MaximumCount = invokeurl [ ur ...; Created on 14 November 2023
6. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 characters: / Zoho /; ... ---------------------- QUOTE LINE ITEMS ---------------------- // line items get via api v2.1 or greater l_BooksLineItems = List(); r_CrmProductLineItems = invokeurl [ url :"https://www.zohoapis.eu/crm/v2.1/Quotes/ ...; Created on 18 September 2023
7. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; ... c_Employee in l_ApplicableStaff { info c_Employee.Name; // // reset the stuff they already have in their subform "Usual Shift" c_Employee.Usual_Shift.clear(); // // great now let' ...; Created on 28 March 2023
8. ZohoBooks: Stripe Terminal Integration: / Zoho /; ... (Joel Lipman) - If custom field "Amount To Be Taken" is not greater than zero, then defaults to balance due of invoice. More Information: TEST PAYMENT SCENARIOS WITH PHYSICAL TEST ...; Created on 16 March 2023
9. ZohoDeluge: Inserting a new line character in a CSV: / Zoho /; ... given some lists and strings and although the same code worked great on one Zoho CRM, another client's ZohoCRM was not accepting "\n" as a new line character and instead would render/display it as "\n"... ...; Created on 01 March 2023
10. Zoho CRM: Manage a subform using Client Script: / Zoho /; ... } } // set the value of No_Skills_Listed field ZDK.Page.getForm().setValues(); // if not 3 or greater then alert the user and prevent the save if (v_CalculatedNumberOfSkills < 3 && v_OppStage ...; Created on 09 December 2022
11. Zoho Creator: Embed Forms/Reports on a Page: / Zoho /; ... tag which isn't great for CSS styling as you can't do cross-dom acoss child iframes; but it does let you use OpenURL(v_Url, "iframe", "iframe_name") which is good if you have multiple iframes on a page and ...; Created on 05 May 2022
12. Zoho Creator: Radio group into Calendar Carousel: / Zoho /; ... to make the chevrons (less than and greater than sign) massive: div.zc-Calendar_Day_Select .choice-table-cell span label[elname='radioEl_zc-Calendar_Day_Select_1'] div.zc-Calendar_Day_Select .choice-table-cell ...; Created on 09 March 2022
13. Zoho Creator: Change Radio into Tabs: / Zoho /; ... v_Css + "div[name='Note_Title']"; v_Css = v_Css + ""; input.Note_CSS = v_Css; Functionality Great! And to add some functionality, in other words, have tabs show/hide when a radio option is clicked ...; Created on 22 October 2021
14. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; ... send the request XML as a string r_ResponseXML = invokeurl [ url :v_Endpoint type :POST parameters:x_Params headers:m_Headers ]; info r_ResponseXML; } } Great! Now ...; Created on 20 September 2021
15. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; ... for my colleagues. The below instructions follow a fresh install as if this is the first time this computer has created a Zoho Creator Widget. Software used: Zoho Creator v5 (Plan Premium or greater ...; Created on 24 October 2020
16. Zoho Deluge: Convert Map to URL Parameters: / Zoho /; What? A quick article on converting a Map (associative array with keys and values) into a URL string to pass as URL parameters. How? Let's first define a map: m_Payload = Map(); m_Payload.put("client_id","my-unique-client-id"); m_Payload.put("redirect_uri","https://www.joellipman.com"); m_Payload.put("response_type","code"); m_Payload.put("scope","my_api_scopes"); m_Payload.put("prompt","login"); Great! ...; Created on 09 March 2020
17. Convert Past Date to Time Ago in PHP: / Personal Home Page /; What? Just a quick note to refine a function that will take a date in the past and return the number of years, months, weeks, days, hours, minutes and seconds. Why? Here are some examples of what ...; Created on 16 May 2019
18. MS Excel - Split Workbook into separate files per sheet: / Excel /; ... size of about 11Mb. In order for an import process to work, the import would only accept XLS files no greater than 1Mb. So our script has to split a single spreadsheet into multiple worksheets of 3000 ...; Created on 11 February 2019
19. Add attribute xsl:nil=true on empty elements using XSLT: / XML Stylesheet Language Transformations /; ... things to do really: Add the xmlns:xsi namespace in the xsl:stylesheet tag so that "xsi:nil=true" is valid. Test for a string length of greater than 0 (not blank) and change the attribute of the element ...; Created on 18 August 2014
20. XML Schema Reference: / Extensible Markup Language /; ... for Datatypes Constraint Description enumeration Defines a list of acceptable values fractionDigits Specifies the maximum number of decimal places allowed. Must be equal to or greater ...; Created on 13 August 2014