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: Populate a Multi-Lookup: / Zoho /; ... the line items from a package slip taken from Zoho Inventory. I'd prefer if it was included in the list view or a Zoho Creator report. How? We would think it similar to a picklist/dropdown where ...; Created on 18 August 2022
4. Zoho Books/Inventory: Trigger a workflow when an invoice has been paid: / Zoho /; ... the function this worked as expected. Now put it on a workflow where the settings were: When an invoice is "Created or Edited" Execute the workflow when "When any field is updated" Filter the triggers ...; Created on 17 August 2022
5. Amazon Kindle: Send PDFs to your Kindle: / Kindle /; ... option Account and Lists which should show somewhere along the top right of the home screen. Under Account and Lists, look for Your devices and content > Manage Devices. You will get to see the list ...; Created on 29 June 2022
6. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... it and click on the ellipsis/3 dots Select the REST API Enable REST API Note the REST API function and you can now call it from wherever. Done Additional Caveat(s) This currently does ...; Created on 31 March 2022
7. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; ... on the O11 Dynamic Mini and air flow isn't perfectly balanced. I'd opt for the O11 Air Mini (newer one) where fans can be mounted to the front and it supports an ATX Power supply. I bought 9 Coolmoon ...; Created on 12 March 2022
8. Zoho Creator: Radio group into Calendar Carousel: / Zoho /; ... app without building a JS Widget or using Nodejs... Or we can make do with the tools provided. The brief was similar to the Zoho Bookings interface where their Creator app is to present the user with ...; Created on 09 March 2022
9. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... the Location of your product variant (where "1234567890" is the location ID) to get the recent 10 products updated today: { productVariants( first: 10 reverse: true query: "updated_at:>'2022-02-14T00:00:00+0000'" ...; Created on 14 February 2022
10. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeros: / Zoho /; ... are zeros... But I'm keen on avoiding using loops where possible so we don't breach a statement execution limit in the Zoho app function. How? If we're not going to use loops, then the next best thing ...; Created on 08 February 2022
11. Zoho CRM: Template: Empty Space between Header and Line Items: / Zoho /; What? A very quick article on how to deal with an issue where a CRM template has been used and where the table of line items appears on a separate page (and to remind me of the CSS to fix this). Why? ...; Created on 03 February 2022
12. Zoho Deluge: a HTML Entity Decoder: / Zoho /; ... replacements m_HtmlEntity = Map(); m_HtmlEntity.put("&","&"); m_HtmlEntity.put(" "," "); // // loop through each of the above replacing where found for each v_HtmlKey in m_HtmlEntity.keys() { v_StringToDecode ...; Created on 27 January 2022
13. Zoho Deluge: Text (SMS) reminder using Twilio API (LocalSense): / Zoho /; What? A very quick article to remind me how to send a text message using Twilio API in Zoho Deluge. Why? The use-case here is that we want local sense dialing where specific numbers are used both ...; Created on 16 December 2021
14. 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
15. Zoho Creator/Deluge: UnPredictable exception, Invalid statement found: / Zoho /; ... The Solution/Cause So quite simply, I'm using 2 for each loops and this is one of those scenarios where you need to store the loops into different variable names: // select a bunch of creator records ...; Created on 17 November 2021
16. Zoho Deluge: Today, Tomorrow, Day After but Skip Sunday: / Zoho /; ... dates given a number of days So here's another scenario where you have a start date and you are asked to list the working days, 7 days after the start date. I'm aware of the method .workdaysList(): date1='2022-07-21'; date2='2022-07-29'; info ...; Created on 02 November 2021
17. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attach: / Zoho /; What? An article to save time where a customer wants to click a button to generate a merged document in Writer and attach it to the CRM record. Why? Our use-case is that we have a client who has ...; Created on 21 October 2021
18. 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
19. 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
20. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; ... Auth'n'auth (Authentication and Authorization) Process Not getting notification via the URL but you are getting them via email? Well I read somewhere you need to use Auth'n'auth to enable these notifications ...; Created on 20 September 2021