Hello,
I have a button to start the timer while patching some info to the database at the same time. The timer seems not working because the form got refresh after patching. However timer will work if you click on it afterwards. I want to avoid the click, I tried the select function, it doesn't work.
Button OnSelect property
If(tglTowerOnHoldA.Value=true && ThisItem.'Tower On Hold' = 'Tower On Hold (P2 Batch Sheets)'.No,Patch('P2 Batch Sheets',ThisItem,{'Tower On Hold':'Tower On Hold (P2 Batch Sheets)'.Yes,'Tower On Hold Date':Now()});Set(gblOnHoldTimeAOld,ThisItem.'Tower On Hold Time');UpdateContext({locTimeGo:true});Select(timOnHold_1),tglTowerOnHoldA.Value=false && ThisItem.'Tower On Hold' = 'Tower On Hold (P2 Batch Sheets)'.Yes,Patch('P2 Batch Sheets',ThisItem,{'Tower On Hold':'Tower On Hold (P2 Batch Sheets)'.No,'Tower On Hold Time':gblOnHoldTimeANew,'Tower On Hold Date':Blank()}),tglTowerOnHoldA.Value=true && ThisItem.'Tower On Hold' = 'Tower On Hold (P2 Batch Sheets)'.Yes,Set(gblOnHoldTimeAOld,ThisItem.'Tower On Hold Time'))
Timer set autostart as true, start as locTimeGo, repeat as true.
OnTimeEnd
Set(gblOnHoldTimeANew,DateDiff(ThisItem.'Tower On Hold Date',Now(),Seconds)+gblOnHoldTimeAOld)
Text
If(tglTowerOnHoldA.Value=true,Text(Time(0, 0,gblOnHoldTimeANew), "hh:mm:ss"),Text(Time(0, 0,ThisItem.'Tower On Hold Time'), "hh:mm:ss"))