In this step by step tutorial for beginner, weโll guide you through the process of using the OnGridColumnValueChanged event to tailor calculations for your business operations. This event is particularly useful in scenarios like a Sales Module, where you need to automate the calculation of amounts based on your business-specific requirements.
๐๐ก๐๐ญ ๐ข๐ฌ ๐ญ๐ก๐ ๐๐ง๐๐ซ๐ข๐๐๐จ๐ฅ๐ฎ๐ฆ๐ง๐๐๐ฅ๐ฎ๐๐๐ก๐๐ง๐ ๐๐ ๐๐ฏ๐๐ง๐ญ?
๐ OnGridColumnValueChanged event triggers the script whenever a value of a cell or column in a grid (such as a data grid or table) is changed.
๐๐ฎ๐ญ๐จ๐ซ๐ข๐๐ฅ ๐๐๐ฃ๐๐๐ญ๐ข๐ฏ๐
๐ We will show you how to write a DIY Script using the OnGridColumnValueChange event for travel agency business, such that it can be used to auto calculate the amount charges for hotel room.
๐
๐จ๐ซ๐ฆ๐ฎ๐ฅ๐ ๐๐จ๐ซ ๐๐ฎ๐๐ญ๐จ๐ญ๐๐ฅ ๐๐๐ฅ๐๐ฎ๐ฅ๐๐ญ๐ข๐จ๐ง
๐ The formula for the Sub Total Amount is =(Room Rate Per Night)ร(Number of Nights)ร(Number of Rooms) – Discount
๐๐๐ฌ๐ฎ๐ฅ๐ญ
๐ The result of this script would achieve is whenever the user changed the value in the fields of Qty, Price, Night, and Discount, the amount will follow the formula and change accordingly.
๐๐ข๐ฆ๐ ๐๐ญ๐๐ฆ๐ฉ๐ฌ
00:00–00:45 Introduction
00:46–01:42 Create DIY Field
01:43–02:11 Why need to create DIY Fields
02:12–04:43 Function and Procedure
04:44–05:09 SameText Procedure and Editing Field
05:10–05:50 Field Name and Data Type
05:51–06:26 Main Function
06:27–07:18 Compile Script
07:19–07:32 Show Message Procedure
07:33–07:42 Ending Demo
