Search - Joel Lipman .Com

1. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... multi-line field called "Content" and change the properties on creation to allow 32000 characters. Keep the email field called "Email" Return to the Context Handler Function IDE (page where you ente ...; Created on 06 March 2023
2. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... for every photo uploaded, an API call is used up. If you have low limits, even 2000, this means you can only upload 100 products a day if they each have 20 photos (even less products then that as the ...; Created on 17 October 2021
3. Zoho CRM: Get Unique Values of a Text Field: / Zoho /; ... the Zoho Deluge team... Well, they realised they would get the same results, and then suggested looping through all records and creating a distinct list variable... But what if there are 20000+ records? ...; Created on 08 October 2021
4. Zoho Deluge: Convert Xero Date (Unix Timestamp) to Standard Date String: / Zoho /; ... Zoho CRM Invoices and noticed that Xero stores its dates in Unix Timestamps. How? We're going to filter out the unix seconds from the date provided by Xero then apply a toTime() function to it. v_XeroTime="/Date(1586995200000+0000)/"; v_StartIndex ...; Created on 04 May 2020
5. CSS Center an iFrame Horizontally and Vertically: / Cascading Stylesheets /; ... of its app. The alert message is always at the center of the iframe but if the iframe has a height of 2000 pixels, the iframe gets aligned to the top of the parent... How? We're going to use a touch ...; Created on 23 September 2019
6. MS Excel - Open CSV with Long Numbers: / Excel /; ... ID,Name,Phone,Record ID 1457102000000135533,Joel,00441234567890,1457102000000165989 1457102000000135566,Stanley,01709123456,1457102000000167543 1457102000000135608,David,00331234567890,1457102000000166795 My ...; Created on 23 July 2019
7. Zoho Deluge - Get Refresh/Access Token API v2: / Zoho /; ... [Maxiumum 500,000] Enterprise/Zoho One/CRM Plus: 15000 + (Number of User licenses x 1000) API calls/day [Maximum 1,000,000] Ultimate Edition: 15000 + (Number of User licenses x 2000) API ...; Created on 17 July 2019
8. Convert Past Date to Time Ago in PHP: / Personal Home Page /; ... $a_UnitValues = array( floor($v_Seconds / 31536000), floor(($v_Seconds % 31536000) / 2592000), floor(($v_Seconds % 2592000) / 604800), floor(($v_Seconds % 604800) ...; Created on 16 May 2019
9. Basic Android App using Google Maps and Current Location: / AndroidOS /; Applies to: Android Studio (Beta) 0.8.6 Google Android Maps API What? I am writing an app for a tablet running Android and wanted to include a Google Map. The following exercise focuses solely ...; Created on 10 October 2014
10. AHK Countdown Tooltip: / AutoHotkey /; ... SetTimer, UpdateMessage, Off Sleep, 12000 GoSub, GoExit } ThisMessageIndex++ Return ...; Created on 17 July 2014
11. Hide a Drive per User in Windows 7: / Windows OS /; ... 2000 O 16384 4000 P 32768 8000 Q 65536 10000 R 131072 20000 S 262144 ...; Created on 28 March 2014
12. Split a row into multiple rows based on a column value: / Transact-SQL /; ... -------------- ---------------- 001 1.00 1997-11-17 002 3.00 2000-02-18 003 2.00 1999-02-25 What we ...; Created on 23 August 2013
13. Improve Default Joomla Search: / Joomla /; ... + 1000 pts if in title x1 (eg. if word is twice then 2000pts) // + 60 pts if in introtext // + 40 pts if in fulltext $sql_keyword = strtolower(trim($db->Quote($db->escape($text, true), false))); $query->select(' (1000*((LENGTH(TRIM(a.title)) ...; Created on 07 May 2013
14. No rows returned in Oracle causes SP to fail: / Oracle PL/SQL /; ... still an error it would seem. -- Error I was getting ORA-20001: 1234567:$:ORA-01403: no data found ORA-06512: at "BASETABLEOWNER.MY_STUPID_PROCEDURE", line 56 ORA-01403: no data found ORA-06512: ...; Created on 24 January 2012
15. Returning Oracle Stored Procedure Resultset in SSRS: / SQL Server Reporting Services /; ... -- ending that second begin I had after my variable declaration END; EXCEPTION WHEN OTHERS THEN RAISE_APPLICATION_ERROR (-20001, p_STUDENT_ADNAME || ':$:' || SQLERRM, ...; Created on 19 January 2012
16. Basic Oracle Function Structure: / Oracle PL/SQL /; ... open c1; fetch c1 into student_no; if c1%notfound then student_no := 0; end if; close c1; RETURN student_no; EXCEPTION WHEN OTHERS THEN raise_application_error(-20001,'An ...; Created on 15 January 2012
17. SSRS External Images don't displa: / SQL Server Reporting Services /; ... does not exist We don't have photos for all ~20000 students at all times and these get updated/uploaded/added to about once a week. In cases where there are no photos, SSRS displays a mini ugly red cross. ...; Created on 19 September 2011
18. Win32 Constants: / AutoHotkey /; ... = $00000000 Const WS_POPUP = $80000000 Const WS_CHILD = $40000000 Const WS_MINIMIZE = $20000000 Const WS_VISIBLE = $10000000 Const WS_DISABLED ...; Created on 05 July 2011
19. Developer's Checklist: Taking over a projec: / Web-Development /; ... had created the system to only last during one academic year, and the system itself only just about understood academic years (required tweaking twice a year). Then there were the error logs... some 20000 ...; Created on 01 March 2011
20. SSRS Expand specific drilldown by default: / SQL Server Reporting Services /; I thought I'd put something here as there are lots of posts like this on forums (a lot of which seem to be copied & pasted from other sites) but they refer to SQL Server 2000 or SQL Server 2005. This ...; Created on 23 February 2011