Advanced Google Sheet Tricks


Creating Filters for Screens Connected to Google Sheets in Onespot

Filtering data in screens connected to Google Sheets allows users to quickly find relevant information without scrolling through unnecessary content. This feature makes it easier to customize views for different user groups, such as filtering by grade level, category, or subject.

Step-by-Step Guide to Adding Filters to Google Sheets Screens

Step 1: Open the Screen Editor

  1. Navigate to your Onespot Admin Panel.
  2. Click on the Lightning Bolt Icon and select Edit on the screen that’s connected to your Google Sheet.

Step 2: Edit the Data Source

  1. Click Edit Data Source to open the connection settings.
  2. Locate the Filters section (marked as Optional).

Step 3: Apply Filters

  1. Choose the column or data category you want to filter by (e.g., Level, Grade, Subject).
  2. Uncheck any unwanted options to narrow the results.
  3. Click Done to apply the filter settings.

Step 4: Save and Test the Filtered View

  1. Click Save to update the screen.
  2. Open the Onespot app and verify that the filtered view displays only the selected data.


Pulling an Image Address to Connect Your Directory in Onespot


Adding images to your Onespot directory enhances the visual appeal and user experience, making it easier to identify people, places, or items. Instead of uploading images manually, you can use direct image URLs from existing sources, such as Google Drive, a website, or a file repository.


Step-by-Step Guide to Pulling an Image Address for Your Directory

Step 1: Find the Image You Want to Use

  1. Navigate to the directory where your images are stored (e.g., a website, Google Drive, or an online album).
  2. Locate the specific image you want to link to your Onespot app.

Step 2: Copy the Image Address

  1. Right-click on the image.
  2. Select Copy Image Address (or Copy Image URL, depending on your browser).
  3. This will copy the direct link to the image file.

Step 3: Paste the Image Address in Your Google Sheet

  1. Open the Google Sheets file connected to your Onespot directory.
  2. Locate the image column where images should be displayed.
  3. Paste the copied image URL into the appropriate row.

Step 4: Refresh Your Onespot App

  • Open your Onespot app and check the directory.
  • The image should now be updated and displayed correctly.
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.