Search - Joel Lipman .Com

1. 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
2. ZohoCreator: Using .toFile and Uploading to a Creator field: / Zoho /; What? This is a quick article on generating a file with the Zoho Deluge function .toFile() and uploading it to a file upload field within Zoho Creator. Why? The use-case here is that we want a ...; Created on 25 March 2024
3. Zoho Creator: Sendmail a list of attachments: / Zoho /; ... to me that perhaps this isn't clearly documented. But there are tips found across the web just not specifically addressing this. How? Here is the code for a test function which downloads 2 files ...; Created on 20 July 2023
4. Zoho CRM: Change System Field Length: / Zoho /; ... file to change system field labels The fix put simply is a CSS hack. Specifically by inspecting the element, removing some of the CSS attributes on the field we want to change, saving it, then returning ...; Created on 19 June 2023
5. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... Publish it by going to Settings > Publish > Publish Component > and select the REPORT (eg. "Inventory Photo Report"). Note the embed code, specifically the long alphanumeric string. Create a ...; Created on 31 March 2022
6. Zoho Creator: Radio group into Calendar Carousel: / Zoho /; ... the value of each radio item will be populated using deluge and what's important to note here is that each picklist/dropdown option includes some HTML, specifically a SPAN tag surrounding the date number ...; Created on 09 March 2022
7. Zoho CRM: Template: Empty Space between Header and Line Items: / Zoho /; ... By default / out-of-the-box / vanilla, in a Zoho CRM Template, the table of line items will behave like this; specifically when there are a lot of line items as per my screenshot here: How? ...; Created on 03 February 2022
8. Zoho CRM: Get Unique Values of a Text Field: / Zoho /; ... up a SQL query, or more specifically, a COQL - CRM Object Query Language Try using distinct on a single-line text field Adapt the query for unique values in a lookup field I won't demonstrate ...; Created on 08 October 2021
9. Zoho Books: Display Sales Order Shipping Address on Package Slip: / Zoho /; ... same as the billing address... Or more specifically, the primary contact, company, address and phone from the customer record and not from the sales order change. How? The key is a setting you need ...; Created on 07 October 2021
10. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; ... have an access token, we will check what notifications already exist (if any), and then we will create a function that subscribes the application so that any order is sent to a URL, specifically a CRM ...; Created on 20 September 2021
11. Zoho Deluge: Sort a Map by a specific field: / Zoho /; What? This is a quick article to template some code to me on sorting a map variable in Zoho Deluge, specifically Zoho Creator. Why? I do this a lot but in the following example, I want to sort ...; Created on 29 January 2021
12. Zoho Creator: info/alert/modal/popup notification for any user: / Zoho /; ... base URL such as https://creatorapp.zoho.com/myowner/myapp/#Page:Notify. CSS styling affects all contents: Any styling on an embedded form on the popup would need to apply specifically to the contents ...; Created on 06 November 2020
13. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; ... HTML,CSS and JS). Files referring to Creator specifically: ./app/widget.html: reference to script src at https://js.zohostatic.com/creator/widgets/version/1.0/widgetsdk-min-js ./app/custom.js: my ...; Created on 24 October 2020
14. Zoho Deluge: Setup an API Connection for InvokeURL: / Zoho /; ... details how to setup a connection to use in an invoke URL statement. Specifically for Zoho Books, Subscriptions or Inventory. Why? Setting up a connection avoids the hassle of having to generate ...; Created on 12 August 2020
15. Pure JS - Display Time Elapsed & Remaining: / JavaScript /; ... specifically displays the time remaining on an access_token which is generated from an OAuth 2.0 process. I want to display to the user how much time is left before another access token will be generated ...; Created on 30 October 2018
16. Protecting your Joomla Administrator Section: / Joomla /; ... affect the standard visitors to your Joomla website (specifically those not interested in logging into the administrator section). Updated for Joomla 3.x but pretty much the same system as used for previous ...; Created on 23 October 2015
17. Quadcopter App with Flight Restrictions (JQA): / Product Documentation /; ... multicopters or more specifically their owners and use. Far from what the governments do with their drones, here are some socially beneficial applications I found: Search & Rescue: Earthquake: Drone ...; Created on 24 October 2014
18. Convert to Proper Case in T-SQL: / Transact-SQL /; ... Examples of usage: SELECT ufn_ProperCase([Surname]) FROM employees Additional: Note how the above doesn't convert postal codes, specifically British postcodes, which isn't included in ...; Created on 04 June 2014
19. MS Excel: Convert a text to a number: / Excel /; ... to a number using Microsoft Excel 2010. Since when did MS Excel stop understanding what a NUMBER was? I have a column full of currency values which I want to convert, specifically Philippine pesos ...; Created on 15 November 2013
20. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCase: / SQL Server Integration Services /; ... and ", "la", "le", " van ", " de ", " of " and similar should remain lowercase. How? The SSIS Script component task has to be generic, it should only apply this to columns we specifically tick i ...; Created on 04 October 2013