Hello all,
Been hitting this app kind of hard lately - ran into another issue and its quite possibly my logic here. Want the App dropdown "B211INBOUND" to check if there is already a value on the B211 "Spot" and if there is - force the B211OUTBOUND to auto-populate that for the user so they cant 'accidentally' spot two railcars at the same time in my app. Added some screenshots to help understand. Hoping maybe my logic below is just .. off
If(!IsBlank(LookUp('374 Staged', Status.Value = "FULL" )),
Switch(
B211OUTBOUND.Selected.Railcar, LookUp('374 Staged', Track = "B211", Railcar),
B211OUTBOUND.Selected.Railcar = Railcar
),
//Patch('374 MECL',
//LookUp('374 MECL', Railcar = B211INBOUND.Selected.Railcar),
//{Spot: {Value: "B211-1"}}
//),
!IsBlank(B211INBOUND.Selected.Railcar),
Patch('374 Staged',
LookUp('374 Staged', Track = "B211-1"),
{Railcar:B211INBOUND.Selected.Railcar,
Status:{Value:"FULL"}}
);
Patch('374 MECL',
LookUp('374 MECL', Railcar = B211INBOUND.Selected.Railcar),
{Spot: {Value: "B211-1"}}
)
);
