How do I force rows added from a slice to conform to the slice selection criteria? For instance, if the slice only includes rows for customer A, how do I automatically set the customer to A for rows added from the slice? One way would be to only allow a new row if the customer is already present in the slice, but Iโd like a method that works with an empty slice.
We can do this in specific cases but not in the general cases.
Example 1: the slice filter is [Col1] = 5
---- if you create a new entry in this slice, we know we can set Col1 to 5
Example 2: the slice filter is [Col1] > 5
โ now we cannot
Example 3: the slice filter is [Col1] != โCompleteโ
Example 4: the slice filter is OR([Col1] = 5, [Col2] = 7)
You see the problem in general. However, I think for the specific (and perhaps common) cases where it can be unambiguous, we should do it.
@praveen it seems like it could get crazyโฆ Almost like itโs a validif scenarioโฆ The multiple column scenario is starting to mess with my mindโฆ LOL
User | Count |
---|---|
41 | |
28 | |
24 | |
24 | |
13 |