Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jul 02, 2020 12:40 PM
I am using Stacker and AirTable for a simple app. It shows a list of orders that users enter. I want to show summary data, but here are the problems:
if I share the base, everyone will see all email addresses for all users (for shared bases, you can’t hide fields as public users can toggle your hidden fields)
if I share the view of a table, it doesn’t show the blocks that display the summary data I want to show
Stacker doesn’t have the ability to summarize data (IE: average, min/max etc)
I thought about having a ‘stats’ table but I’d have to link every order record to each field somehow, and then I could pull that data into Stacker.
Any ideas?
Jul 16, 2020 08:53 PM
Sorry that you haven’t had a response before now. I don’t have experience with Stacker, but I believe that @ScottWorld has. Perhaps he can share some insights on this issue.
Jul 16, 2020 09:33 PM
Thanks, @Justin_Barrett.
Instead of sharing an entire base with your users, you need to use Stacker’s built-in ability to decide which records different people are allowed to see. That’s one of the key advantages of using Stacker, and that is why many people start using Stacker.
Stacker doesn’t natively support Airtable blocks, but it does support embedding websites, so you could embed blocks into your Stacker app (if you get on the Airtable beta program for embedding blocks). HOWEVER, the big Airtable security hole here is that when you share a block, your users have access to all the data in all of your tables.
Stacker supports Airtable’s formula fields, rollup fields, and lookup fields, so create those summaries in Airtable first, and then Stacker can show them to you. I’m not sure if Stacker supports the features of the “summary bar” in Stacker, but you could ask them. They might.have this ability natively built into Stacker.
Because your questions are very Stacker-specific, I would recommend reaching out to them about the features of their product, and how to use it most effectively. They have very good support.
Jul 17, 2020 04:54 AM
I ended up making a new table with the raw data and giving users instructions to filter it to do what my blocks do. Not slick, but good enough.
One thing I’ve always wondered, how do you automatically populate a summary table using rollup fields? When I create it, link the records and set the rollup field to count(), is there a way to automatically have it count all the records? Example:
table 1 has 20 records
table 2 is a summary table that’ll show a count of those records that I can use for display elsewhere (via Wordpress plugin etc)
I create the linked field and the rollup field in table 2 but then I have to manually link all the records from table 1. Is there an easy way to add all?
Jul 17, 2020 08:15 AM
You have to manually link records if they’re in another table.
To summarize records in your current table, you would use the summary bar:
Jul 17, 2020 10:29 AM
While you could link all of the records manually as @ScottWorld suggested, you could also use the new scripted action beta feature to make the link for you whenever a new record is created in your first table. One of its triggers is making a new record, which could then be used to create a link to your summary table. More info on that beta feature can be seen here, including a link to a signup form to request access during the beta phase.
Jul 17, 2020 10:48 AM
Great call, @Justin_Barrett! :grinning_face_with_big_eyes: :raised_hands:
This new scripting action is going to be a huge game-changer for Airtable!! Which is exactly why I’m reading this JavaScript book right now! :slightly_smiling_face:
Jul 17, 2020 11:01 AM
Agreed. I got access to the beta shortly after that announcement, and it’s completely changed how I think about doing certain things in Airtable.
Jul 17, 2020 11:04 AM
cool, I will check that out. For now, I accomplish what I need with Zapier. When a new record is added in any of my 4 main tables, Zapier updates my ‘stats’ table (1 record, multiple columns for various stats) and then Stacker can pull in the summary data.
Jul 17, 2020 11:44 AM
That looks awesome! Glad you figured it out. Stacker is the best!