APEXblog.nl - Tips and Tricks

About This Blog:
I (Richard Weug) started this blog primary for myself to save all kinds of Apex tips and tricks in one place. To use it as a place to write down how I used some coding in my own projects, but also to copy and paste all kinds of articles I find on the Internet. (So I never have to wonder on what website did I read about??? When I see something interesting I collect the content so I have my own archive/knowlegde base.

View my profile on LinkedIn


Tips & Tricks


Simple Checkbox

Written by Richard Weug on Friday, 10 February 2012 11:28. Posted in Tips and Tricks

Today I was struggeling with checkboxes.

In my situation, I have 4 checkbox questions  (Yes/No)  but I only want to show 1 checkbox (checked= Y else N)
For every checkbox I had a LOV query as:  select '' d   , 'Y' r    from   dual
In a computation I would make the checkbox have the value 'N' when the value of the checkbox was still Null.
Everything works fine,.. until you want te create a dynamic action...

I try tro create a dynamic action so that when two specific checkboxes of the four in total were checked,.. it has to show an item and a button,
but I cannot get this fully to work properly.

When I check one of the checkbox,.. I get to see the button,.. that's Okay
When I uncheck the checkbox, it hides the button,.. that's Okay
When I check two checkboxes,.. it shows the button,... but then when I uncheck 1 of the 2 checkboxes,.. the button is hidden!!
The button should only be hidden when BOTH checkboxes are unchecked

I must be something simple I guess,.. has anyone got an idea about this ??
Please read on to see the dynamic actions too.....


Compare before and after values

Written by Richard Weug on Thursday, 09 February 2012 16:42. Posted in Tips and Tricks

On OTN I found an article what makes it very simple to compare to values (before and after)

On a form you create an item which is hidden.
On page load,. you run a computation, that returns the value of a field into the hidden field


Adding help text to column headings

Written by Richard Weug on Monday, 23 January 2012 12:34. Posted in Tips and Tricks

There is no out of the box solution for adding help text to column headings in a tabular form. One way is create custom table where you store your help text. Then modify/copy report template and add JavaScript that fetch using Ajax call help text for your column.

Original article:  http://dbswh.webhop.net/dbswh/f?p=BLOG:READ:0::::ARTICLE:101800346715341




Create a calendar with week numbers

Written by Richard Weug on Monday, 23 January 2012 09:11. Posted in Tips and Tricks

When you use the built-in jQuery UI datepicker in your APEX page, you choose from a number of different format masks...but something with "week" is not one of them. And guess what I needed for recent project...
But, the good news is, you can (rather easy) use the jQuery framework to tweak the result that's returned from the datepicker.


Create editable HELP

Written by Richard Weug on Tuesday, 14 June 2011 13:25. Posted in Tips and Tricks

Editable Help
I have now delivered a number of Apex applications into production and have to say that as much as I like the item help functionality in Apex, I have never actually taken the time to fill each item with anything particularly useful. The Apex team are as bad with their item help which usually re-words the the label text. A better solution would be to have the ability to edit the item help whilst the application is in production, thus allowing users to add their own help information when required.