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