Help

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

Show all the users in the linked account except the one in the record

Topic Labels: array rollup
91 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

1 Reply 1

I don't think you're able to access the currently logged in user's account via formula fields I'm afraid