Creating a data view

A Data View aggregates information from multiple Reports. This is a premium feature. Please contact support@fotonotes.com if you are interested in this feature.

1. Go to Admin>Data Views.

Screen_Shot_2020-08-17_at_12.19.19_PM.png

2. Click on "Add a data view".

Screen_Shot_2020-08-17_at_12.19.46_PM.png

3. Enter a name for your data view and add the field keys from your template for each table (data, totals, and averages). Below are the additional field keys that you can include and make sure you enter them with all lowercase letters.

Field Keys:

    LATITUDE

    LONGITUDE

    STATUS

    DUE_DATE

    PRIORITY

    USERNAME

    MANAGER

    CUSTOMER

    CREATED_DATE

    CREATED_TIME

    TEMPLATE_KEY

    TEMPLATE_NAME

    PROJECT_ID

    CONTAINER_ID

    STATUS_LAST_UPDATED_DATE

    STATUS_LAST_UPDATED_TIME

    ARCHIVED

    VENDOR_NAME

    VENDOR_CONTACT_NAME

    VENDOR_PHONE

    VENDOR_PHONE2

    VENDOR_EMAIL

    VENDOR_NOTES

    VENDOR_KEY

    DAYS_TO_COMPLETE

 

Screen_Shot_2020-08-17_at_12.20.11_PM.png

4. To add a clickable link to the project from the data view, enter the field key "project_id" as one of your fields in the data table.

Screen_Shot_2020-08-17_at_1.19.46_PM_2.png

5. Each column can be sorted by clicking on the title.

Screen_Shot_2020-08-17_at_1.24.30_PM.png

6. To get a csv file of the downloadable data view, click on "Export" on the top left.

7. To exit out of the data view, click on the "x" on the top right corner.

8. Access your saved Data Views by clicking the (•••) menu on any saved View or Search Results.

Screen_Shot_2020-08-17_at_1.38.20_PM.png

 

Have more questions? Submit a request

Comments

Powered by Zendesk