I have an interactive grid with a dynamic action on a column. The purpose of the dynamic action is to disable certain fields when the Record Type = S.
Simplified example:
| Rec Type | Date | Code | Amount |
|---|
| S | 12/3/2019 | A25 | 55.00 |
| S | 11/1/2019 | G15 | 10.11 |
| <null> | 11/15/2019 | A25 | 79.28 |
In the above example, the Code and Amount columns should be read-only for the first two records because they have a Rec Type of S. I colored the data that should be read-only in Red, just to clarify what I'm looking for. The fields should all be enabled on the last record because the Rec Type is NULL. The Date column is enabled in either case. I set a Dynamic Action on the Rec Type column with a Client Side condition of Rec Type = S. The True action is set to disable the 2 columns and the False action is set to enable the 2 columns. This behavior is working when dealing with 1 record in the grid, however, I am running into an issue when the user updates multiple records before the Save. As an example, if I change the date on both record 1 and record 2 above and then click Save - then it completely deletes the Code and Amount for the first record. I have no idea why this is happening. It's likely that I'm doing something wrong, I just can't figure out what. Has anyone seen this behavior before and/or have a suggestion on how to fix it?