User Manual

08.14.2024

MANUAL

FAQ: I want to cut out part of a item value and transfer it to another item in the same record

## Answer Use "[Script](/en/manual/table-management-script)". --- ## Overview Use "[Script](/en/manual/table-management-script)" if you want to transfer a value to another "[Item](/en/manual/table-management-column)" when the value of the "[Item](/en/manual/table-management-column)" changes. ## Operation Procedure 1. Create a table 1. Create a new "[Script](/en/manual/table-management-script)" and enter the following script content. Check "Create New" and "Edit" for the output destination to update 1. From the "[Editor](/en/manual/table-management-editor)", activate Classification A and Description A according to the sample code below. 1. Enter any character string in the Classification A options and press the Update button. 1. Create a new record using the [+Create New] button. 1. Select any value in Classification A and confirm that the first character is transferred to Description A. ## Sample Code ##### JavaScript ``` $(document).on('change', '#' + $p.getControl('ClassA')[0].id, function(){ //Get the value of Class A const myClassA = $p.getControl('ClassA').val(); //When Class A is changed, copy the first character of Class A to Description A //Cut off the first character from the 0th character (beginning) $p.set($p.getControl('DescriptionA'), myClassA.slice(0,1)); }); ``` ## Related Information <div id="ManualList"><ul><li><a href="/en/manual/table-management-column">Manage Table: Column</a><span>10.07.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-script">Table Management: Script</a><span>08.13.2024 up</span></li></ul></article></div><input id="SearchTextHidden" type="hidden" value="" />
TOP
このページをシェアする
記載された商品名、各製品名は各社の登録商標または商標です。 © Implem Inc.