Android: Function to let user take photo or choose existinghttps://joellipman.com/articles/google/androidos/android-function-to-let-user-take-photo-or-choose-existing.html

04 November 2014 */ static final int REQUEST_IMAGE_CAPTURE = 1; private static int RESULT_LOAD_IMAGE = 1; private static int TAKE_OR_PICK = 0; public void chooseOrTakePhoto(View view) { final View v = getLayoutInflater().inflate(R.layout.dialog_edititem_photo, null);...

• Type: Article
• Author: Joel Lipman
• Category: AndroidOS
• Language: *

Search a database with SOUNDEXhttps://joellipman.com/articles/database/search-a-database-with-soundex.html

11 October 2012 ** ** @minStringLength and @maxStringLength are calculated based on original value. ** ** ** ** Issues : ** ** Will pick up variations with trailing spaces but this is not easily recognized from the results ** ** ** ** Only finds the first...

• Type: Article
• Author: Joel Lipman
• Category: Databases
• Language: en-GB

Apple Magic Trackpad with Windows 11 Intelhttps://joellipman.com/articles/microsoft/windows-os/apple-magic-trackpad-with-windows-11-intel.html

20 October 2025 these without needing software. Long rant to justify why I didn't want to drive home (~20 to 40 minutes commute) and pick up my laptop. How? The work and research for this was all in one YouTube video by LinxHype...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Forum Ruleshttps://joellipman.com/static-items/forum-rules.html

31 May 2009 catagory you insult. TEU is a place where everyone is equal, and discrimination will NOT be tolerated! No Bullying - Do not pick on other members. The worst kind of bullying is where new members are picked on. This hurts the member as well as the board....

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Installing phpBB3 for Joomla with a RocketTheme templatehttps://joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

28 September 2009 phpbb3 style. I say it's a big step because RocketTheme assume that you just upload the affinity folder and phpBB3 will pick this up when you install it via the Administration Control Panel (ACP)... But for us, it wasn't that easy. Make a backup of your...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *

Passwords: Did-you-knowhttps://joellipman.com/hardware/passwords-did-you-know.html

15 November 2010 company hired to hack the client’s network simply drops loads of free nice USB flash drives in the parking lot. Employees pick them up and plug them into their machines at work which then sends the details over the internet. Apparently this has a 9 in...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

MySQL last year week month day trend periodshttps://joellipman.com/articles/database/mysql/mysql-last-year-week-month-day-trend.html

31 October 2011 past day, week, month and year (the below examples count all accounts irrespective of being activated or not). It needs to pick up trends as well and compare for example todays, with yesterdays up to the same hour. How? I used to use a lot more PHP but...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

Performance Report - Background colors based on dataset valueshttps://joellipman.com/articles/microsoft/ssrs/green-red-background-colors-based-on-dataset-values.html

02 December 2011 these datasets, parameter options should be that the Name is the "Label" and ItemID is the "Value", just in case you didn't pick up on this. If no type is specified (type=2) then datasources and folders will also show. The Side-by-Side Table As you...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

CSS Printing - Page Break Inside with Headers and Footershttps://joellipman.com/articles/web-development/css/css-printing-page-break-inside-with-headers-and-footers.html

22 February 2019 page has a table which is of variable length. Fine when the table was short and didn't have many rows. But the client will pick up the phone to you when the table has too many rows to fit on one page, and this overlaps onto the next, covering the footer...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

Zoho Deluge: Duplicate/Clone a Recordhttps://joellipman.com/articles/crm/zoho/zoho-deluge-duplicate-clone-a-record.html

17 March 2020 you do it in CRM: Login to Zoho CRM as an administrator and go to Setup Under Developer Space click on "Connections" Under Pick your Service click on "Zoho OAuth" (NOT "Zoho" - there are 2 Zoho options) Give the connection a name such as...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng)https://joellipman.com/articles/crm/zoho/zoho-crm-deluge-get-timezone-based-on-geocoded-address-lat-lng.html

15 December 2021 a free TimeZone API (one that returns a timezone given a lat/lng). The added feature is that we are going to loop through picklist options (500 timezones) in CRM to select the most relevant one. If all this fails, then it defaults to a module called...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoRecruit: Create Linking Table for Candidates and Associated Job Openingshttps://joellipman.com/articles/crm/zoho/zohorecruit-create-linking-table-for-candidates-and-associated-job-openings.html

08 February 2023 or Edit a function At the top of the IDE there will be a "Connections" link to click on. Click on "Create Connection". Pick the service (eg. "Zoho OAuth"). Enter the connection details and scope. Error(s) Encountered: {"code":"4401","message":"Unable to...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM: Integrate ChatGPT to ZohoZIAhttps://joellipman.com/articles/crm/zoho/zohocrm-integrate-chatgpt-to-zohozia.html

06 March 2023 called "GPT Chats" (singular: GPT Chat) Modify the name field to be an Auto-Number (I'm prefixing mine with CHAT- Add a pick list called "Role" with the options: "user", "assistant", "system". Add a file upload field called "Big Data" Add a single line...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *