User Manual

10.01.2024

MANUAL

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」" (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: Column: Status</a><span>10.02.2024 up</span></li></ul></article> <ul><li><a href="/en/manual/table-management-editor">Table Management: Editor</a><span>08.13.2024 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="" />
TOP
このページをシェアする
記載された商品名、各製品名は各社の登録商標または商標です。 © Implem Inc.