Search - Joel Lipman .Com

1. What can MAGA’s do to stop Biden from cheating again?: / Jokes /; A guy goes to a bar and is served by a robot bartender. The robot says, "What'll you have?" and the guy says, "A martini." He then gets the best martini he's ever tasted. The robot says, "What's your IQ?" The ...; Created on 28 August 2024
2. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; ... first designing the template, there could have been a fair few improvements right out of the gate. Then the client comes back and says things like "can we add this?", "can it say this instead?", "can it ...; Created on 07 May 2024
3. Zoho Deluge: Get the Week Number if Week starts on a Monday: / Zoho /; What? A quick article on determining the week number of the year if your week starts on a Monday and not a Sunday. Why? I think it's the US system which generally says that a week starts on a Sunday ...; Created on 06 July 2023
4. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... Now click outside of the option box at the end (in between where it says +1 more) Type the word "value" and press Now type the string of words/phrases that you want to store against this custom paramete ...; Created on 11 February 2023
5. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... Name: fn_eBay_UploadPhoto Display Name: Fn - eBay - Upload Photo Description: What it says on the tin Category: Standalone Click on Create Give it the parameter/argument p_InventoryitemID as ...; Created on 31 March 2022
6. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... Zoho Creator says that public link exists. Let's say I have a field called Main_Photo and this is in a form called Portal_Listing with a report/view called Portal_Listing_Report and I have a publish key ...; Created on 17 October 2021
7. ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.: / Zoho /; ... it says m_ShippingAddress.put("is_one_off_address",true); m_ShippingAddress.put("is_update_customer",false); // send the request via API (change connection name to your own) r_UpdateSO = invokeurl [ ...; Created on 22 September 2021
8. Zoho Creator: Receive JSON via a Shopify Webhook: / Zoho /; ... to Shopify m_Response = Map(); // // enter webhook key featured in the "settings > notifications > webhooks" section beneath the webhooks where it says // "All your webhooks will be signed with .... ...; Created on 15 July 2021
9. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... // return response as ok popup (doesn't really do anything: just says "Record added successfully") v_OutputMessage = "Thank you for submitting your application for leave."; c_Response = Collection(); ...; Created on 10 December 2020
10. Expecting ZC_SUBFORM_250 expression found COLLECTION: / Zoho /; ... found COLLECTION expression How? Quite simply the error is because the Creator Deluge syntax I was using to insert subform rows was wrong. Contrary to what the documentation that says "This task ...; Created on 19 October 2020
11. Zoho Deluge: Search Records with Special Characters (COQL): / Zoho /; ... says: https://zoho.com/ then use the endpoint https://www.zohoapis.com/crm/v2/coql https://zoho.eu/ then use the endpoint https://www.zohoapis.eu/crm/v2/coql https://zoho.com.cn/ then use the endpoint ...; Created on 28 August 2020
12. Zoho Deluge: Setup an API Connection for InvokeURL: / Zoho /; ... example, if it says zoho.com, then this means the US datacenter. If it says zoho.eu, then this is the EU datacenter. If it says zoho.in, then this is the India datacenter. View the attached if ...; Created on 12 August 2020
13. Google Drive API v3 - OAuth2 using Service Account in PHP/JWT: / Google /; ... Token This if else statement simply says if the token still has at least 5 minutes left, then use the one found at the file location specified earlier. if( $api['jwt']['token']['minutes'] > 5){ $access_token ...; Created on 02 February 2019
14. TravelPort Universal API - Ping Request with PHP-cURL: / API Miscellaneous /; Applies to: TravelPort Universal API PHP 4 or 5 cURL What? An article on how to resolve errors and setup a standard ping request using the TravelPort Universal API. This is to be achieved using ...; Created on 27 April 2015
15. SSRS: Performance Improvements: SELECT TOP: / SQL Server Reporting Services /; ... world. Where do the extra 9 minutes come from? Not the SQL as this runs in 00:00 seconds in SQL Server Management Studio. Not the internal processing and rendering as the report server says it did this ...; Created on 07 March 2014
16. How to change local folder for TFS: / Team Foundation Server /; ... should copy over to your local folder; once doneclose the dialogs click on the TFS icon in Source Control Explorer and check what it says next to "Local Path" (for me this said the name of the local folder ...; Created on 08 March 2012
17. Performance Report - Background colors based on dataset values: / SQL Server Reporting Services /; ... a million better solutions out there, this is just how I did it. This may look like a horrible report which would fail an accessibility test but visually it says straight away which is the better report; ...; Created on 02 December 2011
18. SSRS Retrieving Oracle Stored Procedure Success or ErrorLevel: / SQL Server Reporting Services /; ... was executed, it could only really display a message saying "executed stored procedure", "please click on the link to continue" and then the user would be taken to a report which says either "Stored Procedure ...; Created on 04 November 2011
19. T-SQL Record Separator: / Transact-SQL /; ... Marker */ As I mentioned at the beginning of this article, I am comparing on Day names. The above query generates a last column which is either empty or says "Separator Marker". Based on the CTE above, ...; Created on 11 October 2011
20. SSRS Querying on either of 2 Parameters: / SQL Server Reporting Services /; ... part to all my datasets (so where each one says if studentreference is blank then compare to studentadaccount)… Both solutions have the issue where they will return all rows where studentadaccount ...; Created on 19 July 2011