I have 2 tables one for People and one for Businesses
The 2 tables are linked so a Person can be linked to multiple Businesses and vice versa.
I am trying to figure out if there is a better way to store the kind of relationship a Person ...
I’ve read various threads on permissions etc when sharing Databases. I am still confused if it’s possible for read only users to still be able to filter views or if there is any way at all to be able give people the ability to use filters wit...
I’ve gone from knowing nothing about Airtable to feeling I have a grasp of the main principles. I am building an ever more complicated database that has moved into the daunting complexities of off shore financing.
Upto now I have around 10...
Thanks again for your help.
Alas I did try Lookup fields by ‘looking up’ a function field in the Junction table to create a string showing the person and their relationship with the business. (the primary field is also a function but this concatenate...
Thanks for sending the link. It made a lot of sense but think I’m still missing something or may need to make more tables.
I created a junction table which my ‘people’ and ‘business’ tables are both linked to that also has a column for the persons r...
Thank you everyone. I completely missed the share option in each view. It’s a bit of hassle not being able to send a whole base with ‘read only’ access (and with filter options) but at least there’s a way round it.
Glad I made sense :slightly_smiling_face:
Yeh I’ve tried that script, it’s not ideal for how I imagined having to approach this but it’s something that I think could work.
Thanks for the help,