Page tree
Skip to end of metadata
Go to start of metadata

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

See instructional video

...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