Hi All,
I have a requirement to add a new column to an editable grid. Each cell of a column should hold 2 values in 2 lines. Sample example shown below.
Here we can consider 1 and 2 as Levels ,10% and 20% as Discounts.
In addition to this, I have requirement to keep Levels in the drop down list and display discount based on the levels selected in the same cell. We have a pre-defined values of Discounts for corresponding Levels as shown below.
Levels Discounts
1 10%
2 20%
3 30%
The editable grid should look something similar to this.
This means, I should be able to change the level of Row1 to either 2 or 3 and based on the selection corresponding discount i.e. 20% or 30% should be displayed in the same cell below the Levels.
Is there any possible way to achieve this requirement?
Thanks in advance
Beena V
Discussion posts and replies are publicly visible
Hi Beena,
You can use a text field with char(10) to put 1 and 10% on different lines. However, it is not possible to have half of a cell be a drop down, and half be read only. You would need to separate those into different cells/rows.
The image below is an example of how to complete your first requirement: