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: 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
8. 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
9. Zoho Analytics: Set Up 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
10. 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
11. Zoho CRM / Deluge: Send an email with a CRM Quote using a given CRM template: / Zoho /; ... on the ellipsis or three horizontal dots button in the top right and selecting "Send Mail" then selecting which inventory template to use... This is too many steps for some. Instead, we've been asked to ...; Created on 18 August 2022
12. Zoho Creator: Populate a Multi-Lookup: / Zoho /; ... you simply add an option to the picklist and then specify which of the options are selected. In this case, simply giving it the IDs should work... but it doesn't. Assuming my multi-lookup field is ...; Created on 18 August 2022
13. Zoho Books/Inventory: Trigger a workflow when an invoice has been paid: / Zoho /; ... you or may be already working for you without this issue. By changing the workflow to execute not "When any field is upddated" but "When any selected field is updated" and then selecting the fields "Status", ...; Created on 17 August 2022
14. ZohoCRM: ZDK Client Script to retrieve Contact Email: / Zoho /; What? An article on one of my first client scripts for ZohoCRM. This retrieves and populates an email field based on when a contact is selected in a lookup field. Why? I could do a normal automation/workflow ...; Created on 20 July 2022
15. Amazon Kindle: Send PDFs to your Kindle: / Kindle /; ... down and select the Personal Document Settings Scroll down again and select the Approved Personal Document E-mail List. This is the list containing the email address that the Kindle will recognize. You ...; Created on 29 June 2022
16. GoDaddy Apache cPanel: Install SSL Certificate: / cPanel /; ... for Select the Server Type and then click on "Download Zip File" button Decompress the ZIP and find the CRT file Return to your GoDaddy page and scroll down to "Web Hosting" then click ...; Created on 07 April 2022
17. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... Step-by-step Add Zoho Creator to your Zoho One Login to Zoho One Go to Settings (cog in top right) Click on Applications i the sidebar Click on the Add Application button Select Creator by clicking ...; Created on 31 March 2022
18. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; ... > Right-click on it, enable it and select "Update Driver" Either via the device manager or just from pure frustration, you should get a prompt to download the Intel Graphics Command Center app from the ...; Created on 12 March 2022
19. Zoho Creator: Radio group into Calendar Carousel: / Zoho /; What? Another article on styling a radio group to become a weekly calendar carousel. In that a radio group displays the days of the week with arrows allowing the user to select the next or previous ...; Created on 09 March 2022
20. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... will all be done by the sales team via Shopify. So I select the following: (see: Shopify API Access scopes for more info on each): read_analytics,write_customers,read_customers,write_inventory,read_inventory,write_order_edits,read_order_edits,write_orders,read_orders,write_product_listings,read_product_listings,write_products,read_products,write_reports,read_reports ...; Created on 14 February 2022