Cross Row Interactive Grid Cascading LOVs

One of my main gripes about the Interactive Grid is that it performing cross row validations is quite a painful process. By this I mean, the user can modify various records and add their own; but I want to check if the entries are valid in relation to each other before submitting to the DB. […]

APEX Interactive Grid / July 12, 2018

Read More

Adding an Auto Save Feature to an APEX Page

Recently I was tasked with adding an auto save feature to an APEX page for a questionnaire style application I was developing for a customer. The application itself was straight forward but contained a significant amount of data entry for the users. The aim was to ensure that should a user’s APEX session close unexpectedly […]

APEX, JavaScript APEX, Development, JavaScript / June 5, 2018

Read More

Disabling Interactive Grid Columns

I’ve seen various information about how to disable IG columns, either through read-only attributes, using special classes and other nifty tricks. But thinking simply about this … a column should either be conditionally removed at page load or dynamically controlled – and what should we use for dynamic controls? Dynamic Actions. There’s an example on Page […]

APEX, APEX 5.1 Interactive Grid / May 14, 2018

Read More

Integrating Chatbots with your APEX (or non-APEX) web application.

Lots of people are talking about chatbots alongside other tech buzzwords like AI and IoT. I like to look into these up and coming technologies to see what might be useful for expanding our development toolbox, and I have presented on these three topics recently at various conferences. Of all these technologies, chatbots have stood […]

APEX, Cloud, IOT chatbots / April 26, 2018

Read More

Application Support with APEX Applications: Looking After the Users when Development has Finished

Although at Explorer we spend most of our time creating brand-new bespoke APEX applications or completing Forms to APEX projects; sometimes we are asked to work on and/or support an existing APEX application, both for external clients and for our own internal systems. Having come from a more support orientated background where I have spent […]

APEX, How to, Support APEX, In House, Support, Team Development / April 18, 2018

Read More

APEX Developer Mode

When I used to work with Oracle Forms, the company I worked for used to grant users on the development environment with a special role which provided enhanced access to many areas of the system. The name of this role was called… GOD MODE. This was only ever applied to the development system and it […]

APEX Development / March 8, 2018

Read More

Interactive Grid Column Read Only Control

I thought it would be interesting to share my findings on the Read Only setting for Interactive Grid (IG) Columns. The Read Only attribute has been around for many years – so why write a blog about it in 2018? Well, something has changed with the Read Only attribute for Interactive Grid columns – here […]

APEX, Blog Interactive Grid / February 16, 2018

Read More

APEX Interactive Grid: Preventing Lost Updates & Record Locking

I was recently asked about the Interactive Grid (IG) configuration settings that are associated with Locking and Preventing Lost updates. “Aren’t they the same thing?” I was asked… Actually, no; they are not the same thing. However, they are both there to protect your data and therefore it is worth spending a little time to explore […]

APEX, Blog, How to / February 12, 2018

Read More

Introducing APEX TabLock

A little side project of mine is developing new features for a chrome extension which provides extra functionality for the APEX developer. The chrome extension is called TabLock and the name derived from its original purpose, which is to help prevent accidental movement of APEX page designer tabs. However, I am aware that this extension […]

APEX, Blog APEX, APEX 5.0, APEX 5.1, Chrome / January 17, 2018

Read More

Options For Loading Excel Data Into APEX Applications

Excel is still widely used across many organisations as a standard reporting tool, often being used as a substitute for small databases. As a consequence, it has become necessary to load Excel data into APEX applications. At the UK OUG TECH17 Conference, I introduced a number of options available to help import Excel data into APEX […]

APEX, Blog, TECH17, Why use APEX APEX, Excel / December 21, 2017

Read More

Next Page »

Featured Posts