Help

Brainstorming Tool

5049 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Mac
8 - Airtable Astronomer
8 - Airtable Astronomer

I was looking for a meeting collaboration tool for a “pains, gains and goals” brainstorming exercise. I looked at a number of tools and all of them were quite a bit more complex than I wanted.

Luckily for me, I have a subscription to Table2Site and @poehah was available to answer my questions on Saturday!

Feel free to check out both the site (this is a demo page, so feel free to enter results):
https://table2site.com/site/brainstorming

Here is the related base:

0d41b7239ab01c5f5e8f76a7f7d714f76ba86a36.png

Brainstorming Tool - Airtable

Explore the "Brainstorming Tool" base on Airtable.

A couple of tricks that I discovered:

  1. To embed an Airtable form using the iframe option in Table2Site, you will need the embed URL, not the URL of the form. Example: https://airtable.com/embed/shrq6brDpXNi2RDKF not https://airtable.com/shrq6brDpXNi2RDKF.

  2. While the “Lookup” and “Formula” field types break when using the Table2Site data format, you can change the type of field to “Rollup” and use the “CONCATENATE(values)” aggregation function, to achieve the same result. Which for me, was auto-populating each “Tile” with a URL and the Voting feature.

Table2Site is one of my all-time favorite add ons for Airtable. As @poehah continues to develop this tool, Airtable begins to transform into an app building tool, much like Appsheets or Zoho Creator!

Enjoy and feel free to copy for your own use!

2 Replies 2
openside
10 - Mercury
10 - Mercury

Very cool Mack. Nice job. I’m also a fan of Table2Site.

Mac
8 - Airtable Astronomer
8 - Airtable Astronomer

Just a quick update on this, I was able to run our first session using this tool, I made a couple of tweaks to it, but it worked really well! We captured over 150 Pains, Gains and Goals from a group of 20+ people in 45 minutes.

Some lessons learned:

  1. Need a character count limit on submissions, a long response will run over the “tiles” making those comments unreadable and even cover up the “load more results” button on the bottom of the page.
  2. Each section Pains, Gains, Goals needs to have its own voting period after the data capture.
  3. I need to add a filter to take out all records that come in blank
  4. It’s helpful to have a demo session for each section, where you use the tool on the big screen and enter in an example pain, gain or goal.