Filter(
["C =Customer Mix w/Stock", "D = Damaged Product", "O =Over(Shipped)", "P =Product Missing", "S = Short (Shipped)", "UP = Unsatisfactory Packaging", "NP =No Paperwork", "NL"],
!(IsBlank(ThisItem.'Item ID Shipped') || ThisItem.'Issue Code' = "NP") || Value <> "NL" )
If(
ThisItem.'Issue Code' = "NP",
ThisItem.'Issue Code',
If(
IsBlank(ThisItem.'Item ID Shipped'),
ThisItem.'Issue Code',
"NL"
)
)
Patch(
collection1,
LookUp(
collection1,
Helper = Gallery5.Selected.Helper
),
{
'Arrival Time': DataCardValue6.Text,
'Departure Time': DataCardValue7.Text,
'Qty Ordered': DataCardValue8.Text,
'Qty Received': DataCardValue10.Text,
'Qty Shipped': DataCardValue11.Text,
'Serial Number': DataCardValue12.Text,
'Service Failure': Switch(
Checkbox5.Value,
true,
"Yes",
"No"
),
'Customer Failure': Switch(
Checkbox6.Value,
true,
"Yes",
"No"
),
Comments: DataCardValue15.Text,
'Issue Code':
Left(Dropdown1.SelectedText.Value, 1)
})
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.