Android: Replace return key with done, go, send...https://www.joellipman.com/articles/google/androidos/android-replace-return-key-with-done-go-send.html

03 November 2014 will change the keyboard layout (eg. Numbers) text // Normal text textNoSuggestions // No suggestions/autocorrect textEmailAddress // valid email address textPersonName // name of a person textPostalAddress // standard postal address textPassword //...

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

MS Excel - Split Workbook into separate files per sheethttps://www.joellipman.com/articles/microsoft/excel/ms-excel-split-workbook-into-separate-files-per-sheet.html

11 February 2019 Set WorkRng = Application.Selection Set WorkRng = Application.InputBox("Specify Data Range", xTitleId, WorkRng.Address, Type:=8) SplitRow = Application.InputBox("Specify Num Rows per Sheet", xTitleId, 5, Type:=1) Set xWs = WorkRng.Parent Set xRow =...

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

Zoho Creator: Receive eBay Order Notifications via Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-receive-ebay-order-notifications-via-webhook.html

20 September 2021 = "SetNotificationPreferences"; // // specify the URL of the CRM REST API Function here (can be a mailto:email@address) v_CrmRestFunction =...

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

Zoho Webhooks & Shopify API: Keep Disappearinghttps://www.joellipman.com/articles/crm/zoho/zoho-webhooks-shopify-api-automatically-restore.html

22 April 2024 { m_Webhook = Map(); m_Webhook.put("format","json"); m_Webhook.put("topic","orders/updated"); m_Webhook.put("address",v_CrmOrderUpdateWebhook); m_Params = Map(); m_Params.put("webhook",m_Webhook); // v_Endpoint = "https://" + v_ShopifyID + "/admin/api/"...

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

Zoho Analytics: Create a Monitoring System with Imageshttps://www.joellipman.com/articles/crm/zoho/zoho-analytics-create-a-monitoring-system-with-images.html

25 July 2024 Google Chrome and select "Duplicate"). I then arranged the two browser windows side-by-side so that I could copy the image address from the library to the 2nd column in my data table. So in the duplicate browser, go to modify a widget again and get to...

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

Joomla - How to preview module positions in a given templatehttps://www.joellipman.com/articles/cms/joomla/joomla-how-to-preview-module-positions-in-a-given-template.html

02 April 2010 are, like USER 1 and TAB 4 etc..." To open a web-browser window or tab with this preview, type the following in the address bar after your website URL: http://www.yourdomainname.com/index.php?tp=1&template=thetemplatename where yourdomainname.com is...

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

Zoho Deluge - Get User Timezone, Country and Locationhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-user-timezone-country-and-location.html

03 June 2019 A quick article just as a note to get the users country information from a third-party API based on the given IP address. How? Well this is just a list of free 3rd-party APIs and the below code is dependent on these being online and working... The...

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

Zoho CRM: Client Script Confirmation Box and Popup Mailerhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-client-script-prompt-and-popup-mailer.html

06 February 2024 ticked/checked=true Popup a confirmation box to proceed or cancel. Popup the email from CRM mailer with the to email address, bcc, subject and message content already populated. How? The example from the Kaizen series uses a record with canvas mode...

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

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

31 May 2009 to create more than one thread per topic. No Posting Personal Info - You may not post your last name, or your street address on TEU. This is because this information then becomes accessible to anyone. No Threatening to Leave the Board - Due to past...

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

View your available module positionshttps://www.joellipman.com/articles/cms/joomla/view-your-available-module-positions.html

15 September 2009 your template Click on the big Preview button in the top right Click on the link 'Show in New Window' Bookmark the web address of the new window The bookmark/favorite that you have just made can be refreshed when you change things on your site and...

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

Community Builder in Joomla Vulnerabilityhttps://www.joellipman.com/articles/cms/joomla/community-builder-in-joomla-vulnerability.html

10 November 2009 For detailed information about the problems with this site, visit the Google Safe Browsing diagnostic page for this address I understand that visiting this site may harm my computer. Continue? Even if you use the latest versions of Community Builder...

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

Webdeveloper-Speakhttps://www.joellipman.com/articles/web-development/webdeveloper-speak.html

13 July 2010 outcome. typosquatter A typosquatter is a company/individual that registers the misspelling of a popular website address, either to increase advertising revenue or as a form of parody/social criticism. initialism An initialism is a phrase or multi-word...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

SQL Queries for Statisticshttps://www.joellipman.com/articles/database/mysql/sql-queries-for-statistics.html

13 December 2010 University Knowledge Base. The skin itself is the index page loaded for any page in the Wiki system. It logs the IP address (VisitorIP), the URL (VisitorURL) entered via the browser useragent (VisitorUAgent), the User ID (VisitorID, 0 if not logged in)...

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

Accessing a MySQL Database with Business Intelligence Development Studiohttps://www.joellipman.com/articles/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

05 January 2011 be some long winded text that very few will ever use TCP/IP Server is the server name (without the DNS suffix) or the IP address of the server Port should be 3306 by default User is the mysql username Database is your selection and should auto-populate...

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

Win32 Constantshttps://www.joellipman.com/articles/automation/autohotkey/win32-constants.html

05 July 2011 = $2000 ;// If Not set display names For shell name space items that are Not in the file system will fail. Const SHGDN_FORADDRESSBARConst = $4000 ;// For displaying in the address (drives dropdown) bar Const SHGDN_FORPARSINGConst = $8000 ;// For...

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

Joes Bug Tracker (JBT)https://www.joellipman.com/component/content/article/joes-bug-tracker-jbt.html?catid=40

07 July 2011 (Self, Email, Phone, System) --- Customer Name --- Customer Ref/JUser ID (Joomla! registered user or email address?) --- Priority (High, Medium, Low - configurable in settings) --- Impact (free-text message by developers -> who does this affect?) ---...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Sort order a dropdown list in MS InfoPath without programminghttps://www.joellipman.com/articles/microsoft/infopath/sort-order-a-dropdown-list-in-ms-infopath-without-programming.html

21 July 2011 click on Add Select "Create a new connection to" and then Receive Data Select SharePoint library or list Copy the URL/web address from your browser which has the datasheet open (eg....

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

SSRS External Images don't displayhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-external-images-dont-display.html

19 September 2011 these photos on our Intranet and we only want one location to upload the photos. These images are provided via a website address (http) or network share (file). Before you ask, we have several MS Sharepoint sites but we didn't go down the route of...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

Joes DNS Correction (JDC)https://www.joellipman.com/component/content/article/joes-dns-correction2.html?catid=40

25 November 2011 is no install process, it should just start) 3) Done! ChangeLog: v1.0 (22/11/2011) - Display internal and external IP address - Display flushdns errorlevel - Display registerdns errorlevel - Change color to green if successful, red if failed. License...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Licence GNU/GPLhttps://www.joellipman.com/static-items/licence-gnugpl.html

03 April 2009 such as semiconductor masks. “The Program” refers to any copyrightable work licensed under this License. Each licensee is addressed as “you”. “Licensees” and “recipients” may be individuals or organizations. To “modify” a work means to copy from or...

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