I’m new to Airtable, so what I want to do must be something very easy, but I can’t figure it out.
Employee Name | Current Company | *Other Companies
Mark | Facebook | Amazon, Google
Sergey | Google | Amazon, Facebook
Jeff | Amazon | Facebook, Google
The above is Table A, where it has a field Current Company. This field is linked to Table B:
Company Name | Employee Name
Google | Sergey
Facebook | Mark
Amazon | Jeff
Can I make *Other Company field in Table A automatically populated by Formula or something else?