Search - Joel Lipman .Com

1. Zoho Creator: Button on Report for Merging Multiple Selected Records: / Zoho /; What? The aim of this article is to document how you can display a Creator report to the user, that they can select (tickbox) multiple records in that report, and then have a button that loops through ...; Created on 06 December 2020
2. Zoho Deluge: Push Multi-Select Picklist containing Commas from CRM to Creator: / Zoho /; What? A very quick article on how to push a multi-select picklist from CRM to Creator. Why? We're trying to create a record in Creator off a button on the CRM Potential/Deal record. The CRM module ...; Created on 20 April 2020
3. SELECT COUNT(DISTINCT name) FROM table: / Joomla /; ... statement. Why? The MySQL statement SELECT COUNT(DISTINCT name) FROM table is valid but I get what you mean and it's sometimes difficult to explain why you want to use it. How? Method #1: Add ...; Created on 24 September 2015
4. SSRS: Performance Improvements: SELECT TOP: / SQL Server Reporting Services /; ... solutions dotted about the web but the biggest improvement was the "SELECT TOP 100" brain wave: -- DataSet1: SELECT TOP 100 Reference, Forenames, Surname, DOB FROM PersonsTable WHERE (Reference ...; Created on 07 March 2014
5. Adding a selectable background to a Yootheme template: / Joomla /; ... do this so we'll need to modify the XML file and add some files that this will select. Modify \templates\\config.xml add the select option "Ambient Turquoise" to the end of the list: Grey Dots Tartan Lines Dark ...; Created on 19 November 2012
6. Select unique values in Microsoft Excel column: / Excel /; ... This returns the number of unique values in the range A3 to A1000 and excludes the blank/empty cells. Display all Unique Found this note on one of Microsoft Help sites: Office 2010: Select the ...; Created on 03 July 2012
7. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; What? This is a not-so-quick article that queries an eBay order and creates the relevant ZohoInventory item, contact, sales order, package slip, shipment order, invoice, payment records... Why? ...; Created on 27 April 2023
8. Zoho Deluge: Get All Orders from eBay: / Zoho /; ... select which fields to return l_OutputFields = List(); l_OutputFields.add("OrderID"); l_OutputFields.add("OrderStatus"); l_OutputFields.add("AmountPaid"); l_OutputFields.add("CreatedTime"); l_OutputFields.add("TotalNumberOfPages"); l_OutputFields.add("TotalNumberOfEntries"); m_Params.put("OutputSelector",l_OutputFields); // // ...; Created on 29 March 2023
9. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; ... form is called "Staff" and the subform is called "Usual Shift" containing the columns "Day", "Start Time", and "End Time": // // select applicable staff l_ApplicableStaff = Staff[ID != 0]; for eac ...; Created on 28 March 2023
10. ZohoAnalytics: Pivot Campaigns vs Contacts: / Zoho /; ... first query and save it as "Contacts vs Campaigns Pivot": SELECT * FROM ( SELECT "Contact Id", "Contact Name", "Campaign Name", "Member Status" FROM "Campaign Members - Contacts" ) ...; Created on 20 March 2023
11. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... Getting to the development-side Login to ZohoCRM as a super-admin Go to Setup (cog icon in the top right) Under Zia, select "Conversational AI" Click on the link "Zia Developer Console" (yours ...; Created on 06 March 2023
12. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... select which fields to return l_OutputFields = List(); l_OutputFields.add("ItemID"); l_OutputFields.add("Title"); l_OutputFields.add("SKU"); l_OutputFields.add("QuantityAvailable"); l_OutputFields.add("SellingStatus"); l_OutputFields.add("StartTime"); l_OutputFields.add("TotalNumberOfPages"); l_OutputFields.add("TotalNumberOfEntries"); m_Params.put("OutputSelector",l_OutputFields); // / ...; Created on 01 March 2023
13. 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
14. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo: / Zoho /; ... bot Login to ZohoCliq Click on your profile picture Select "Bots & Tools" Click on "Create Bot" (or "Edit Handlers" on an existing bot) Fill in the details then edit the Handlers. For demo purposes, ...; Created on 13 February 2023
15. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; ... type the deluge code), there will be a "Connections" in the top grey bar that you should click on and create a connection with the scopes that you want (I select nearly all of them), and I'm going to call ...; Created on 08 February 2023
16. ZohoCRM: Import Attachments: / Zoho /; ... to be sent to a compressed folder. the Import process Simply login to ZohoCRM > Go to Setup/Settings > Under Data Administration, select "Import" > Select Zoho CRM Now upload all the files neede ...; Created on 16 January 2023
17. Zoho CRM: Manage a subform using Client Script: / Zoho /; What? This is an article with a snippet of code demonstrating how to manage a subform using a Zoho CRM Client Script. Why? A client wanted an automation on-the-fly that when selecting a specific ...; Created on 09 December 2022
18. Zoho Analytics: Determine profits from invoices and purchase orders: / Zoho /; ... charges and other discrepancies. I'm calling this dataset "My Purchase Order Items" SELECT DISTINCT po."Purchase Order Date" AS "PO Date", po."Purchase Order Number" AS "PO Ref", poi."Produc ...; Created on 03 November 2022
19. Zoho Analytics: Set Up a Widget Displaying Sales Person: / Zoho /; ... I select on a dashboard. First you will need a table or query that has a bunch of columns and rows with one of the columns containing the sale person name. Something like the following: With ...; Created on 24 October 2022
20. ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM record: / Zoho /; ... admin account) Log in to https://accounts.zoho.com/developerconsole Click on Add Client ID Select "Self Client" Provide the details and register your application Upon successful authentication, ...; Created on 17 October 2022