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. 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
8. 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
9. 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
10. 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
11. 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
12. 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
13. 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
14. 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
15. 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
16. 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
17. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile): / Zoho /; What? So this is a pretty cool feature in Zoho CRM that I hadn't used much but definitely worth an article. The ability to block field picklist options from being selected based on the profile of a user. ...; Created on 11 February 2022
18. Zoho CRM: Template: Empty Space between Header and Line Items: / Zoho /; ... > Select the template with this issue Click on the "Edit HTML" icon in the top right of the editor: Find the code "page-break-inside" Change this from "avoid" to "auto": And optionally, ...; Created on 03 February 2022
19. ZohoCRM: Template: not being able to edit a text box: / Zoho /; ... "2" (or your own company initials just to show the customer who's boss). Now click on the pencil icon of the cloned template Right-click on the text box causing the issue and select "Inspect" (if you ...; Created on 25 January 2022
20. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; What? This is an article documenting how to parse the notification from eBay and using it to create an order in Shopify. Why? Previously, we would receive an eBay notification and create an ...; Created on 21 January 2022