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 Books: Estimates/Quotes: Accept & Decline Buttons on Template: / Zoho /; ... basic HTML/CSS knowledge): Place the cursor where you want the button and give it some text, I'm going to start with Accept Quote Then click on the link icon and give it the link noted from the UR ...; Created on 04 November 2024
4. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... and send it off for signing, then return the Signed document attached to the initial record (where the button was). Why? If anyone has the envious task of sending a document out for signing by a ...; Created on 06 August 2024
5. Zoho Deluge: Determine your Statement Execution Limit: / Zoho /; ... So create a function in the Zoho App you are checking, or somewhere you can write some Zoho Deluge code. Note that requesting an increase of the limit or an upgrade to the subscription will likely ...; Created on 31 July 2024
6. Zoho Analytics: Create a Monitoring System with Images: / Zoho /; ... here where I demonstrate how to upload photos to be hosted by the Zoho Analytics app. Uploading the images to be hosted by Zoho Analytics So first steps are login to Zoho Analytics and go into the ...; Created on 25 July 2024
7. Zoho Projects: Get All Events: / Zoho /; ... The above is great on a test system where you don't have many events, but what if this the system has far more than 50 events, past or upcoming? Here's the code to get a single event record by its record ...; Created on 22 July 2024
8. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; ... a client who uses their purchase orders and sales orders as part of a logistics solution where items are purchased from a supplier, sent to another supplier for grading, and then sent on to the end user/customer. ...; Created on 09 July 2024
9. Zoho Analytics & Zoho People: Monitor DataSource Sync: / Zoho /; ... "Scheduler" header information such as the name, description, start date/time, frequency, and timezone. While you're here, click on "Connections" at the top of the IDE (where you paste the code) and ensure ...; Created on 02 July 2024
10. Zoho Books / Inventory: Get Item Rate from a Price Book/List: / Zoho /; ... do some further calculations based on a surcharge rate held in a custom module. The custom module could only be created in Zoho Books at time of print but Zoho Inventory is where our workflow and code ...; Created on 23 May 2024
11. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Lead: / Zoho /; ... create task: Create a workflow that runs on lead create (record action) and the criteria can be where "Lead Conversion Time" is less than 4 (4 days not 4 business days?). Though I've removed this condition ...; Created on 14 May 2024
12. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; ... could be the same under price total. Where a price is applied, values should be retained in decimal format with currency symbol prefixed if value is greater than zero. Source(s): To convert Page ...; Created on 07 May 2024
13. Zoho Deluge and Wordpress/WooCommerce API: Get All Products: / Zoho /; ... can be "Read". Click on the "Generate API Key" button Note the consumer_key and consumer_secret somewhere (these aren't displayed to you in future - so this is your one chance, or else you need to generate ...; Created on 15 April 2024
14. Zoho Creator: Get Images in Report to be Exported to PDF: / Zoho /; ... + v_PublishKey + "?filepath=/" + v_DocFileName; // // Store the link to the local file as the local image - this is where we could check on file extension and substitute with PDF, DOC, XLS ...; Created on 26 January 2024
15. Zoho Books: System Values Maps: / Zoho /; ... statements, I can feed these maps a textual value and it returns the ID to use. Some of these can be found elsewhere in my site but I'm putting all of them here just for quick reference. How? Note ...; Created on 07 November 2023
16. Zoho Books: Generate Bank Text File for Download: / Zoho /; ... Why is this a challenge? The file contains bank details and should not be stored anywhere. Generating a text or CSV file and then having it emailed to anyone is an easy task but here we cannot have ...; Created on 02 October 2023
17. Zoho Deluge: Determine if Daylight Savings are in effect: / Zoho /; ... about 4 months until I can confirm this works. Why? I've covered this before in a fair few articles on this website but for clients in the US, where there could be 4 different timezones between customer, ...; Created on 03 July 2023
18. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... multi-line field called "Content" and change the properties on creation to allow 32000 characters. Keep the email field called "Email" Return to the Context Handler Function IDE (page where you ente ...; Created on 06 March 2023
19. ZohoDeluge: Inserting a new line character in a CSV: / Zoho /; ... sometimes works but sometimes yields: // Me,Myself,I\na,b,c Works on systems where the above doesn't work: l_CsvFileRows = List(); l_CsvFileRows.add("Me,Myself,I"); l_CsvFileRows.add("a,b,c"); // v_CSVFilename ...; Created on 01 March 2023
20. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo: / Zoho /; ... and respond with the responses I programmed it to answer with. Any variations of the questions it did not understand, it would return a response similar to Siri or Ask Google where it includes the keywords ...; Created on 13 February 2023