Search - Joel Lipman .Com

1. Zoho Workdrive: Getting Team Folder ID: / Zoho /; ... on "My Folders" and then checking the URL https://workdrive.zoho.com/home//privatespace/folders/ Getting the teamfolder ID: Access the folder in workdrive and check the URL: https://workdrive.zoho.com/home//teams//ws//folders/files or https://workdrive.zoho.com/home//teams//ws//folders/ ...; Created on 11 September 2024
2. 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
3. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... */ // // set your own REST API endpoints for the webhooks here (we are only checking order update or inventory level update) v_CrmOrderUpdateWebhook = "https://www.zohoapis.com/crm/v2/functions/fn_shopify_webhook_orderupdate/actions/execute?auth_type=apikey&zapikey=1003.aaaabbbbccccddddeeeeffff00001111.22223333444455556666777788889999"; v_CrmInventoryLevelWebhook ...; Created on 22 April 2024
4. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 characters: / Zoho /; ... + p_QuoteID type :GET parameters:m_ApprovedConverted connection:"zcrm" ]; // should be checking here that data contains any rows but I'm going on the basis that this quote exists in CRM an ...; Created on 18 September 2023
5. Zoho Deluge: Determine if Daylight Savings are in effect: / Zoho /; ... checking if daylight savings is in effect in the UK, we should be able to take Greenwich Mean Time and compare to UTC. b_IsDSTInEffect = if(zoho.currenttime.toString("HH:mm", "UTC") != zoho.currenttime.toString("HH:mm", ...; Created on 03 July 2023
6. Zoho Deluge: Generate a loop or list of any size: / Zoho /; ... of weeks thereafter). This needs to be dynamic as it is a schedule run daily checking the availability of a staff member for the upcoming week. How? As mentioned, using leftpad takes 2 parameters, ...; Created on 21 October 2022
7. ZohoCRM: zoho.crm.searchRecords only returns certain records: / Zoho /; ... with a zoho.crm.getRecordByID() with a quote that works and a quote that doesn't Comparing both records JSON and finding the $converted system field is different. Checking the Zoho documentation for ...; Created on 29 July 2021
8. Zoho Deluge: Setup an API Connection for InvokeURL: / Zoho /; ... type: GET connection: "joelconnector" ]; Additional I'd always recommend locking down your app privileges by checking the scope(s) you have allowed it to have.... However in those times of ...; Created on 12 August 2020
9. AutoHotkey: App GUI Listview to Rename Files: / AutoHotkey /; ... checking if the value is not already in the list ; also check whether proposed file name matches the original file exists and is an exception for renaming. v_Increment := 1 b_KeepLooping ...; Created on 08 July 2020
10. Zoho CRM/Creator - Common Errors & Gotchas: / Zoho /; ... match in both irrespective of the value. Consider trying to get authorized and checking the Redirect URI passed in the URL and then updating your app with the same value, such as: // for Books OAuth ...; Created on 06 February 2020
11. Zoho Deluge - First Monday of Month or Last Tuesday of Month: / Zoho /; What? An article on setting a date field to either the first Monday of the next month or to the last Tuesday of the current/next month. What I mean by the last Tuesday is if the last Tuesday of the ...; Created on 27 September 2019
12. Zoho Deluge - Some Useful Regular Expressions: / Zoho /; ... = "String to output: /* this is a comment */"; v_MyFormattedString = v_MyString.replaceAll(v_MyRegEx,""); // yields String to output: Zoho Deluge Validation Checking by Regular Expression: So ...; Created on 31 May 2019
13. Google Drive API v3 - OAuth2 using Service Account in PHP/JWT: / Google /; What? This is an article explaining the code needed to write a PHP script which generates an access token for a service account which in turn is used to list files in a team's Google Drive. This is ...; Created on 02 February 2019
14. Zoho Deluge: Check Time Booking Slots: / Zoho /; What? Just wanted a note to get in my head the logic if checking a requested time slot isn't a double-booking (as in, the time slot doesn't overlap a previous booking. How? Given a date/time and ...; Created on 05 December 2018
15. Google Authentication - OAuth 2.0 using PHP/cURL: / Google /; ... on the code. How? So the plan is: Declare the functions. Authenticate on page load by checking timestamp in token file: If token is required, redirect user to Consent page and rewrite token ...; Created on 31 October 2018
16. Protecting your Joomla Administrator Section: / Joomla /; ... and will remain in place even if you update your Joomla CMS. Why? When checking audit logs, I sometimes see that my administrator url is accessed more than my front-end. The below has worked for ...; Created on 23 October 2015
17. Joes Word Cloud (JWC) Download: / Downloads /; ... 14th Mar 2011 1.5.0 - Merged all queries for checking 3rd-party content into one SQL query. - Added Joomla! Admin Option: Display SQL query sent to Database. - Added Joomla! Admin Option: Case-sensitive ...; Created on 07 September 2015
18. DJI Phantom FC40 Paint-Job and AerialFreaks Cyclops FC40 Gimbal Upgrade: / Quadcopters /; ... own FC40 camera It had had a bad crash previously and loosening some of the screws snapped the edges back into place. I thought why stop there? The anatomy of a DJI Phantom FC40 Checkin ...; Created on 04 September 2014
19. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCase: / SQL Server Integration Services /; ... buffer it loops through each of the input columns passed into the component // It locates the actual column value (including checking for null) using the index array created in the Pre-Execute ...; Created on 04 October 2013
20. T-SQL Conversion failed when converting the varchar to data type int: / Transact-SQL /; ... by checking the datatypes for each field in the concatenation string: LTRIM(RTRIM(rm.Name + ', ' + rm.[Zone] + ', ' + CONVERT(VARCHAR(4), rm.[Capacity]) + ', ' + rm.[Type] + ', ' + rm.[DeptId])) AS RoomDetails / ...; Created on 14 May 2013