How to create a value-responsive checkbox in Oracle Apex?

I have a page with a few fields, loaded from a DB table, such as:

Name:   John Smith
ID:     jsa44
State:  MA
--Hidden--ActiveUser:yes

I want to display a checkbox that is checked when activeuser is yes and unchecked when activeuser is no. Also, I want to change the value of activeuser whenever the checkbox check status changes.

How would I do this?

Answers


Instead of having ActiveUser as a hidden item, make it a Checkbox item with these attributes:

(Note Display Extra Values set to No).

Then add a computation like this:

(My item was called P1_X). This computation handles the fact that the unchecked value of a checkbox is always NULL, converting that to 'no'.


Need Your Help

Intellij 14 the supplied javaHome seems to be invalid

intellij-idea libgdx

When first launching IntelliJ IDEA Community Edition 14.0.2 on Windows 7 x64 I received the following error when trying to import the sample libGDX gradle config:

TypeError: get_appsettings() got an unexpected keyword argument 'options'

python sqlalchemy pyramid

I am new to pyramid and have checked out a code that I am trying to run locally the error that it shows so far is

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.