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 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
8. Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Deluge: / Zoho /; ... to another, sometimes you need to manage existing multi-lookups/users in a record. How? So the key point to remember is that all multi-select lookup and multi-user lookup fields are held in temporary ...; Created on 28 April 2021
9. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... Customization > Forms > Leave Under "Form Properties" > Tick the box under "Validation" for "Custom Validation" to create a function: Ensure you select parameters to input rather than retrieving ...; Created on 10 December 2020
10. Zoho Creator: Set Up Custom Domain for Customer Portal: / Zoho /; ... app and go to the "Settings" tab, then on "Customer Portal" then on the "Settings" button in the top right: Under Portal URL, select "Custom Domain" and in the field below, enter the full domain (incl. ...; Created on 17 November 2020
11. Zoho Creator: info/alert/modal/popup notification for any user: / Zoho /; ... on the action using values from the form invoking it but for generic messages you could get the "Notify" page to read from a form/report: Click on the plus icon to create a new form Select a blank form, ...; Created on 06 November 2020
12. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; ... zet init You will be given a list of Zoho services, use the arrow up/down keys to select “Zoho Creator” and press the return/enter key. Give the project a name: eg. “joels_awesome_app” (without ...; Created on 24 October 2020
13. Zoho Creator Page: Toggle On/Off Switch: Hide/Display a Div: / Zoho /; ... to preserve functionality: /* On Off Switch CSS */ .onoffswitch { position: relative; width: 100%; -webkit-user-select:none; -moz-user-select:none; ...; Created on 22 October 2020
14. Zoho Deluge: Search Records with Special Characters (COQL): / Zoho /; ... Click on Get Started / Add New Connection Click on the "Zoho OAuth" icon Enter a Connection name (for this example I will call it "CRM API v2") Select the appropriate scope(s): ZohoCRM.coql.READ ...; Created on 28 August 2020
15. Zoho Deluge: Setup an API Connection for InvokeURL: / Zoho /; ... and select "Server-based Applications" by clicking on "Create Now" on the appropriate box. If this is not your first app, just select "Server-based Applications", then on the plus icon to add new client. ...; Created on 12 August 2020
16. Windows 10: Shortcut Apps to Settings: / Windows OS /; ... a perfectly ok post on the Microsoft website? Well I could bookmark that page or save myself a click... How? To test any of the following, type the windows key and select "Run..." ( + R). Then ...; Created on 30 July 2020
17. Zoho Deluge: Get Image Uploaded in Creator Form: / Zoho /; ... #1: Display and access without login So the quickest is to have a form that has an image upload field. Create an entry with one image. Then... Go to Settings Publish Publish Component > Select ...; Created on 14 July 2020
18. AutoHotkey: App GUI Listview to Rename Files: / AutoHotkey /; ... a grooved border ; 0x200 aligns horizontal to left and vertically centered (0x201: center center, 0x202: right center) Gui, Add, Text, w350 h28 x120 y11 -Multi vSelectedDir gBrowseFolders 0x1000 +0x200, ...; Created on 08 July 2020
19. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Books: / Zoho /; ... > New Workflow Select your form Run when Created or Edited When to trigger: User input of a field Choose Field: ZohoBooks Sales Order Ref Name it whatever: eg. OnUserInput_ZBSoRef Put the following ...; Created on 15 May 2020
20. Joomla: Remove IDs from URLs for out-of-the-box SEF: / Joomla /; ... Search Engine Friendly URLs Use URL Rewriting Add Suffix to URL (optional) Unicode Aliases (optional - for international languages) Select the "Integration" tab Change the “URL Routing” option ...; Created on 14 March 2020