Skip to main content

Hi.

We are using Airtable to display data about our system landscape. We want to share this data with our organization, and have therefore crated links and added these to our internal CMS system.

If the link is shared to somebody outside our organization, the information should not be available. We tired to handle this with the “Access restricted to our email domain”, but found out that it requires that the use is an airtable user. If we don’t make any restrictions that link can be accessed by anyone how has it.

In the perfect solution, we would like that only our Active directory users have access to the shared link. Is there any way to solve this?

Thanks in advance. 

 

You are currently using Airtable’s “public interface page sharing” feature, which doesn’t support SSO.

Airtable’s SSO does actually support Microsoft Azure Active Directory (now known as Microsoft Entra ID), but only for internal Airtable collaborators. Airtable also requires that you are on a business or enterprise plan.

So you would need to add those AD users as collaborators to one or more of your interfaces. You don’t need to give your AD users access to all of your interfaces — just the ones that you want them to see.

And read-only collaborators are free, so it shouldn’t cost you extra for those users.

Alternatively, if you don’t want to add your AD users as internal collaborators to an interface, you can use Fillout’s advanced forms for Airtable to share individual Airtable records with your AD users — as either editable users or read-only users — because Fillout’s SSO also supports Microsoft Azure ActiveDirectory.

Hope this helps!

If you have a budget and you’d like to hire the best Airtable consultant to help you with this or anything else that is Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld


Thanks for your input/advices. Showing of individual records is not really solve our issue. Adding all over AD users (we are a huge organization, with lots of changes) is not really an option either.

Seems like we have to build something where the airtablegrids are converted into sharepointlists update once a day.


I could be wrong about this, but as far as I can tell, I don’t believe that you need to manually add your users to Airtable. I think that your users can automatically synchronize from Microsoft to Airtable, based on which groups you want to synchronize. Here is Microsoft’s support article on this.

- ScottWorld, Expert Airtable Consultant


Again thanks for your advice, we will try and look into this. Looks interesting.


Hey ​@Gregers Agerboe,

I think Scott is right that you do not need them to manually add them. Also as mentioned, I think they would be creating their own account with only a couple of clicks (I might be wrong).

Having said that, two additional ideas which you might want to explore:
-  Setting a password for the shared view/interface (yes, I know it is not as robust as allowing only for certain domain)
- Creating a user portal in Softr or other user portal platform. This would be interesting if you do need user portal features, but Airtable’s user portal is still cost restrictive for you.

 

Completely different matter, but would love to have you join our Airtable Hackathon! Make sure to sign up!!

Mike, Consultant @ Automatic Nation 
YouTube Channel


That’s also a good idea from Mike — to use a 3rd-party portal.

The most popular portals that are currently available for Airtable are:
NolocoJetAdminSoftrPoryGlide, and MiniExtensions.

- ScottWorld, Expert Airtable Consultant