Skip to content

Control by Status

Overview

By using the "Control by Status" function, you can set read-only for each record according to the status, and set "Input Required", "Read Only", or "Hidden" for each column. You can also set "Condition" and "Access Control" that enable "Control by Status".

Limitations

  1. The "Hidden" setting of the "Control by Status" function hides the display in the UI, but the target column exists in HTML. If you want to hide the column from HTML as well, use "Column Access Control".
  2. The read-only and required input settings in the "Control by Status" feature are ignored when registering or updating data via "Import", "Bulk Update", or API.
  3. When "Read only" in "Record control" is turned on, records with the status specified in "Status" become read-only. Even if you change "Status" to that status on the edit screen, the record becomes read-only at the moment you change it. Therefore, when you click the "Update" button, the error "You do not have permission to perform this operation." is displayed and the record cannot be updated.
  4. Site management permissions are required to configure this feature.

Setting Procedure

  1. With the table in question open, click "Manage" - "Manage Table" from the navigation menu.
    Navigation menu with Manage - Manage Table

  2. Click the "Control by Status" tab from Manage Table to open it.
    Control by Status tab of the Manage Table screen

Settings

Click the New button and set "Control by Status".

Common Settings - General Tab

General tab of the Control by Status settings

Common Settings

Column Name Description
Name Set an arbitrary name.
Status Set the status to be subject to "Control by Status". *１
Description Set an arbitrary description.
Disable Disables the "Control by Status" feature.

*１　The "Control by Status" setting will be enabled depending on the status. Also, specifying * will enable it for all statuses.

Record Control

Check to make the record read-only.

Column Control

Set each column as "Input Required", "Read Only" or "Hidden".

Button Description
None Resets the "Input Required", "Read Only" or "Hidden" setting for the target column.
Required If the status set in "Status" is met, the target column will be "Input Required".
Read-only If the status set in "Status" is met, the target column will be "Read Only".
Hidden If the status set in "Status" is met, the target column will be "Hidden".

Condition Tab

Set the conditions to enable "Control by Status".

Condition tab of the Control by Status settings

Select the target column from the column pull-down menu, add it and set the condition.

Access Control Tab

Set the "Department", "Group", and "User" for which you want to enable "Control by Status".

Access Control tab of the Control by Status settings

Select and add the target users/departments/groups from Option list.

Configuration Example

For examples of using "Control by Status", please refer to the following FAQ.
FAQ: Using control by status to change the status of column, such as hiding them or making them read-only

Supported Versions

Supported Version Description
1.3.12.0 and later Feature added
1.3.13.0 and later Support for *(All statuses) specification in status items
1.5.0.0 and later Added "Disabled" option