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 Deluge: Generate List of TimeZones: / Zoho /; What? A quick article to take a list of options from a HTML select element and convert to a Zoho Deluge list that will eventually be used to populate a dropdown. Why? Because I find myself doing ...; Created on 19 October 2021
8. Zoho Creator / eBay: Get all Active Products: / Zoho /; ... exclude variations m_Params.put("HideVariations","true"); // // restrict what fields to return l_OutputFields = List(); l_OutputFields.add("BuyItNowPrice"); l_OutputFields.add("ItemID"); l_OutputFields.add("SKU"); l_OutputFields.add("StartTime"); l_OutputFields.add("TotalNumberOfPages"); l_OutputFields.add("TotalNumberOfEntries"); m_Params.put("OutputSelector",l_OutputFields); // // ...; Created on 13 October 2021
9. Zoho CRM: Get Unique Values of a Text Field: / Zoho /; ... query v_CoqlQuery = "select distinct Currency from Quotes where Subject!=''"; // // build up parameters m_Params = Map(); m_Params.put("select_query",v_CoqlQuery); // // invokeUrl r_Coql ...; Created on 08 October 2021
10. Zoho CRM: Standard Setup for Tax Rates: / Zoho /; ... have this selectable for users in their transactional modules (quotes, sales orders, invoices, purchase orders), you need to modify each product record (can be done with "Mass Update") to give them the ...; Created on 02 September 2021
11. Zoho CRM: Permission Denied for Quote Conversion Mapping: / Zoho /; ... Invoice module as well. Step by step fix: Login to ZohoCRM, go to Setup Under "Customization", select "Modules and Fields" Click on "Organize Modules" Enable "Invoices" (by ticking the box and ...; Created on 02 September 2021
12. Zoho CRM & Zoho Bookings Issue: Full Name appears in Last Name (first name first name last name): / Zoho /; ... pencil icon to edit this Alongside "Field Type", select "First Name, Last Name" Now your booking form will be similar to the following: And if the account is integrated with Zoho CRM, ...; Created on 01 September 2021
13. ZohoCRM: Process all records of a module: / Zoho /; ... by "Processed" is "Selected", check after each run of the function that the number has incremented. Once all records are done, return to the Module Layout and delete the "Processed" field. [Optional conditionally] ...; Created on 24 August 2021
14. Zoho CRM & Zoho Creator: Query returns some fields missing other data on the record: / Zoho /; ... you want to the detail view of the report you are accessing. The detailed resolution is: Create a duplicate of the report with the records you want Click on "Detail View" Click on "Layout" Select ...; Created on 26 July 2021
15. 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
16. 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
17. 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
18. 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
19. 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
20. 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