Search - Joel Lipman .Com

1. Zoho CRM / Deluge: Send an email with a CRM Quote using a given CRM template: / Zoho /; ... get the quote details given a record ID r_QuoteDetails = zoho.crm.getRecordById("Quotes",p_QuoteID); // // check target email is not null/blank if(!isnull(r_QuoteDetails.get("Email"))) { v_Url ...; Created on 18 August 2022
2. 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
3. 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
4. ZohoCRM: Import Attachments: / Zoho /; ... then include in the upload "Contacts_001.csv") The mandatory field 'Attachment Id' must be mapped: Give a unique value for the column attachment ID (filename column does not need to be unique) and ensure ...; Created on 16 January 2023
5. Zoho Books/Inventory: Trigger a workflow when an invoice has been paid: / Zoho /; ... and payment date to appear on the invoice. How? This sounds rather straightforward, write a function that given an invoice, checks the customer payments and updates the custom fields. Executing ...; Created on 17 August 2022
6. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... the scope(s) ZohoInventory.items.READ (add some more if you're unsure...) Give it a connection name and note down the connection link name. I'm calling mine joel_zoho Authorize it, etc. Make a ...; Created on 31 March 2022
7. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; ... of mine (see my pinterest) to build a nicer looking computer and I was given £1000 towards a new computer... It's more than enough to get a running White Snow Edition PC but I put in some more to get the ...; Created on 12 March 2022
8. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... get the information from Shopify and your scripts found further below in this article): Give it a Connection Name (eg. "Shopify API Oauth") Enter the Shop ID (eg. "example-store.myshopify.com") Give ...; Created on 14 February 2022
9. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile): / Zoho /; ... layout didn't work Choose field to validate > Select "Lead Status" Choose validation type as "Validate using function" and click on "Next" For functions, select "Write your own" Give it a function name, ...; Created on 11 February 2022
10. 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
11. 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
12. 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
13. 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
14. 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
15. 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
16. Zoho Deluge: Today, Tomorrow, Day After but Skip Sunday: / Zoho /; ... dates given a number of days So here's another scenario where you have a start date and you are asked to list the working days, 7 days after the start date. I'm aware of the method .workdaysList(): date1='2022-07-21'; date2='2022-07-29'; info ...; Created on 02 November 2021
17. 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
18. 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
19. 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
20. 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