Hello,
I have patch function working with a toggle switch onchange property. I want to patch some info when it's switched on/off.
If(tglTowerOnHoldA.Value = true,Patch('P2 Batch Sheets',ThisItem,{'Tower On Hold':'Tower On Hold (P2 Batch Sheets)'.Yes});Set(gblOnHoldTime,ThisItem.'Tower On Hold Time');Set(gblOnHoldDate,Now()),Patch('P2 Batch Sheets',ThisItem,{'Tower On Hold':'Tower On Hold (P2 Batch Sheets)'.No,'Tower On Hold Time':locOnHoldTime,'Tower On Hold Date':Blank()}))
The default of toggle is set to be the item's on hold column value.
If(ThisItem.'Tower On Hold' = 'Tower On Hold (P2 Batch Sheets)'.Yes,true,false)
However, every time I select a different, let's say from one with on hold to a new one with not on hold, the onchange property got triggered automatically. Does anyone know a way to sort this out?
Thanks,