How do I force rows added from a slice to con...

(Steven Coile) #1

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.

(Praveen Seshadri (AppSheet)) #2

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.

@Adam_Stone_AppSheet FYI

(Grant Stead) #3

@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