
We'll use ListType because this column contains values that are separated by commas. We want to add a keyword in the Expertise column. The ListType keyword displays entries as separate bullet points. To add this keyword: enter imageType in the second row, in the Photo column. We'll use imageType because this column contains image links. We want to add a keyword in the Photo column. The imageType keyword displays images from a column containing links to images. In this tutorial, we're going to add the following keywords: That means you can create a fully functional app using just keywords!
#YOUTUBE AWESOMETABLE IMAGETYPE HOW TO#
Keywords let you specify how to present your data.įor example, you can tell Awesome Table that you want an entire column to be displayed as an image, link, button, or chart without writing a single line of code. To do this: enter numberRangeFilter in the second row, in the Expertise column.Īdd keywords to define how your data is displayed We'll use numberRangeFilter because this column contains numerical numbers.
#YOUTUBE AWESOMETABLE IMAGETYPE PROFESSIONAL#
We want to set up a filter on the Professional Experience column. Results that contain any values within the selected range are displayed.

The numberRangeFilter lets your users filter your data by selecting a range of numbers. To do this: enter csvFilterAnd in the second row, in the Expertise column. We'll use csvFilterAnd because this column contains values corresponding to different types of expertise separated by commas. We want to set up a filter on the Expertise column. Results that contain the selected values are displayed. The csvFilterAnd lets users select one or more values from a list. This filter lets you refine the list of values available in your drop-down menu according to the value selected in a parent filter. Info Learn about the dependency categoryFilter. To do this: enter categoryFilter in the second row, in the Department column. We'll use categoryFilter because this column contains category values.

We want to set up a filter on the Department column. The categoryFilter lets users select from a set of values in a dropdown menu. Enter stringFilter in the second row, in the First Name and the Last Name columns. If you haven't already done so, add a row to your spreadsheet below the first row containing the headers.Ģ.

We'll use stringFilter because these columns contain text.ġ. We want to set up a filter on the First Name and Last Name columns. The stringFilter lets users filter the search results by entering a text string in a search bar. In this tutorial we're going to add the following filters: You can access your spreadsheet directly from the Awesome Table interface by clicking the Open button in the Spreadsheet Source section.Īdd filters to refine your search resultsįilters help your users find the data they are looking for. Get Excel People Directory (with filters and keywords)Īlternatively, you can use the spreadsheet you created or downloaded in step 1 of this tutorial and add the filters and keywords yourself.
