1. Refine your search results with filters
To follow this tutorial, make a copy of our sample file (or copy and paste the content) to your Google Sheets or Microsoft Excel for Office 365 datasheet.
This type of filter allows you to filter our search results based on a text string. We want to set up a filter on the First Name and Last Name columns. To do this, we will use stringFilter since these columns contain text.
In our example, we want to add a search bar for the First Name and Last Name columns.
The Department column has different categories. Using categoryFilter will allow us to display only the values that are selected from the dropdown menu.
Optionally, you can use a dependent category Filter to refine your search results.
The Expertise column has different tags or labels related to skills that are separated by commas. A csvFilterAnd will show items that match all the selected values.
The Professional Experience column has numeric numbers. Use numberRangeFilter to filter your People Directory by years of experience.
2. Use keywords to make your apps functional and beautiful
Now it’s time to use keywords to specify how you want to display your data.
For example, you can tell Awesome Table that you want an entire column to be displayed either as an image, link, button, chart, etc. without writing a single line of code.
This means you can create a fully functional app using just keywords!
Keyword imageType - displays images from a column containing links to images.
Keyword ListType - displays entries as separate bullet points.
- column H contains the text that will be displayed on the button. We have used the phone number, but you can choose any text, for example "Call"
- column I contains the standard telephone link in HTML; since column H references column I, when the user clicks the button, a call is triggered with the number listed in column I
3. Final results of your People Directory
All columns containing filters & keywords
Your app should resemble the one below: