Restricting Base Access

[Dorrie]

1. Can we restrict who fills out the Form, if we already have them logged in to a parent app that can authenticate via SSO to the airtable app?
2. And by detecting who fills out the Form, is it possible to pre-fill the other fields in the Form?

[kuovonne]

There are only two ways to restrict who fills out the form: by requiring a password (same password for everyone) or by restricting users to a particular domain.

You can prefill forms, but not with different values based on who is logged in.

You can configure the form to collect whoever filled out the form in a Created By field. The toggle for this feature is in the settings at the bottom of the form configuration.  The user must be logged into Airtable in order to get this info.

[CristianCG]

Hi there!

At miniExtensions, we've created a third-party portal that integrates seamlessly with Airtable, and can be used to display different forms. You can also configure it to conditionally hide forms and prefill fields based on the logged-in user. This is achieved using a login link combined with URL parameters generated via a formula field. Here’s how to set it up:

• Create a users table and add fields for the data you want prefilled for each user. This data will be linked to their login credentials, which can be a combination of any fields.

• Create a formula field and include the login link along with parameters for the data to be prefilled, like this:

• To restrict specific users from submitting the form, use the conditional tables feature . This allows you to hide the form if the conditions you set, based on fields in the users table, are not met.

Then, you can use automations to send personalized login links via email to your users, or embed the portal on your site and let users log in directly.