Is it possible to "Add on the fly" based on a condition?

I have a form where I’m needing to add a vehicle on the fly from a field but the Add capability should only be available if another field in the row is set to a certain value (If Receive From = Trailer).

I tried creating 2 slices - one that allows Add and the other does not allow the Add. At the Vehicle (Truck) field, I kept the Source table as the name of the table but updated the Valid If to the following:

IF([Receive From]=VEH_TRAILER,
SELECT(
vehicles_add[vehicle_rec_id],
OR(AND([Division]=[_THISROW].[Division],[Type]=[_THISROW].[Receive From],[Status]=Active),[vehicle_rec_id]=“OTHER”)
),
SELECT(
vehicles_no_add[vehicle_rec_id],
OR(AND([Division]=[_THISROW].[Division],[Type]=[_THISROW].[Receive From],[Status]=Active),[vehicle_rec_id]=“OTHER”)
)
)

It unfortunately still includes the “Add” button when user presses the Vehicle field regardless of the slice we use for validation. Any ideas?



0 2 124
2 REPLIES 2
Top Labels in this Space