Search - Joel Lipman .Com

1. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; ... PDF renderer in ZohoCreator and want all the data to stay aligned. Using only DIV layers can cause a few unexpected layouts in ZohoCreator. The Quick Answer: the page margins Tackling the page ...; Created on 07 May 2024
2. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... as these might answer your question to begin with and then we'll do the easy bit on how you set this up in the CRM. I'm using ZohoCRM here despite storing the record in ZohoCreator as the app and data processing ...; Created on 22 April 2024
3. Zoho Creator: Error Code 2945: EXTRA KEY FOUND IN JSON: / Zoho /; ... quick answer is to build a nested map in your request instead of using the Creator/JavaScript period/dot character... Some might suggest it's an authorization error but if you do a getRecordById and ...; Created on 04 October 2023
4. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 characters: / Zoho /; ... however gives me the following error: { "code": 15, "message": "Please ensure that the billing_address has less than 100 characters." } How? So the quick answer is 2 separate API calls after ...; Created on 18 September 2023
5. Zoho Finance Suite Schedule: PATTERN NOT MATCHED: / Zoho /; ... Unless you can monitor when these type of schedules are failing, you won't see this error until you go in and try to save it again. How? The super quick answer is remove any spaces from the name ...; Created on 12 June 2023
6. Zoho Inventory: Enable Tracking using the API: / Zoho /; ... for anything else than tracking stock...? How? So the quick answer is one missing parameter to send through which is "item_type=inventory"... A little longer, is do ensure you have Zoho Inventory ...; Created on 04 May 2023
7. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... will have the specific OrgID in the URL). Click on "Add Action" Give it the Action Name "Ask ChatGPT" This action should "Answer a Question" It should be answered by "Construct Answer by Fetching Data" ...; Created on 06 March 2023
8. 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
9. Zoho Creator: Prevent Endless Loops On User Input of a Field: / Zoho /; ... eTag field for each field that you want to monitor changes. The answer is no, you only need one. You can have 1 eTag which combines all input fields into 1 MD5 or hash. Do you need to add a comparing ...; Created on 19 September 2021
10. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines): / Zoho /; ... to parse the data in the appropriate columns was not working as expected. How? The quick answer is a regex that will replace any commas between two quotes with a custom string, to be exact: v_FormattedData ...; Created on 26 August 2021
11. ZohoCRM: zoho.crm.searchRecords only returns certain records: / Zoho /; ... a custom related list on a Zoho Finance > Sales Orders module but it wasn't finding all the Quotes related to this Sales Order. How? The quick answer is buried in Zoho documentation and due to the ...; Created on 29 July 2021
12. Zoho CRM & Zoho Creator: Query returns some fields missing other data on the record: / Zoho /; ... all pretty much useless to me. Well the "for some reason" turned out to be because my detail view on the report was displaying a report/document template. How? The quick answer is: Add the fields ...; Created on 26 July 2021
13. Minimal Privileges for MySQL Database Backup Cron Job: / cPanel /; What A quick note as I had difficulty finding a clear answer on this. I need a cron job setup where the permissions for a database user is required to do a backup (reading and copying data from a LIVE ...; Created on 20 March 2019
14. Make bootstrap carousel responsive to swipe: / Bootstrap /; ... think it should be voted best answer) put forward by Mark Shiraldi: The code is minimal but does what it needs to do (tested on iOS) and doesn't appear to effect other javascripts. Put this in a ...; Created on 14 December 2016
15. SELECT COUNT(DISTINCT name) FROM table: / Joomla /; ... is an accepted answer over the web because as soon as I put a WHERE clause in the statements and check the numbers, only method 1 and 2 return the correct number. I'm still unsure as to why WHERE...GROUP ...; Created on 24 September 2015
16. MessageBox or AlertDialog in Android Java: / AndroidOS /; ... }) .show(); Additional: Pre-populating default value and returning input Lots of confusing answers out there on the web but here's an all-in-one where I Open an AlertDialog designed ...; Created on 20 October 2014
17. Batch Process to rename multiple files using Windows DOS: / MS-DOS /; ... So you can do this quickly on a friend's PC and it's a bit geeky. Type the following NOTEPAD rename.bat and answer Yes to if you want to create it. Copy & Paste the following (the string to replace ...; Created on 09 August 2014
18. Include a carriage return in a column heading: / SQL Server /; ... [carriage return] but to do this in the name of the column heading, the answer is a much simpler one, in your SQL statement, simply place your cursor where you want the carriage return and press Return/Enter. ...; Created on 07 July 2014
19. JComments 2.3.0 with ReCaptcha in Joomla 2.5.x: / Joomla /; Applies to: Joomla CMS v2.5.11 (Joomla.org) jComments v2.3.0 (JoomlaTune.com) What? Posting this as it was rather rewarding to achieve and I hope will be of some use to others in the same boat. ...; Created on 20 March 2014
20. SSRS Subscriptions cannot be created: / SQL Server Reporting Services /; ... to other systems holding the images), then please refer to my article on SSRS External Images don't display. The answer to this error is your report needs to use a datasource with the credentials stored, ...; Created on 22 November 2013