Search - Joel Lipman .Com

1. ZohoCreator: Using .toFile and Uploading to a Creator field: / Zoho /; ... photos and a bit of fuzzy logic. I thought I could simply update the field with the new file but as I'm not downloading it, this is apparently not the process. How? As a high-level overview: ...; Created on 25 March 2024
2. Zoho Deluge: Get the Week Number if Week starts on a Monday: / Zoho /; ... starts at 7, followed by 1 for Monday, 2 for Tuesday, and so on... How? The logic behind this would be to take the date of the order, check if the order date is a Sunday, subtract a day, and return ...; Created on 06 July 2023
3. 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
4. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Books: / Zoho /; ... attaches the file(s) to the CRM record. See my "Additional" note further below in this article on how to sync the attachments to the CRM record, however for now, check the logic of this as this is known ...; Created on 15 May 2020
5. Zoho Deluge - Determine Quarter from Date with Fiscal Year: / Zoho /; ... year starts from January, simply divide by 3... How? I'm showing this in Zoho Deluge but the logic can be adapted to other code. You will need this snippet of code for the examples below: l_Months ...; Created on 31 January 2020
6. Zoho Creator: Retrieve record with case-insensitive query: / Zoho /; ... though I tend to use !myVar.contains() startsWith startsWithIgnoreCase used in fuzzy logic searches to broaden the resultset containKey Applies to maps only containValue Applies to maps only ...; Created on 21 November 2019
7. Google Drive API v3 - OAuth2 using Service Account in PHP/JWT: / Google /; ... logic and highlight any changes you may need to make. 1. First: the variables are in arrays Well mostly. Simply because we'll be working with JSON data and this encodes/decodes easily into PHP ...; Created on 02 February 2019
8. 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
9. Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library): / Google /; ... How? I've listed below 3 methods, the first follows the manual (or the logic thereof as I don't use the client library) and is a function sending two requests, the second is the appropriate multipart ...; Created on 29 October 2018
10. PHP: First name and Initial of Surname: / Personal Home Page /; ... What I want John S. Fred B. How? So different ways, the first thing I did was to create the logic: // default $author_name_disp=$author_name; // check and transform if(strpos($author_name, ...; Created on 27 March 2014
11. T-SQL concatenate an incremental row number: / Transact-SQL /; ... Grade 1 001 Computer Science BSc 2.1 2 001 Superman 10/10 3 002 Tape-Monkey Engineer 1:0 So based on this logic, the Employee ...; Created on 24 May 2013
12. T-SQL Record Separator: / Transact-SQL /; ... different to previous row)... Stage #3: Use dummy separator row Thinking logically, Stage #2 overwrites data in the last row of the day (the one marked with a separator) which happens to be data ...; Created on 11 October 2011
13. Licence GNU/GPL: / Static Items /; ... 3. Protecting Users' Legal Rights From Anti-Circumvention Law. No covered work shall be deemed part of an effective technological measure under any applicable law fulfilling obligations under article ...; Created on 03 April 2009