Search - Joel Lipman .Com

1. Joomla WHERE clause with OR: / Joomla /; What? A quick article on how to use the where clause in a joomla database query. Why? In response to a member, I use the old form where I can include the whole SQL statement: $db->query('SELECT ...; Created on 16 July 2014
2. Getting the mysql where in delimited string to work: / MySQL /; What? I have a mySQL database table of room assets that has a field containing the ID numbers of images relevant to this room. The Problem? When I select specifying the statement "WHERE IN (c.RoomImages)", ...; Created on 02 January 2012
3. Zoho Creator: Add a subform while creating a record: / Zoho /; ... a quote record and include a subform containing the line items. You may have tried code where you add a record first and then add the subform afterwards (insert into [...]) but it can be done all in one ...; Created on 14 July 2021
4. Zoho Projects: Deluge to Submit Custom Fields: / Zoho /; What? A super quick article to demonstrate an example where we create a project with custom fields. Why? At time of print, the documentation on the Projects API would only show responses rather ...; Created on 17 June 2021
5. Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments: / Zoho /; What? This is an article to demo some Deluge code on how to download a file that was uploaded in CRM in a custom module in field that was of type "File Upload". Why? Just to remind me where I went ...; Created on 02 February 2021
6. Zoho Creator: Button on Report for Merging Multiple Selected Records: / Zoho /; ... all the selected (ticked) records. The example below documents a report of Quotes where we want to merge all the product line items of each quote into one single quote. Why? I've written this ...; Created on 06 December 2020
7. Zoho Creator: Set Up Custom Domain for Customer Portal: / Zoho /; ... or domain registrar (website where you registered your domain). I've listed some third-party providers' instructions on how to set up a CNAME record at the bottom of this page. A subdomain is FREE as ...; Created on 17 November 2020
8. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; ... time of print (2020-10-24), Zoho Creator does not allow you to use JavaScript anywhere in its app. HTML and CSS are mostly allowed but JavaScript automatically gets removed from any of your code. How? ...; Created on 24 October 2020
9. Zoho Creator Page: Toggle On/Off Switch: Hide/Display a Div: / Zoho /; ... own version of Bootstrap and jQuery. This is the first example I have where you would want dynamic content in a Zoho Creator page without the use of JavaScript or 'Widgets JS'. How? Here are some ...; Created on 22 October 2020
10. Zoho Deluge: Search Records with Special Characters (COQL): / Zoho /; ... Records via API I won't go into detail on how to set up your own connection as I have elsewhere on my website, but to use in an invokeUrl here's a quick overview: ZohoCRM > Setup > Developer Space > Connections ...; Created on 28 August 2020
11. Windows 10: Shortcut Apps to Settings: / Windows OS /; ... User Accounts Provisioning ms-settings:workplace-provisioning ms-settings:provisioning Windows Anywhere ms-settings:windowsanywhere Source(s): Microsoft - Launch the Windows Settings ...; Created on 30 July 2020
12. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Books: / Zoho /; ... This works in the scenario where you have disabled the transaction modules in CRM (so Sales Orders, Invoices, Purchase Orders) and integrated your Zoho CRM with your Zoho Books. Why? Because then Zoho ...; Created on 15 May 2020
13. 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
14. Zoho CRM/Creator - Common Errors & Gotchas: / Zoho /; ... 37: The HTTP method PUT is not allowed for the requested resource This was an issue where I was trying to push a Zoho Creator record into Zoho Inventory via an invokeURL with API v2 rather than a connector. ...; Created on 06 February 2020
15. Zoho Deluge: Adding / Removing Total Tax from a Quote Record: / Zoho /; ... if you want this to be zero, you need to pass the option of tax as zero and remove all other options. Take the following code for example, this will add 20% tax to the overall Tax on this record (where ...; Created on 20 August 2019
16. AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktops: / AutoHotkey /; ... system, you will know of a feature where you can have another virtual desktop on your device. For those that don't know it, the feature is similar to mobile phones where you swipe left/right to reveal ...; Created on 18 July 2019
17. Zoho Deluge - Get Refresh/Access Token API v2: / Zoho /; ... v_Url; openUrl( v_Url , "new window"); This will open a page for you with a Zoho Consent form where you confirm whether your app is allowed to access the data within the specified scope(s). If you ...; Created on 17 July 2019
18. Zoho Deluge - Get distance between two coordinates: / Zoho /; ... as the crow flies. Update 2020 Not sure exactly when but Zoho have made available this function in Creator: = zoho.map.distanceBetween(, , ); // where unit can be "MILE", "KILOMETRE" or "NAUTICAL" ...; Created on 11 June 2019
19. Zoho Deluge - Some Useful Regular Expressions: / Zoho /; ... yields hello-world-123 Email safe string: v_MyString = "somewhere[]@beyondthesea_1.com"; v_MyFormattedString = v_MyString.toLowerCase().trim(); v_MyFormattedString = v_MyFormattedString.replaceAll("[^a-z0-9@\-.]+",""); // ...; Created on 31 May 2019
20. CSS Add Text to Breadcrumb Link with a Transition: / Cascading Stylesheets /; What? This is an article I hope to refine one day where given a set of breadcrumb hyperlinks, when I hover the mouse over the links, the text changes and the transition between the two is controlled ...; Created on 18 May 2019