Search - Joel Lipman .Com

1. 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
2. MySQL Group_concat equivalent in T-SQL and Oracle: / Databases /; ... version because I find myself needing to group concatenate more often from another table then using data from the same table. MySQL SELECT ( SELECT GROUP_CONCAT(column_to_return_as_string) ...; Created on 28 November 2011
3. Zoho Workdrive: Getting Team Folder ID: / Zoho /; What? This is an article to document how to get your team folder ID, retrieve information about it, and upload to it via the API. Why? The documentation is there but making sense of it, is somewhat ...; Created on 11 September 2024
4. Zoho Analytics: Create a Monitoring System with Images: / Zoho /; ... " to display the Maximum Date; then I want to "Group By" the image column, here labeled "Status Image": Then on the 2nd tab, I'm going to filter by my dataSource, which I've selected here to be my " ...; Created on 25 July 2024
5. Zoho Deluge: Proper Case for Names: / Zoho /; What? This is an open article without any completion in mind; to set the proper case of a name, as in capitalize the first letter, lower case the rest but then with exceptions. Why? Some of the ...; Created on 13 July 2023
6. Zoho Creator: Disable/Hide the add and delete subform row buttons: / Zoho /; ... Script, add the following: // // CSS overrides v_CssNotes = ""; // // this line hides the delete/cross icon next to each row v_CssNotes = v_CssNotes + ".subformRow .form-group"; // // this line ...; Created on 28 February 2023
7. Zoho Analytics: Determine profits from invoices and purchase orders: / Zoho /; ... of each item purchased; including shipping and tax. The second is to associate these to the invoiced items and work out the profit. The third is to group by the sales person, date, and customer so as ...; Created on 03 November 2022
8. Zoho Analytics: Set Up a Widget Displaying Sales Person: / Zoho /; ... these kind of columns available to you: Click on Widget in the top right Under "Data Column", select any field in your table/query which is not the one to display Under "Group By", select the field ...; Created on 24 October 2022
9. Zoho Creator: Change Radio into Tabs: / Zoho /; What? This is an article to serve as a guide in terms of styling a radio group into a group of Tabs. This is only a guide or reference which was applied for one client but would need adapting to match ...; Created on 22 October 2021
10. Zoho Deluge: Generate List of TimeZones: / Zoho /; ... US ones grouped at the top so let's remove the select and optgroup tags, escape any double-quotes, and prepend/append with a Zoho Deluge list declaration: l_TimeZoneOptions = List(); l_TimeZoneOptions.add("(GMT-10:00) ...; Created on 19 October 2021
11. Zoho CRM: Get Unique Values of a Text Field: / Zoho /; ... The advantage of working in a team of Zoho developers, is that "two heads are better than one" does apply more than we think. A colleague of mine suggested adding a group by to the query which works ...; Created on 08 October 2021
12. Zoho Creator: Two submit buttons on a non-stateless form with 2 different redirects: / Zoho /; ... for the next step: CSS styling): Apply the following styling (this will depend on the theme you are using): .zc-Save_and_Close-group .decision-box-field label{ display:none !important; } .zc-Save_and_Close-group ...; Created on 27 July 2021
13. Zoho CRM: Update a custom field in line items / product details using REST API v2.1: / Zoho /; ... added a column called "Group Name" in the CRM Quote module as per the following screenshot: How? Again at the time of this article, this is only modifiable when using REST API v2.1. We are going ...; Created on 17 May 2021
14. MySQL: Count occurrences of words in a column: / MySQL /; ... ) n WHERE n.n 5 AND TRIM(`value`) NOT IN ('Article','This',' ','content','component','applies','because','doesn''t') GROUP BY `value` ORDER BY `total` DESC LIMIT 0,50; Additional Note(s): I ...; Created on 12 March 2020
15. AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktops: / AutoHotkey /; ... PC and log back in, all the applications are grouped into the one desktop. If you have a multiple monitor setup (ie. more than 1 monitor), then MS Windows will almost remember which apps were open on ...; Created on 18 July 2019
16. Zoho CRM: APIv2 using PHP & cURL: / Zoho /; What? This is an article documenting how to access ZohoCRM with API v2 using PHP and cURL. The first few functions are to manage OAuth v2 and generate the refresh and access tokens. The second snippet ...; Created on 30 January 2019
17. MySQL Transactions in PHP: / MySQL /; Sometimes it is critical to ensure a group of queries are all executed successfully to maintain the integrity of our data. Let's say we have a banking app where we need to subtract funds from one account ...; Created on 14 December 2016
18. SELECT COUNT(DISTINCT name) FROM table: / Joomla /; ... Ones that didn't work for me: Method #3: By grouping (NOT recommended for more complex queries): SELECT COUNT(my_field) FROM my_table GROUP BY my_field; Additional: Not sure why method 3 ...; Created on 24 September 2015
19. Migrating from Joomla 2.5.x to 3.4.x: / Joomla /; ... on its contents or embedded code specific to the template. Copy over Users: Rename the Admin ID in the new v34 system to match your v25 system. Check your usergroups are the same in ...; Created on 12 September 2015
20. Joes Chart Generator (JCG) Downloads: / Downloads /; VersionPlatform ChangeLogOptions1.0 + Group all the data by a specified column + Generate interactive flash charts- Date Uploaded: Wed, 15th Sep 2010 Download; Created on 07 September 2015