Search - Joel Lipman .Com

1. Google Event Ilustrations aka Flairs: / Google /; ... jogs, runs sailing: sail, sailing, boat cruise, sailboat santa: Santa Claus, Father Christmas skiing: skiing, ski, skis, Snowboarding, snowshoeing, snow shoe, snow boarding soccer: soccer swimming: ...; Created on 05 December 2024
2. Zoho Deluge: Determine your Statement Execution Limit: / Zoho /; ... v_Iteration; } // yields an incremental count from 0 to 4999 Statement Execution Limit is 10000 If the below runs successfully, then the limit is at least 10'000: // v_Counter = 0; l_Loop ...; Created on 31 July 2024
3. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Lead: / Zoho /; ... our friend. How? So we'll run a workflow that triggers on the creation of a lead and runs a function which will simultaneously create a task with a reminder both on popup and email which repeats ...; Created on 14 May 2024
4. ZCRM Client Script: Correct Decimal Fields OnLoad: / Zoho /; ... both of the methods below, you will need to setup a client script which runs when the product page is being modified: Login to ZohoCRM as a system administrator Give it a name, I'm calling mine "Products ...; Created on 13 December 2023
5. Zoho Books: Generate Bank Text File for Download: / Zoho /; ... file permanently. You only need to run either of these as the second one runs both (disassociate and delete): // disassociate as attachment (removes attachment from the Bill but keep in ZohoBooks documents) r_Detach ...; Created on 02 October 2023
6. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; ... really a hardware kind of guy. My skillset is really around software (see my other articles) and I've been using Mac alongside my PCs for the past 7 years. My MacBook is from 2015 and still runs everythin ...; Created on 12 March 2022
7. Zoho Creator: Radio group into Calendar Carousel: / Zoho /; ... = v_PreselectedValue; // // hide (comment this out if you are still debugging) hide Hidden_Fields; Then we need a workflow/trigger that runs whenever a user clicks on one of these date boxes (On ...; Created on 09 March 2022
8. ZohoCRM & Xero Real-Time Invoices: Receive Webhook: / Zoho /; ... in Xero. Why? I used to use ZohoCRM schedules to pull when an invoice has been paid, but ZohoCRM schedules run only every 2 hours. You can set up 2 schedules: one that runs on even hours and one ...; Created on 10 January 2022
9. Zoho Creator: Copy Subform to other Subforms: / Zoho /; ... runs the following deluge script: // only run if true if(input.Copy_Monday_to_the_Other_Days) { // init c_Tuesday = Collection(); c_Wednesday = Collection(); c_Thursday = Collection(); ...; Created on 17 November 2021
10. Zoho Creator: Prevent Endless Loops On User Input of a Field: / Zoho /; ... OnEdit, when we reach field 1 and audit change is invoked, the tickbox becomes false then true at the end of that workflow, but then field2 gets populated and runs the audit change (false to true). In ...; Created on 19 September 2021
11. URL Alias uniqueness with PHP & MySQL: / Personal Home Page /; ... run it anyway. Additional Note(s): The trigger only runs if inserting a record. If your script is trying to modify/update a record with a value that already exists in the table, you will get an ...; Created on 06 May 2019
12. Pure JS - Display Time Elapsed & Remaining: / JavaScript /; ... but you could get your values from anywhere: On page load, the seconds remaining and elapsed are specified JS then takes over and runs the time var seconds_remaining = ; var seconds_elapsed ...; Created on 30 October 2018
13. 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
14. AwStats Data Parser (ADP): / Product Documentation /; ... reports then scanning entire website visitor logs. No installation and USB portable. Currently runs using either Windows XP or Windows 7. How to use: Save a frame of your Awstats page (so ...; Created on 03 April 2013
15. Performance Report - Background colors based on dataset values: / SQL Server Reporting Services /; ... and when comparing to the previous runs (using a second dataset) you can tell where changes were made and how this affected the reports' performance. What? What I'm trying to do is display a set ...; Created on 02 December 2011
16. SSRS Parameters in Oracle Stored Procedure: / SQL Server Reporting Services /; ... main report runs with incident number as NULL, the user can then add an incident number afterwards or when the initial report was run). The confirmation page just checks with the end-user that this ...; Created on 02 September 2011
17. Joes FREE Website Thumbnailer (JWT): / Product Documentation /; ... program and generated the thumbnail... Do more? If you have more than one monitor then this isn't an issue, but because the program runs on top of every other window, not even "dual-core" will let you ...; Created on 28 June 2011
18. MySQL: Find records in one table that are not in another.: / MySQL /; ... I work this out without using two SQL scripts. Currently I've returned to the process where one SQL query returns all possible results and the PHP script runs another SQL query for each row to check ...; Created on 25 February 2011
19. Migrate Joomla! 1.5.x to 2.5.x+: / Joomla /; ... want to add new 3rd-party components. If asked: "how long will it take", do not say 5 minutes. This script runs on average in 15 seconds. The remaining hours, days, weeks will be spent on bringing ...; Created on 30 January 2011
20. Running Internet Explorer 6, 7, 8 as standalones: / Windows OS /; ... processor (1.0 GHz or faster recommended), and requires approximately 35 MB of disk space. It runs on Windows Vista Business, Windows Vista Enterprise, Windows Vista Ultimate, Windows XP Professional, ...; Created on 18 May 2010