Share
Report
341Hello,
I am still having a lot of trouble trying to get my function to work to have my search box filter by part number or order number.
Currently, my search box only filters by order number and works great, however I need to have it also search and filter by part number.
Below is my current function which works great but need to fit in the search/filter by part number. how do I fit that into the below?
Search(
DropColumns(
SortByColumns(
AddColumns(
Switch(
btnChoice,
Vertical_1,
Filter('Production Stoppage - DRAFT 1', "Vertical" in Area.Value),
Vertical_1,
Filter('Production Stoppage - DRAFT 1', "Material Handling Vertical" in Area.Value),
Modified_1,
Filter('Production Stoppage - DRAFT 1', "Modified" in Area.Value),
QuickShip_1,
Filter('Production Stoppage - DRAFT 1', "Quick Ship" in Area.Value),
Machining_1,
Filter('Production Stoppage - DRAFT 1', "Machining" in Area.Value),
Machining_2,
Filter('Production Stoppage - DRAFT 1', "Machining" in 'Forward To'.Value),
Repairs_1,
Filter('Production Stoppage - DRAFT 1', "Repair" in Area.Value),
Horizontal_1,
Filter('Production Stoppage - DRAFT 1', "Horizontal" in Area.Value),
Horizontal_1,
Filter('Production Stoppage - DRAFT 1', "Material Handling Horizontal" in Area.Value),
Shipping_1,
Filter('Production Stoppage - DRAFT 1', "Shipping/Receiving" in Area.Value),
Submersible_1,
Filter('Production Stoppage - DRAFT 1', "Submersible" in Area.Value),
MaterialHandling_1,
Filter('Production Stoppage - DRAFT 1', "Material Handling Vertical" in Area.Value),
MaterialHandling_1,
Filter('Production Stoppage - DRAFT 1', "Material Handling Horizontal" in Area.Value),
MaterialHandling_1,
Filter('Production Stoppage - DRAFT 1', "Material Handling Submersible" in Area.Value),
PaintBooth_1,
Filter('Production Stoppage - DRAFT 1', "Paint Booth" in Area.Value),
PaintBooth_1,
Filter('Production Stoppage - DRAFT 1', "Paint Issue" in Issue.Value),
Sunland_1,
Filter('Production Stoppage - DRAFT 1', "Sunland" in Area.Value),
Warren_1,
Filter('Production Stoppage - DRAFT 1', "Warren" in 'Pump Size'.Value),
ORE_1,
Filter('Production Stoppage - DRAFT 1', "ORE" in Responsibility),
ORE_2,
Filter('Production Stoppage - DRAFT 1', "Engineering" in 'Forward To'.Value),
Logistics_1,
Filter('Production Stoppage - DRAFT 1', "Logistics" in Responsibility),
Logistics_2,
Filter('Production Stoppage - DRAFT 1', "Logistics" in 'Forward To'.Value),
Purchasing_1,
Filter('Production Stoppage - DRAFT 1', "Purchasing" in Responsibility),
Purchasing_2,
Filter('Production Stoppage - DRAFT 1', "Purchasing" in 'Forward To'.Value),
Quality_1,
Filter('Production Stoppage - DRAFT 1', "Quality" in Responsibility),
Quality_2,
Filter('Production Stoppage - DRAFT 1', "Quality" in 'Forward To'.Value),
Meriden_1,
Filter('Production Stoppage - DRAFT 1', "Meriden" in Responsibility),
Meriden_2,
Filter('Production Stoppage - DRAFT 1', "Meriden" in 'Forward To'.Value),
Rework_1,
Filter('Production Stoppage - DRAFT 1', "Rework" in Disposition.Value),
Machining_3,
Filter('Production Stoppage - DRAFT 1', "Machining (General Use)" in Issue.Value),
ProjectManagement_1,
Filter('Production Stoppage - DRAFT 1', "Project Management" in 'Forward To'.Value),
'Pump DR_1',
Filter('Production Stoppage - DRAFT 1', "Submersible Pump Doctor" in 'Forward To'.Value),
ShowAll_1,
Filter('Production Stoppage - DRAFT 1', "" in Area.Value),
'Production Stoppage - DRAFT 1'
),
sortMe, If(Status.Value="Open",0,1)
),
"sortMe", SortOrder.Ascending),
sortMe),SearchBox_3.Text,'Order No')
All responses (
Answers (
