i have a requirement of displaying a straight table of 7 columns in which 2 column values are dynamically changed based on one input box.
I set formulas for these 2 columns as Col1 * (Col1 * inputboxval / 100). this formula is working fine if i do this operation for all rows.
i have material filter if i select one material and enter any value in input box this formula executed and table columns are updated. But if i remove this material filtration selection(With intention to show all materials), updated value in input box is applies to all (material) rows. (Please check the attached file)
So i decided to put one Apply button. and want to execute some VBScript to do this functionality.
My problem here is how can i bind data to straight table dynamically using VBScript ..?
First i applied value 20 to all materials using input box (00.16 sec in video).
Then i want to apply 10 to material MAT-001 so i selected mat-001 and entered 10 in input box
Now i want to see all materials so i cleared filter. This time inputbox value 10 is applied to all materials. i Don't want this 10 to all materials now. i planned to put one button apply. but i couldn't find a way to set table cell value using macro also. So i decided to handle this functionality in load logic. is it possible ?