Data Templates

Data Templates

How to connect your data template to your slide:

  • STEP 1: Download the data template from the:
    • Vibe Portal
      After you have created your new slide, select File Upload in the Content Source dropdown.
      Click the Download button to save a copy of the data template locally.
      DataTemplateDownload.gif

      OR,
    • Vibe Help Center
      Check out the Template Library articles to download data template examples or a blank copy that you can use to add your own data/messages/events.
  • Step 2:  Choose your preferred content source
    With data templates, you can manually upload your latest file into the Vibe Portal or centrally manage all of your data templates in Google Sheets or SharePoint.
    • File Upload - Update the file locally and save your changes. Then, upload the file to your slide.
    • SharePoint /  Google Sheets
      • Existing data integration
        • Setup a folder in Google Drive or SharePoint
        • Copy the data template (XLSX) into your new folder
        • In the admin console, add the folder path to your API settings
          (read more Google Sheets or SharePoint)
        • In the Vibe portal
          • Select your data source in the Content Source dropdown
          • Select your data file in the 'Data' dropdown
      • New data integration
        Chat with your Vibe Coach or the Vibe.fyi team about upgrading your subscription to include a SharePoint or Google API data integration.

Common Data Entry formats

Tips and tricks when managing your data in a spreadsheet:

Data Column Supported Formatting
Title Free format (alpha, numeric, etc)
Summary Free format (alpha, numeric, etc)
TIP: Use ALT+ENTER to add a line break
Date DD/MM/YYYY or MM/DD/YYYY
Image

Both PNG & JPG formats are supported.

The way you reference an image file in this column will depend on the content source you have chosen:

  • File Upload: Enter "image:a_public_image_url" in the cell.
    e.g. image:https://vibe.fyi/images/logo.png

  • Google Sheets: Enter "=IMAGE(""a_public_image_url"")"
    e.g. =IMAGE(""https://vibe.fyi/images/logo.png"")

  • SharePoint: Copy your images into the parent folder where your data template is saved (or a direct sub folder), then reference the filename in your XLSX file, e.g.:
    • If your image is saved in the parent folder, the filename should be entered as '<imagefilename>.<fileformat>'.
    • If your image is saved in a direct sub folder, the filename should be entered as '<subfolder>/<imagefilename>.<fileformat>'.
      mceclip0.png
Time HH:MM AM or HH:MM PM

Set the correct slide duration

If the slide Duration field does not show "seconds per item" and the slide shows only one spreadsheet row at a time, we need to set a duration value that covers all spreadsheet rows. The steps to find the correct duration value are as below:

  1. Find a spreadsheet row that will take the longest time to show on the slide
  2. When the slide starts showing the content of that row, monitor the clock to measure the time until the slide animation completes.
  3. Enter the counted seconds into the slide Duration field.

Troubleshooting Tips

  • Slide not updating?
    Check the name of your sheet and try renaming it to 'Sheet1'
    mceclip0.png

    • Related Articles

    • Data (Multi-Bubble)

      Slide Inspo Forget static BI dashboards! Use the Data-MultiBubble template to share relevant info only and bring your data to life. Data Template tips Step 1: Download the data template from your slide portal. Step 2: When editing your XLSX file, use ...
    • Data (Plot)

      Slide Inspo ​ Template Data Tips The default spreadsheet has a separate sheet for the Graphs information - to populate the left side of the slide, and the Settings information - to populate the small and large bubbles on the right hand side of the ...
    • Data (Days Since)

      Slide Inspo Use these ideas for inspiration when creating your next slide: Day Count (# of days since the event took place) Data Insights - Single Day Count Data Insights - Multiple Day Counts (wait a few seconds to see the transition...) Data ...
    • Data (2 Dials)

      Slide Ideas Net Promoter Scores. This 2-dial design is ideal for showing your Weekly or Monthly NPS score for two feeds. You can compare your Industry standard or with another location/branch. Check out this quick video to get inspired: ​ Create your ...
    • Data (Stats)

      Slide Inspo ​ Asset Download Take advantage of downloading our default assets as a guide to create your own, if you wish to change them.