Search - Joel Lipman .Com

1. Zoho Deluge: Convert Hex to RGB: / Zoho /; What? A quick article to document a Zoho Deluge function converting a hexadecimal color reference to a Red Green Blue value (RGB). Why? It's likely that Zoho will avail their color picker at some ...; Created on 11 October 2024
2. Zoho Deluge: Determine your Statement Execution Limit: / Zoho /; ... So create a function in the Zoho App you are checking, or somewhere you can write some Zoho Deluge code. Note that requesting an increase of the limit or an upgrade to the subscription will likely ...; Created on 31 July 2024
3. Zoho CRM: Change System Field Length: / Zoho /; ... deal module, the Zip field is 20 characters... but we need these to match if we want to map them in the "Lead Conversion Mapping" page. How? This is a bit of a hack and most likely not recommended... ...; Created on 19 June 2023
4. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... mode is only available in the most expensive subscription plan. NSFW will likely be blocked. Installing Stable Diffusion on a local server is the recommended stealth mode. Check out Matt Wolfe's video ...; Created on 11 February 2023
5. Zoho Creator: Prevent Endless Loops On User Input of a Field: / Zoho /; ... fields of the record that I want to monitor. An eTag for me is simply an MD5 or hash of a bunch of data. If your MD5 value is different, then it means there was a change. If not then it is unlikely ...; Created on 19 September 2021
6. Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Deluge: / Zoho /; ... is likely to be a linking module which has a multi-select lookup on both the deal/opportunity and products module. A multi-user lookup will tend to have something like "ModuleName_X_Users". Find records ...; Created on 28 April 2021
7. Zoho CRM/Creator - Common Errors & Gotchas: / Zoho /; ... test. The likely ones you want are: ZohoCRM.modules.ALL ZohoCRM.settings.ALL ZohoCRM.users.ALL or to be safe ZohoCRM.modules.ALL ZohoCRM.settings.READ ZohoCRM.users.READ Problem: Code ...; Created on 06 February 2020
8. Zoho Deluge - First Monday of Month or Last Tuesday of Month: / Zoho /; ... the first Monday of the month (ignoring bank holidays) or to say the last Tuesday of the month. How? Quite easily. For the first Monday of the month, it is likely that even if today was the first ...; Created on 27 September 2019
9. GDPR Privacy Policy: / Static Items /; ... and trade dress may not be used in connection with any product or service that is not MYCOMPANYs, in any manner that is likely to cause confusion among customers, or in any manner that disparages or discredits ...; Created on 14 February 2019
10. Submit form as a server and not the client with cURL: / API Miscellaneous /; ... a permitted server with a single IP address. How? It's likely that you already know how to submit a HTML form to a server via your Mobile application so the following will only document the process ...; Created on 20 February 2015
11. Quadcopter App with Flight Restrictions (JQA): / Product Documentation /; ... are plans to shift this to using Google Services as they are more likely to find locations that openweathermap.org cannot. Add a comma and the two letter country code (preferably "iso-3166-1 alpha-2") ...; Created on 24 October 2014
12. mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connec: / MySQL /; ... #2 (useless fix - unlikely to change anything): Another solution has been advised that you have to tell MySQL WorkBench 6.0 to "use the old authentication protocol": • For versions before 6.0.7 ...; Created on 28 July 2014
13. ReCaptcha disappears from Joomla 2.5 Registration: / Joomla /; ... #1 I prefer this method as it changes less code and is more likely to be supported in a Joomla update. Open the file /plugins/captcha/recaptcha/recaptcha.php and find the following 3 lines of code : const ...; Created on 24 November 2013
14. Compare two databases using T-SQL: / Transact-SQL /; ... having to download any third-party products. Why? I googled and binged and all I could find were people selling third party products... they don't get it. If you are reading this, it's likely you'v ...; Created on 24 September 2013
15. Background Gradient Disappears on Long Pages: / Cascading Stylesheets /; What? This is a quick article on how to resolve the following issue: Overall body background color is blue. Background color of my contents is white. When I visit a small page on the site, the ...; Created on 20 November 2012
16. MediaWiki: MySQL to extract path to images: / MediaWiki /; ... for my own benefit as it's unlikely I'm asked for an entire export. Should yield something like: img_name img_size img_user_text img_timestamp img_path img_path_with_file ============== ============== ...; Created on 06 December 2011
17. SSRS Zero Padding: / SQL Server Reporting Services /; ... & Fields!ERROR_CODE.Value.ToString, 5) -- "Right()" to say extract text from the right -- ".ToString" because it's likely you're doing this to a number and numbers just get rounded up without the prefixing ...; Created on 10 November 2011
18. Migrate Joomla Users to WordPress: / Wordpress /; ... a ORDER BY a.id; A bit more to do: PHP file So I needed to do a loop and rather than complicate things with stored procedures and cursors, it's likely if you're using either Joomla or Wordpress ...; Created on 03 October 2011
19. Joes FREE Website Thumbnailer (JWT): / Product Documentation /; ... floppy disk/USB but will need an installed version of MS Internet Explorer on the computer it's run. If you think you don't have MSIE but you have Windows XP, it's likely you have it anyway. Open Source: ...; Created on 28 June 2011
20. Migrate Joomla! 1.5.x to 2.5.x+: / Joomla /; ... is not a silver bullet. It was created to take away the hours I know I would spend without it. This is not an upgrade; it is likely that your client may reconsider the template they are using or may ...; Created on 30 January 2011