You can use keywords to specify how Awesome Table displays your data. This article lists all the keywords you can use with the different apps. Follow the links for more details.
Learn more about how to add keywords to your spreadsheet.
List of keywords
| Keyword | Description | App |
|---|---|---|
| Hidden | Hides a column in your data presentation. | Charts, Maps, Table, Cards, Gantt, Geochart, Org Chart |
| Sidebar |
Displays a list of choices in a side panel; if used with Hidden, the text is hidden until users click in the sidebar to make the text appear. We also recommend using it with templates. |
Table, Gantt, Geochart, Org Chart |
| HyperlinkType | Adds links to text or image elements. It can be an alternative to using templates. This is useful if you want to generate links in your table without showing the full links (only text or images are shown). It also hides the URL column. | Maps, Table, Cards, Gantt, Geochart, Org Chart |
| ButtonType | Displays a button that redirects to a link. You can also specify your link's colour (using HTML Color Names like red, blue, green or hex color codes). | Maps, Table, Cards, Gantt, Geochart, Org Chart |
| ImageType | Displays images from a column containing links to images. This is an alternative to using templates. When users hover over the image, a larger version pops up. | Maps, Table, Cards, Gantt, Geochart, Org Chart |
| IconType | Displays icons without using a template. Choose any icons from https://material.io/icons/. | Maps, Table, Cards, Gantt, Geochart, Org Chart |
| RatingType | Transforms numbers from 0 to 5 to star-rating icons. | Maps, Table, Cards, Gantt, Geochart, Org Chart |
| ListType | Transforms CSV values into HTML ordered lists. | Maps, Table, Cards, Gantt, Geochart, Org Chart |
| NumberedListType | Transforms CSV values into HTML numbered lists. | Maps, Table, Cards, Gantt, Geochart, Org Chart |
| CardsColor | Sets specific colors for your cards. | Cards |
| CardsContent | Specifies which column is displayed by the app. | Cards, Org Chart |
| OrgChartName | Specifies the name of the element (names of people in your organization). | Org Chart |
| OrgChartParent | Specifies the name of the ‘parent’ element - or the person's immediate supervisor in column A. | Org Chart |
| Longitude | Designates the column containing longitude coordinates of the markers displayed on a map. | Maps |
| Latitude | Designates the column containing latitude coordinates of the markers displayed on a map. | Maps |
| Tooltip | Allows you to display a tooltip when the user clicks a marker. Can be used to display the value from a column or an HTML template. | Maps |
| MapsMarker | Customizes your markers with images or icons. | Maps |
| ColorType | Changes the color of your map’s pins. | Maps |
| BICount |
Displays all the results based on the number of occurrences. |
Maps |
| ColumnChart |
Displays a series of data with rectangular vertical columns with heights proportional to the values they represent. This chart uses exact numbers, not value occurrences. |
Charts |
| StackedColumnChart |
Displays a column chart that:
|
Charts |
| 100StackedColumnChart |
Displays a column chart that:
|
Charts |
| BIAggregate | Displays the sum of all numbers in a column | Charts |
| PieChart | Displays data as a pie chart. | Charts |
| 3DPieChart |
Displays data as a three-dimensional pie chart. |
Charts |
| DonutChart | Displays a pie chart with a hole in the center. | Charts |
| BIWordcloud | Displays responses as a cloud of words | Charts |
| BITopResults | Displays a table with the top 15 values ranked by the number of occurrences. | Charts |
| AreaChart |
Displays quantitative data from one or more series with lines and colored areas. |
Charts |
| StackedAreaChart |
Displays quantitative data from one or more series with lines and colored areas. The areas stack on top of each other, making it easy to analyse a combined series trend. |
Charts |
| SteppedAreaChart | Displays an area chart where points are connected by horizontal and vertical series segments, looking like steps of a staircase instead of straight-line segments. | Charts |
| 100StackedAreaChart |
Displays an area chart that:
|
Charts |
| 100StackedSteppedAreaChart |
Displays an area chart that:
|
Charts |
| BarChart |
Displays data in horizontal bars using exact numbers, not value occurrences. |
Charts |
| StackedBarChart |
Displays a bar chart that:
|
Charts |
| 100StackedBarChart |
Displays a bar chart that:
|
Charts |
| BubbleChart |
Displays a dataset with two to four dimensions: X and Y coordinates, color and size. |
Charts |
| WaterfallChart |
Shows an opening and closing value overlaid on top of a total variance. |
Charts |
| ComboChart | Creates a personalised mix of several charts. Each series can be assigned a different marker type (area chart, stepped area chart, line chart or column chart). | Charts |
| Histogram | Groups numeric data into blocks displayed as segmented columns. | Charts |
| LineChart |
Displays information as a series of data points called markers, connected by a straight line segment. |
Charts |
| SmoothLineChart | Displays information as a series of data points called markers, connected by a curved line segment. | Charts |
| ScatterChart |
Shows how much one variable is affected by another using coordinates based visualization. |
Charts |
| Timestamp |
Applied automatically on all columns with dates in the Charts app. |
Charts |
| SlideTitle | Displays the content of the column as a title in your slideshow. | Slideshow |
| SlideText | Displays the content of the column as text in your slideshow. | Slideshow |
| SlideImage | Designates the column containing the links to the pictures you would like to display. It is recommended to use good quality pictures. | Slideshow |
| SlideLink | Redirects users to links when they click a slide. | Slideshow |
| SlideContent | Specifies what to display as HTML elements.
|
Slideshow |
| GanttGroup |
Designates the grouping for your tasks. |
Gantt |
| GanttLabel |
Assigns labels to individual tasks. |
Gantt |
| GanttStartDate |
Defines the start date of a task. |
Gantt |
| GanttEndDate |
Defines the end date of a task. |
Gantt |