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: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... usage: // somewhere in the beginning l_ShopifyPictures = List(); v_ListingPublishKey = "AAAAABBBBBCCCCDDDDEEEFFFGGGGHHHIIIJJJKKLLLMMMNNOOOPPPQQWRRRSSTTUUVVWWXXYYZZ122345567890"; if(!isnull(input.Main_Photo)) { v_Filenam ...; Created on 17 October 2021
4. Zoho CRM: Get Unique Values of a Text Field: / Zoho /; What? This article demonstrates how to return a list of unique values in a particular field in a CRM module. Why? My use-case is a data-migration where the records exist in a staging module in ...; Created on 08 October 2021
5. Zoho Creator: Prevent Endless Loops On User Input of a Field: / Zoho /; ... and from a developers understanding: field1 is told to update field2 when field1 is changed. When field2 is changed, it is told to update field1. This causes a recursive or endless loop where each field ...; Created on 19 September 2021
6. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines): / Zoho /; ... might want to consider that not all new lines/line breaks/carriage returns are at the end of a line.... for example, maybe your CSV contains multi-line fields; eg. where address street is on a different ...; Created on 26 August 2021
7. ZohoCRM: Process all records of a module: / Zoho /; ... been checked. Some solutions have worked in the past where you could simply add a checkbox and do a search where this value is false; but lately this hasn't been working for me. To this end, I have ...; Created on 24 August 2021
8. 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
9. 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
10. 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
11. 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
12. 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
13. 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
14. 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
15. 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
16. 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
17. 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
18. 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
19. 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
20. 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