Search - Joel Lipman .Com

1. Oracle SQL - Convert given list (CSV) into Rows: / Oracle PL/SQL /; Just a quick note as to something that worked for me. Taken from the Oracle forums @ https://forums.oracle.com/forums/thread.jspa?messageID=6861756 Situation I have one column of values that I've ...; Created on 30 August 2011
2. Joomla - How to preview module positions in a given template: / Joomla /; I was asked "... how do you find out where the positions are, like USER 1 and TAB 4 etc..." To open a web-browser window or tab with this preview, type the following in the address bar after ...; Created on 02 April 2010
3. ZohoCRM: Template: not being able to edit a text box: / Zoho /; ... template to enter a Preview Edit mode (not the pencil icon) Click on the clone icon (just below the pencil icon) Give it a new name, possibly the same name but with a suffix such as "Copy", "Clone" or ...; Created on 25 January 2022
4. Zoho Creator: eBay: Get Item Transaction: / Zoho /; What? This is the function to get the line item order/transaction from eBay if you give it the eBay Item ID as a parameter. Why? Mostly for debugging but here's the code that will quickly get the ...; Created on 22 January 2022
5. Zoho Analytics: Setup DataSource via FTP Connection: / Zoho /; ... Type FTP in the filter field in the top right and there should be a single FTP option displayed to you: Step 1 of 2: Give the datasource the table name it will have in Zoho Analytics, a description ...; Created on 12 January 2022
6. ZohoCRM & Xero Real-Time Invoices: Receive Webhook: / Zoho /; ... these into data for invoices and contacts. Category: Standalone Click on Create Give it the parameter: crmAPIRequest (string) Dump in the following code: // enter the webhooks key for your app ...; Created on 10 January 2022
7. Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng): / Zoho /; ... record; use Zoho's GeoCode function to convert this into a latitude and longitude, then we're going to use a free TimeZone API (one that returns a timezone given a lat/lng). The added feature is that we ...; Created on 15 December 2021
8. Zoho CRM: Schedule a Task: Timesheet Reminder: / Zoho /; ... Friday at 08:00 in the morning and will create a task if time logged is too low and will remind via Popup at about 4pm (16:00). You will need a connector (I've called mine joel_timesheet) and I've given ...; Created on 02 December 2021
9. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attach: / Zoho /; ... when locking it down for security: Login to ZohoCRM > Setup > Developer Space > Connections > Zoho OAuth Give your connection a name, I'm calling mine "Joels Connector" Select the Scopes: ZohoWriter.documentEditor.ALL ...; Created on 21 October 2021
10. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... Correction / Additional version 2.0 Playing around with this for a client, I found an even better solution! When creating or updating a product, you can instead of giving it Image URLs, give it the ...; Created on 17 October 2021
11. Zoho Creator / eBay: Get all Active Products: / Zoho /; ... a list of all the listed active products in a fixed price item listing. The example below is a function which, if given the page number and the number of entries per page, returns these in JSON as a Zoho ...; Created on 13 October 2021
12. Zoho Creator / Shopify: Get all Active Products: / Zoho /; ... delimited by a comma. However, to match my use-case, I want a list to which I can give it an SKU, and it returns the Shopify Product ID (not of the variant but of the product). In which case, I need ...; Created on 12 October 2021
13. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; ... Function" Give it a function name, I'm calling mine "fn_eBay_Webhook_OrderNotification" Give it a display name, I'll give it "eBay - Webhook - Order Notification" Set the Category to "Standalone" Se ...; Created on 20 September 2021
14. Zoho Creator: Prevent Endless Loops On User Input of a Field: / Zoho /; ... that any change was made. Instead, I need to add an additional field called "eTag_Title", check if the new MD5 is different, if it is then I proceed with the automations otherwise I stop it. // get given ...; Created on 19 September 2021
15. Zoho CRM: Standard Setup for Tax Rates: / Zoho /; ... have this selectable for users in their transactional modules (quotes, sales orders, invoices, purchase orders), you need to modify each product record (can be done with "Mass Update") to give them the ...; Created on 02 September 2021
16. Zoho Creator: Receive JSON via a Shopify Webhook: / Zoho /; ... give it a Connection Name, I'm going with joels_creator Give it a lowercase Connection Link name Select the scopes: ZohoCreator.form.CREATE and ZohoCreator.report.CREATE Click on Create and Connect ...; Created on 15 July 2021
17. Zoho Projects: Add a Time Log to an Issue using Deluge: / Zoho /; ... > Connections) Click on "Add Connection" and click on "Zoho OAuth" Give a lower connection name, eg. "joels_connector" Select the scope ZohoProjects.timesheets.ALL as a minimum (or CREATE/READ): ...; Created on 30 April 2021
18. Zoho Deluge: Sort a Map by a specific field: / Zoho /; ... Amazing 1997-07-05T23:15:00+00:00 46498 Joel 1977-11-14T12:30:00+00:00 8949 Anonymouse 1923-10-16T15:00:00+00:00 How? So to give you a gist of what the following snippet of ...; Created on 29 January 2021
19. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... can book longer than a month): // set criteria to search for clashing annual leave dates (pre/post 1 month check) l_SearchCriterias = List(); m_SearchCriteria = Map(); m_SearchCriteria.put("searchField","From"); m_SearchCriteria.put("searchOperator","After"); m_SearchCriteria.put("searchText",v_GivenDateFrom.subMonth(1).toString("dd-MMM-yyyy")); l_SearchCriterias.add(m_SearchCriteria); m_SearchCriteria ...; Created on 10 December 2020
20. Zoho Creator: Button on Report for Merging Multiple Selected Records: / Zoho /; ... Workflow > Functions > New Function: give the function a name select "Deluge" as the language give it a Namespace (for this example I will leave this on "Default") and set the return type (again in ...; Created on 06 December 2020