Search - Joel Lipman .Com

1. 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
2. Zoho CRM REST API: Stop Workflow from Triggering: / Zoho /; ... or updateRecord. Why? We had a Creator app updating a CRM record which in turn had a workflow to update the Stage in Creator (so a user can change the stage in CRM and it would reflect this in the ...; Created on 16 June 2021
3. Zoho CRM: Update a custom field in line items / product details using REST API v2.1: / Zoho /; ... to update the field with label "Group Name" but API name "Grouping" in a list item column. The standard code you used to use even for REST API v2.0 would have been something like the following: // // ...; Created on 17 May 2021
4. Zoho Projects: Add a Time Log to an Issue using Deluge: / Zoho /; What? This is an article to demonstrate how to log a time event under a Zoho Projects Issue using code (Zoho Deluge) rather than the graphical user interface (GUI). Note this would probably be similar ...; Created on 30 April 2021
5. Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party API: / Zoho /; ... think... Doing the above, I would get a really messy response (I'm targeting an API made with ExpressionEngine) such as: Fatal error: Uncaught Error: Class '\Webservice\Service\Exception' not found in ...; Created on 03 February 2021
6. Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments: / Zoho /; ... "link_Docs": 0 } ], The most logical thinkers would say that you simply need the download_Url value and prepend the CRM base URL such as https://crm.zoho.com + v_download_Url... But that ...; Created on 02 February 2021
7. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... The trick in this solution was more about the process and what that process was. Reading the brief, and having written many custom functions for other Zoho apps, it would stand to reason that ...; Created on 10 December 2020
8. Zoho Creator: info/alert/modal/popup notification for any user: / Zoho /; ... using the built-in popup of Zoho creator and gives you the freedom to style the notification as any modal would. 1. Create a page This will be the page containing the styled modal. I'm going to ...; Created on 06 November 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. Expecting ZC_SUBFORM_250 expression found COLLECTION: / Zoho /; ... The specific form was for "Leads" which contained a subform with a product line item list. If I run this code, I would get the error: Expecting ZC_SUBFORM_250 expression found COLLECTION expression Another ...; Created on 19 October 2020
11. COVID-19: Working from Home: / Articles /; ... was waiting to move house during 2020 but then a virus capable of locking down the world manifested itself. I thought this would be temporary but after 4 months of slouching over the coffee table, my ...; Created on 05 July 2020
12. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Books: / Zoho /; ... not appear to be included in any sync... This method would be enough if the action was instantaneous and the attachments were also attached to the Sales Order in Books... but it isn't and doesn't. It only ...; Created on 15 May 2020
13. JComments errors in PHP 7: plgContentJComments and JCommentsACL: / Joomla /; What? During a site upgrade, the commenting extension for Joomla called JComments would return errors when using PHP version 7. This is a quick article to document what needed doing to fix the errors. ...; Created on 13 March 2020
14. Zoho Deluge - Compare time and currenttime with timezone: / Zoho /; What? This is a quick article to demonstrate how to compare two datetime values with the timezone specified. Why? A client's ZohoCRM had a different timezone setting than the user a script would ...; Created on 13 January 2020
15. Zoho Deluge - First Monday of Month or Last Tuesday of Month: / Zoho /; ... day of the month and coincidentally a Monday, then we would want to specify the field date to be the first Monday of the next month. If however we want the last Tuesday of the month and that Tuesday happens ...; Created on 27 September 2019
16. Zoho Deluge: Adding / Removing Total Tax from a Quote Record: / Zoho /; What? A quick reminder on when I want to apply overall Tax or remove Tax from a quotes product line items. Why? I would apply the standard update function and although the response would say it ...; Created on 20 August 2019
17. Zoho Deluge - Get Refresh/Access Token API v2: / Zoho /; ... You would only generate a new one if you were changing scope. There is a limit of 20 refresh tokens. Any refresh tokens generated after will overwrite the oldest one. Access Token This will expire ...; Created on 17 July 2019
18. CSS Ordered List 1, 1.1...1.10 Formatting and Alignment: / Cascading Stylesheets /; ... of digits (eg. 1.10) the text would be more indented (relative) to 1.1. I need all list elements to be all perfectly aligned. // What I Have 1. Item 1 1.1 Item 1a 1.2 Item 1b ...; Created on 10 July 2019
19. Zoho Deluge - Generate 5 Letter Booking Retrieval Code: / Zoho /; ... the booking as well as the customer's surname (method #1 would not be guessed by date/time): string generateRetrievalCode() { // init v_Output = ""; l_Output = List:String(); l_Alphabet ...; Created on 09 May 2019
20. Minimal Privileges for MySQL Database Backup Cron Job: / cPanel /; ... Others around the web have suggested the following but I don't have these options to grant and would have to grant them via a terminal/command line to MySQL. GRANT SELECT, LOCK TABLES, RELOAD, PROCESS, ...; Created on 20 March 2019