Search - Joel Lipman .Com

1. Zoho Projects: Get All Events: / Zoho /; ... + ":00"; // // date and time obtained... do your other stuff here } } } } // // get all future events // NB: status=open are upcoming events; status=closed are events in the past; ...; Created on 22 July 2024
2. ZohoCreator: Basic Widget with Zoho Data: / Zoho /; ... the JavaScript These are the contents of main.js and is working at time of print: // Start with Zoho SDK stuff ZOHO.CREATOR.init() .then(function(data) { // Initialize ...; Created on 14 March 2024
3. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; ... c_Employee in l_ApplicableStaff { info c_Employee.Name; // // reset the stuff they already have in their subform "Usual Shift" c_Employee.Usual_Shift.clear(); // // great now let' ...; Created on 28 March 2023
4. ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM record: / Zoho /; ... if Deal ID is not zero, then it was found! if(v_DealID != 0) { r_DealDetails = zoho.crm.getRecordById("Deals",v_DealID,); // // do stuff here such as updating the deal if required m_UpdateDeal ...; Created on 17 October 2022
5. Amazon Kindle: Send PDFs to your Kindle: / Kindle /; ... as you would any other reading stuff. It’s true you need to go through an initial set-up process which essentially boils down to getting your email ID added to the approved list as well as finding out ...; Created on 29 June 2022
6. Zoho CRM: searchRecords with sorted results: / Zoho /; ... in l_SearchResults { // check that there is an ID on this record to avoid looping through error messages if(!isNull(r_Result.get("id"))) { // do stuff to each record... info r_Result.get("id"); } } // // ...; Created on 10 February 2022
7. Zoho Creator: Prevent Endless Loops On User Input of a Field: / Zoho /; ... > input.DateTime_form_was_loaded.addSeconds(10)) { // do my stuff here } Method #2: Boolean checkbox to switch on/off workflow Another method I tried was adding a checkbox/decision box (boolean) ...; Created on 19 September 2021
8. ZohoCRM: Process all records of a module: / Zoho /; ... field update if(!isnull(r_Record.get("Account_Name"))) { // do other stuff v_CountUpdated = v_CountUpdated + 1; } // // update the record irrespectively m_Update.put("Processed",true); r_Update ...; Created on 24 August 2021
9. Zoho Deluge: Duplicate/Clone a Record: / Zoho /; ... yields: // a,b,c,d,e // a,c,e // compared to: for each v_FieldName in l_FieldApiNames { if(!l_ExcludeFields.contains(v_FieldName)) { ... do stuff here ... } } // notes: // no need ...; Created on 17 March 2020
10. MS Excel - Split Workbook into separate files per sheet: / Excel /; ... As Integer Dim xWs As Worksheet On Error Resume Next xTitleId = "Joes Do Excel Stuff Script" Set WorkRng = Application.Selection Set WorkRng = Application.InputBox("Range", xTitleId, ...; Created on 11 February 2019
11. Google Drive API v3 - OAuth2 using Service Account in PHP/JWT: / Google /; ... n the private key we need. It is a JSON file with links to the public key, as well as info as to the project ID, the client ID, the client Email... Stuff that this script will use so: // Get JSON fi ...; Created on 02 February 2019
12. Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library): / Google /; ... do ssl checks curl_setopt($ch1, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($ch1, CURLOPT_SSL_VERIFYHOST, false); // do other curl stuff curl_setopt($ch1, CURLOPT_URL, $GAPIS . 'upload/drive/v3/files?uploadType=media'); ...; Created on 29 October 2018
13. Quadcopter App with Flight Restrictions (JQA): / Product Documentation /; ... added - [1.6.1] Map: display local governing body - [1.6.1] Map: tooltip for nearby places details - [1.6.1] Help: boring stuff moved - [1.6.0] News: expand for descriptions - [1.6.0] Map: tweaks ...; Created on 24 October 2014
14. MessageBox or AlertDialog in Android Java: / AndroidOS /; ... { public void onClick(DialogInterface arg0, int arg1) { // Some stuff to do when ok got clicked } }) .setNegativeButton("cancel", ...; Created on 20 October 2014
15. ReCaptcha alternative: Integrate PlayThru in JComments 3.0 for Joomla 3.2: / Joomla /; Applies to: Joomla CMS v3.2.3 (Joomla.org) jComments v3.0.0 (JoomlaTune.com) PlayThru v1.1.8 (AreYouAHuman.com) What? This article is a follow on from my article JComments 2.3 with PlayThru ...; Created on 27 April 2014
16. ReCaptcha alternative: Integrate PlayThru in JComments 2.3 for Joomla 2.5: / Joomla /; Applies to: Joomla CMS v2.5.11 (Joomla.org) jComments v2.3.0 (JoomlaTune.com) PlayThru v1.1.8 (AreYouAHuman.com) What? This article is a follow-up of my article JComments 2.3.0 with Google ReCaptcha ...; Created on 24 March 2014
17. Access MySQL databases using Oracle SQL Developer: / MySQL /; ... recommend using Oracle SQL Developer. You have to use mostly SQL to create tables and stuff. Recommend to your bosses that you need the MySQL Workbench as this is FREE and with all the features you ...; Created on 01 February 2013
18. DataScramble - Randomizing data rows: / Transact-SQL /; ... CAST(@RandYear AS CHAR(4)) + '-' + STUFF(@RandMonth, 1, 0, REPLICATE('0', 2 - LEN(@RandMonth))) + '-' + STUFF(@RandDay, 1, 0, REPLICATE('0', ...; Created on 07 December 2012
19. Slideshow div layer through a window: / MooTools Framework /; ... I want to create a div layer that I can see through (like a window with no glass) and for all the flashy stuff, to only appear within the boundary of the parent div layer. Why? I'm making a slideshow ...; Created on 11 September 2012
20. Copy a table with structure and data into a temporary table: / Transact-SQL /; ... (dummyIndex INT); -- Alter temporary table structure to match given table SET @TableDeclaration='ALTER TABLE #myScrambledTable ADD ' + STUFF( ( -- Code to concatenate column names and data ...; Created on 03 August 2012