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. 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
8. 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
9. 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
10. 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
11. 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
12. 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
13. 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
14. 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
15. 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
16. ZohoCRM & Xero Real-Time Invoices: Receive Webhook: / Zoho /; ... return return ; Save this and return to the list of functions Hover over the function you just created, click on the 3 dots/ellipsis and select "REST API" Switch on the API Key and copy the URL ...; Created on 10 January 2022
17. Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng): / Zoho /; ... are going to loop through picklist options (500 timezones) in CRM to select the most relevant one. If all this fails, then it defaults to a module called "States" which stores a default timezone and can ...; Created on 15 December 2021
18. Zoho Creator/Deluge: Calculating with Timezone Offset: / Zoho /; ... + input.Agent_Date_Time_Start.toString("EEEE, MMMM dd, yyyy @ h:mma") + " " + v_AgentTimeZoneName + " "); v_ResultInformation = v_ResultInformation.concat(""); input.Note_BookedTimeSelection = v_ResultInformation; ...; Created on 07 December 2021
19. Zoho CRM: Schedule a Task: Timesheet Reminder: / Zoho /; ... "select Start_DateTime, End_DateTime from Events where Created_By='" + v_UserID + "' and ("; v_CoqlQuery = v_CoqlQuery + "Start_DateTime>='" + v_FirstDateOfWeek + "T00:00:00+00:00' and "; v_CoqlQuery ...; Created on 02 December 2021
20. Zoho Creator/Deluge: UnPredictable exception, Invalid statement found: / Zoho /; ... select a bunch of creator records (ok all of them) l_AllRecords = myForm[ ID != 0 ]; // // loop through these for each r_Record in l_AllRecords { // set an if condition if(r_Record.Type ...; Created on 17 November 2021