Search - Joel Lipman .Com

1. Zoho Analytics: Create a Monitoring System with Images: / Zoho /; ... " = img."Status Value" This produces something as follows: Create a widget that shows an image This step here will create a widget that will show the last image (or first image if ordered ...; Created on 25 July 2024
2. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; ... purchase order items by the custom lookup field. What follows is the code required to build the custom related list in ZohoBooks: /* ******************************************************************************* Function: ...; Created on 09 July 2024
3. Zoho Analytics & Zoho People: Monitor DataSource Sync: / Zoho /; ... = "Hi there! This is an email to advise that the synchronization between your Zoho People and Zoho Analytics instances failed. The last synchronization data we have is as follows: "; if(!isNull(m_DataSourceInfo.get("datasourceName"))) { for ...; Created on 02 July 2024
4. Zoho CRM: Client Script Confirmation Box and Popup Mailer: / Zoho /; ... for myself is as follows: Trigger if the contact record has a tickbox called "Extra Confidential" ticked/checked=true Popup a confirmation box to proceed or cancel. Popup the email from CRM mailer ...; Created on 06 February 2024
5. Zoho Books: Get Invoice Payment Terms via API: / Zoho /; ... This should yield something as follows: { "code": 0, "message": "success", "data": { "payment_terms": [ { "payment_terms_id": "123456000000000123", "payment_terms": ...; Created on 06 July 2023
6. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... m_Params.toString() ]; v_Output = r_UploadPhoto; } return v_Output; } Sends something like the following request (sent using Zoho Deluge but the cURL breakdown as follows): curl -d ...; Created on 17 October 2021
7. Zoho Deluge: Sort a Map by a specific field: / Zoho /; What? This is a quick article to template some code to me on sorting a map variable in Zoho Deluge, specifically Zoho Creator. Why? I do this a lot but in the following example, I want to sort ...; Created on 29 January 2021
8. Zoho Deluge: Convert Map to URL Parameters: / Zoho /; ... What follows is the code I'm using to convert this: v_Endpoint = "https://api.joellipman.com/myapi"; l_UrlParams = List(); for each v_Key in m_Payload.keys() { l_UrlParams.add(v_Key.toString() + ...; Created on 09 March 2020
9. 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
10. Zoho Deluge - Get Refresh/Access Token API v2: / Zoho /; ... :PUT parameters:m_Data connection: myconnector ]; : Can happen when posting to ZohoBooks and you haven't put JSONString into a map as follows: m_Header = Map(); m_Header.put("Authorization","Zoho-oauthtoken ...; Created on 17 July 2019
11. Excel - Check a column for values found in another column: / Excel /; ... contains the following:: A --------------- warm noise term wreck The formula to paste in column B of Sheet1 is as follows: =SUMPRODUCT(--ISNUMBER(SEARCH(Sheet2!$A$1:$A$4,Sheet1!A1)))>0 Where: SumProduct( ...; Created on 14 February 2019
12. Zoho Deluge - Get Full Day Name: / Zoho /; ... = today; Day_Name = My_Date.toString("EEEE"); // returns "Monday" Method #1: We're going to populate two arrays / lists; retrieve the index value; and use this in the second array as follows: // ...; Created on 08 November 2018
13. 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
14. SSIS Multiple Lookups in one: / SQL Server Integration Services /; ... one lookup task: Changing the lookup to "use results of an SQL query": Which would code with the joined tables as follows (note that in our case we needed the lookups on the source database which ...; Created on 05 August 2014
15. htaccess Rewrites SEF URL and submits to PHP: / Personal Home Page /; ... Options -Indexes +FollowSymlinks RewriteEngine On RewriteBase / RewriteCond % !index.php RewriteCond % ^/([^\.]+)\/([\w]+).html [NC] RewriteRule .* index.php?myFolder=%1&myFiles=%2 [L] ErrorDocument ...; Created on 05 September 2013
16. SSIS Skip Blank Rows in Flat File Source: / SQL Server Integration Services /; ... chars rather than Null). My example here is that the first column is our employee number and the second column will be the remaining data on that row. So I setup my connection manager as follows ...; Created on 23 April 2013
17. Joomla article modal with clear button: / Joomla /; Applies to Joomla 1.6+ What? This is an article to describe how to add an article modal button in the Joomla Admin Panel (at time of print version 2.5.6) of your component including the all important ...; Created on 27 August 2012
18. MySQL last year week month day trend periods: / MySQL /; ... since becoming an analyst, I do more at the database level now. What follows should be usable mySQL statements to get all the numbers: Yesterdays -- CURRENT: count todays SELECT COUNT(id) FROM ...; Created on 31 October 2011
19. Reminder on SSRS row separator: / SQL Server Reporting Services /; ... Main Office 09:00 17:00 Notes Tuesday 04/10/2011 Another Office 09:00 17:00 Notes Row Seperator This follows on from my T-SQL Record Separator article. ...; Created on 26 October 2011
20. Before and After, Highs and Lows: / SQL Server Reporting Services /; ... as follows: Report Name Run Last Week Run This Week ------------------ ----------------- ------------------- Report 001 5 2 Report 002 11 ...; Created on 03 August 2011