FAQ: Automatically specify the progression rate based on the status column value
## Answer
Use "[Server Script](/en/manual/table-management-server-script)".
---
## Overview
Use "[Server Script](/en/manual/table-management-server-script)" to automatically specify the progression rate according to the value selected in the "[Status](/en/manual/table-management-status)" column in the bulk edit mode of the edit screen and Screen Index. The corresponding progression rate in the sample introduced on this page is specified according to the code assigned to the "[Status](/en/manual/table-management-status)" column as shown in the table below.
|Code|Option|Progression rate|
|:---|:---|:---|
|150|Preparation|10%|
|200|Running|50%|
|300|Under Review|90%|
|900|Done|100%|
|(Not selected)|Other|0%|
## Operation
1. Create a "Time-limited Table".
1. Enable "[Status](/en/manual/table-management-status)" and "Progression Rate" in "[Editor](/en/manual/table-management-editor)" and "[Index](/en/manual/table-management-grid)" (they are usually enabled).
1. "Create new" the following "[Server Script](/en/manual/table-management-server-script)". For "「Condition」", select "After Formula".
## Sample Code
##### JavaScript
```
switch (model.Status) {
case 150: // Preparation
model.ProgressRate = 10;
break;
case 200: // Running
model.ProgressRate = 50;
break;
case 300: // Under Review
model.ProgressRate = 90;
break;
case 900: // Done
model.ProgressRate = 100;
break;
default: // Other
model.ProgressRate = 0;
break;
}
```
## Related Information
<div id="ManualList"><ul><li><a href="/en/manual/table-management-status">Manage Table: Items: Status</a><span>12.09.2025 up</span></li></ul></article>
<ul><li><a href="/en/manual/table-management-editor">Manage Table: Editor</a><span>12.09.2025 up</span></li></ul></article>
<ul><li><a href="/en/manual/table-management-grid">Manage Table: Screen Index</a><span>08.13.2025 up</span></li></ul></article>
<ul><li><a href="/en/manual/table-management-server-script">Table Management: Server Script</a><span>08.13.2024 up</span></li></ul></article></div><input id="SearchTextHidden" type="hidden" value="" />
