Forum Discussion

RobertHarrison's avatar
RobertHarrison
Qrew Trainee
9 days ago
Solved

Trying to create a report with an ask users filter, but with a multiselect

There are two relevant tables for this report, 'Parts' and 'Part Requests'. The Parts table is just a list of all available parts with their available stock, and the Part Requests fields include 'Rel...
  • MarkShnier__You's avatar
    MarkShnier__You
    8 days ago

    Further to Don's response above, I have two additional suggestions.

     

    Further to Dan's response above, I have two additional suggestions.

     

    The first is, if you make a summary report, you can summarize the total of the parts requested, and also an average of the available parts. Because the quantity available as a look up from the part number is the same for every part number that's the same the averageof that will give you the current inventory of that part.

     

     of that will give you the current inventory of that part.

     

    The other tip is that if you make the ask, the user filter on project number "contains", then the user can enter the project number separated by OR in upper case.

    that would allow the user to provide a list of multiple project numbers all summarized on the same report.

     

    There is another approach which requires a bit more setup where the user would just freeform type project numbers into an input box and press a button and see an embedded report of the results.  Let me know if you want more detail details about that approach.