Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Dec 30, 2022 03:25 AM
I have a table called 'accounts' and another one called 'users' linked to accounts in a one account to many users relationship. I want to create a field in the table users that shows an array with all the other users in that account except themselves. I wonder if airtable would allow me to do that?
I have tried with a rollup but I don't know what to enter in the aggregation formula to exclude the user in the record, so I get a list with all the other users in their account.
Dec 31, 2022 06:56 AM
I don't think you're able to access the currently logged in user's account via formula fields I'm afraid