You’re offline. This is a read only version of the page.
Announcements
50
Hi,
I am currently building an app which will filter an ADS table to return results by a selection of filters.
This is the current formula I have which will filter by a range of different fields.
However, I am requiring the Job Number field to be changed to a combo box in which users will be able to select multiple job numbers to filter by. The job number combo box will be filtered to the jobs which sit within the inputted project number. I have been unable to find a way to filter my table/collection by multiple job numbers, so currently it is set to a free text input which allows only one number to be entered.
Any help massively apprectiated.
Thanks
Hi @SamBrent ,
Items of the Job number Combo box:
Share
Report
All responses (
Answers (
Distinct(Filter(ADStable, ProjectNumber = PorjectNumberInput.Text || IsBlank(PorjectNumberInput.Text)),JobNumber)
The button to navigate to another screen:
ClearCollect(TransferLinesCol, Filter(ADStable, ProjectNumber = PorjectNumberInput.Text || IsBlank(PorjectNumberInput.Text))&& JobNumber = JobNumberCombo.Selected.Value && OtherCriteria));
Navigate(...)
Best regards,
