Glen_Saberton - profile

Glen_Saberton · Feb 23, 2021

Hi everyone, 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 ...

Filters for Read only Users · Jan 12, 2021

Hi all, 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...

Glen_Saberton · Apr 15, 2020

Hello all, 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...

Glen_Saberton · Feb 28, 2021

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...

Glen_Saberton · Feb 27, 2021

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...

Re: Filters for Read only Users · Jan 13, 2021

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. Thanks again

Glen_Saberton · Apr 18, 2020

I would also love to be able to do this automatically.

Glen_Saberton · Apr 16, 2020

Hi again, 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, Glen

User Statistics

User Activity

Having / Storing extra information in the link between 2 tables

Filters for Read only Users

Exponential growth in number of tables to support complex linking

Re: Having / Storing extra information in the link between 2 tables

Re: Having / Storing extra information in the link between 2 tables

Re: Filters for Read only Users

Re: Script Request: Copy the value of a field to a Linked field in a table to perform a lookup in another table

Re: Exponential growth in number of tables to support complex linking