Hello,
Trying to build an 'inventory list' to track items basically. For this, i am certain my current process is flawed and was hoping someone may be able to point out my issues. Sometimes the trailer when 'swapped' is pulling incorrect info and rather slow to update. Hoping it is something simple I am overlooking? It currently works - although is slow and my current formulas are pretty error prone. I am hoping someone out there is able to help simplify the process and make it work better?
Currently, the drop downs concencate any other 'door' that currently has a trailer value as "OPEN" to find the correct trailer based on ID
Basically, each item has its own submit button and code is as follows
DropDown
If('374B1'.Text = "OPEN", Distinct(Filter('Trailer Tracking', Trailer.Value <> "OPEN"),Concatenate(Building.Value," - ", Dock.Value," - ", Trailer.Value," - ", Comments, Text(ThisRecord.ID))),Distinct(Filter('Trailer Tracking',Trailer.Value="OPEN"),Concatenate(Building.Value," - ", Dock.Value," - ", Trailer.Value, " - ", Comments, Text(ThisRecord.ID))))
Submit Button
ClearCollect( TrailerSwap,
{
SelectedBuilding: Trim(First(FirstN(Split('374B1Choice'.Selected.Result, " - "),1)).Result),
SelectedDock: Trim(Last(FirstN(Split('374B1Choice'.Selected.Result, " - "),2)).Result),
SelectedTrailer: Trim(Last(FirstN(Split('374B1Choice'.Selected.Result, " - "),3)).Result),
SelectedComments: Trim(Last(FirstN(Split('374B1Choice'.Selected.Result, " - "),5)).Result),
SelectedID:Trim(Last(FirstN(Split('374B1Choice'.Selected.Result, " - "),4)).Result),
CurrentID: LookUp('Trailer Tracking', '374B1'.Text = Trailer.Value , ID),
CurrentTrailer: '374B1'.Text,
CurrentBuilding: LookUp('Trailer Tracking', '374B1'.Text = Trailer.Value, Building.Value),
CurrentDock: LookUp('Trailer Tracking', '374B1'.Text = Trailer.Value, Dock.Value),
CurrentInspection: LookUp('Trailer Tracking', '374B1'.Text = Trailer.Value, 'Inspection Date'),
CurrentComments: LookUp('Trailer Tracking', '374B1'.Text = Trailer.Value, Comments)
}
);
Patch('Trailer Tracking', LookUp('Trailer Tracking', Text(ID) = First(TrailerSwap).SelectedID),
{Dock: {Value: First(TrailerSwap).CurrentDock}},
{Building: {Value: First(TrailerSwap).CurrentBuilding}},
{Status: {Value: Dropdown374B1.Selected.Value}},
{Comments: First(TrailerSwap).CurrentComments}
);
Patch('Trailer Tracking', LookUp('Trailer Tracking', ID = First(TrailerSwap).CurrentID),
{Dock: {Value: First(TrailerSwap).SelectedDock}},
{Building: {Value: First(TrailerSwap).SelectedBuilding}},
{Status: {Value: Dropdown374B1.Selected.Value}},
{Comments: First(TrailerSwap).SelectedComments}
);


Report
All responses (
Answers (