I’m working on a new project that has a reasonably simple structure:
Organizations table
People table where employees and clients are tagged as such
Employees: can belong to one organization, can see all of their client records, but not all org le...
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...
I am more familiar with join tables, SQL etc. I have 3 tables: “person”, “activity” and “activitylog”
“activity log” is essentially a join table that stores the person ID and activity ID.
I created two linked fields in the “activity log” table and AT...
I don’t think I’m thinking about this the right way…
I have two tables:
Events:
hostId, eventname, city
20, event1, helsinki
20, event2, stockholm
21, eventN, toronto
Hosts:
hostID, hostname, totalEvents
20, biff, count of all rows from event table w...
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...
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? Whe...
bangs head on desk
ok, here’s the problem. I migrated my data from another system to Airtable and I assumed when I was linking the tables, I could choose the foreign key (hostID) to link them, but it turns out all i needed to do was to change the int...
