Once you have inserted the DataView macro on to your page, you can give your users the option to Search the data using the 'DataViewSearch' macro
To do this, search for the DataViewSearch macro by clicking on Insert > Other Macros
...or by typing in 'DataViewSearch' into the macro shortcut
Once you have the DataViewSearch macro inserted on to you page, click on it once and then select 'Edit' (or double click on it)
You can then specify which columns you want to include in the Search. You do this by
- selecting the sheet containing the data (this defaults to 0, which is the first sheet in your Excel file)
- then selecting the columns in that sheet, to which you wish to restrict the Search
This will insert the column header above the search box on your page (as in example below).
- If you wish to allow users to search all the data, then leave the 'restrictColumn' field blank
- Once you have selected your parameters, click on 'Insert'
This will embed the Search macro on to your page (with the selected parameters), as shown below:
Then click on 'Save' to save your page
This will embed a free text Search box on your page, which can now be searched by any user with access to the page. The column headers of the searched columns will appear above the Search box
In this example, the column for 'Brand' only would be searched:
Now your users can search your data, but in order to view the results, you must insert the 'DataViewResults' macro