After setting up your datasource, this article will show you how to use our Awesome Table web app to create your first People Directory.
1. Connect to the web app
To use Awesome Table, you first need to create a profile with us.
To do so, click SIGN IN WITH GOOGLE (if you own a Gmail/G Suite account), or SIGN IN WITH MICROSOFT (if you own an Office 365 or Outlook/Hotmail account), and accept the permissions:
2. Create a new Awesome Table app
Click on + to create a new app:
3. Select your data source (spreadsheet)
Next, click the Select button:
Choose the relevant Google Sheets or Excel 365 file and click Select (or Open) respectively.
4. Select the relevant datasheet
Select the relevant datasheet (the tab or sheet containing all your data that will be included in your Awesome Table app) and make sure that the default data-range includes all the columns needed for your app.
Your data source (from Google Sheets or Excel 365 file) can contain several tabs / sheets but only one can be chosen as the datasheet.
a) Click the pen icon to choose a different data source (file).
b) Rename your app as needed.
c) Select the appropriate sheet / tab as your datasheet.
d) Specify the data-range (this should include all the cells containing your data).
a) Click the pen icon to choose a different data source (file).
b) Rename your app as needed.
c) Select the appropriate sheet / tab as your datasheet.
d) Specify the data-range (this should include all the cells containing your data).
Once you've selected the datasheet, Awesome Table’s editor will automatically detect the filled columns (you can also manually adjust this as needed). The prescribed format for the data-range is A1:yourLastColumn (e.g., A1:I). Then click the Create button to generate your app.
5. Apply the appropriate app-type
Finally, choose the appropriate visualization type for our app:
- Click APP CONFIGURATION
- Select Table as the visualization
- Optional: Limit the number of rows displayed to 4
- Select Filters, chart layout so the filters appear on top of your People Directory
- Click UPDATE APP for the changes to take effect
For now, your app should resemble the image below:
It doesn't look like our end-product yet, but all of these will change in our next tutorial.
In the next article, we will use the power of Filters and Keywords to significantly improve the look and functionality of your app.
Comments
0 comments
Please sign in to leave a comment.