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.