Search - Joel Lipman .Com

1. Zoho Projects: Get All Events: / Zoho /; What? A quick article because I couldn't find anything that documented this with a working example. Why? The use-case here is that we want to make a ZohoCreator page display events for this month ...; Created on 22 July 2024
2. Zoho Creator: Input Color Picker: / Zoho /; ... on one to select it. When are colors used? Well in this use-case, we are using it to color events in a calendar associated with specific staff. Probably not the most essential part of a system ...; Created on 14 October 2024
3. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... nt out for signature"); r_CreateEvent = zoho.crm.createRecord("zohosign__ZohoSign_Document_Events",m_CreateEvent); } } // // over to webhook to update this record and attach signed document to cont ...; Created on 06 August 2024
4. Zoho Creator: Get Images in Report to be Exported to PDF: / Zoho /; ... form), Image, File, Local Image, Subform Row ID (prevents duplicates). Note: I create the form then add it as a subform on the parent form first, then add the lookup to the ticket field on the subform ...; Created on 26 January 2024
5. Zoho CRM: Schedule a Meeting using Deluge: / Zoho /; ... Mins"); // // the meeting status m_ScheduleMeeting.put("Status","Not Started"); // // send request and create record r_CreateMeeting = zoho.crm.createRecord("Events",m_ScheduleMeeting); // // outpu ...; Created on 02 March 2022
6. ZohoCRM & Xero Real-Time Invoices: Receive Webhook: / Zoho /; ... check if events was in the payload if(!isnull(m_Body.get("events"))) { // // parse events out of the webhook (a list) l_Events = m_Body.get("events").toJSONList(); // // loop through the events fo ...; Created on 10 January 2022
7. 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
8. Zoho Creator: Copy Subform to other Subforms: / Zoho /; ... // get Monday entries/rows v_EventType = r_Row.Event_Type; v_EventStart = r_Row.Start_Time; v_EventEnd = r_Row.End_Time; // // create Tuesdays ...; Created on 17 November 2021
9. Zoho Deluge: Generate and Send a CSV via Email: / Zoho /; ... someone may want to open this in Google Sheets or Microsoft Excel: // // init l_NewCSVrows = List(); v_ThisEventTime = zoho.currenttime; // // loop through dataset for each r_Event in zoho.crm.getRecords("Events", ...; Created on 16 June 2021
10. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... c_Error.insert("errors":c_Response); return c_Error; Displays to the user as per the following screenshot AND prevents the user from submitting this until they provide a date that doesn't clash: ...; Created on 10 December 2020
11. Expecting ZC_SUBFORM_250 expression found COLLECTION: / Zoho /; ... can be used in the following events", effective as of today October 19, 2020, I have not found a place you cannot use this deluge script. The ZC_SUBFORM_250 error is because I am trying to assign the ...; Created on 19 October 2020
12. Zoho CRM: APIv2 using PHP & cURL: / Zoho /; What? This is an article documenting how to access ZohoCRM with API v2 using PHP and cURL. The first few functions are to manage OAuth v2 and generate the refresh and access tokens. The second snippet ...; Created on 30 January 2019
13. Protecting your Joomla Administrator Section: / Joomla /; ... me on Joomla websites in general and prevents the administrator URL showing up at all in the stats (unless you were using it). Leaving this unchecked means that the crackers/hackers will get through ...; Created on 23 October 2015
14. Import Excel CSV file as JavaScript array: / Excel /; ... row_content.split(/,(?=(?:(?:[^"]*"))*[^"]*$)/); // prevents JS error where results unmatched column_values = column_values || []; // ignore row ...; Created on 05 October 2015
15. Joes Word Cloud (JWC) Download: / Downloads /; ... Integration: Include jEvents.- Date Uploaded: Wed, 8th May 2013 2.0.0 - Checked for compatibility with Joomla v2.5.x - Enhancement: SearchURL is html decoded/encoded for W3C Validation - Bug Fix: ...; Created on 07 September 2015
16. SSIS Multiple Lookups in one: / SQL Server Integration Services /; ... [student_country_birth_code], [student_country_domicile_code], [student_nationality_code], [student_ethnicity_code] FROM [sourcedb].[dbo].[events] Simple bit of ...; Created on 05 August 2014
17. T-SQL: Parse an XML value: / Transact-SQL /; ... in a database and rather than a separate file, it stores these in a row. How? Assuming the following data exists in the column "Event_XML" value of the table "XML_EVENTS": 123456 ...; Created on 27 March 2014
18. Generate a Timesheet in MySQL: / MySQL /; What? This article is to remind me how to create a blank weekly timesheet which reads the duration of events from a database and auto-completes your timesheet. Why? I'm being tasked to work with ...; Created on 05 December 2013
19. DataScramble - Randomizing data rows: / Transact-SQL /; ... DECLARE @ColumnTypeIsDate int; DECLARE @IntOptions int; DECLARE @CharOptions varchar(max); -- Format given value (prevents CHAR datatype issue) SET @OrigVal = LTRIM(RTRIM(@OrigVal)); ...; Created on 07 December 2012
20. Sync Outlook 2007 Shared Calendar with SharePoint 2007: / SharePoint /; ... in your Outlook, you can copy over events. The calendar is separate to your own and to other Exchange ones. Eeek! A bit daunting of a process as you may be lead to believe that your personal calenda ...; Created on 09 November 2012