I’d like to be able to write log data to a “master” table, but create filtered “public” tables.
in other words:
userid - event
121 - crash 122 - reboot 121 - reboot
That’s everyone together, and I want that private. But I want to make publicly visible tables:
eg: where ID = 121 AND EVENT = REBOOT
But without the user viewing “their” table being able to simply change the IMPORTDATA formula to see what ID 122 has been up to. This seems to be beyond the capability of Google Sheets and something which would attract me to airtable. Happy to learn how, but want to know it’s possible before I commit my weekend to learning AirTable