# Allow Access to Form Based on Airtable Field

**URL:** <https://community.miniextensions.com/t/allow-access-to-form-based-on-airtable-field/184>\
**Category:** Feature Requests\
**Created:** [April 14, 2023, 8:11pm UTC](https://community.miniextensions.com/t/allow-access-to-form-based-on-airtable-field/184 "2023-04-14T20:11:16Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![silisols](https://avatars.discourse-cdn.com/v4/letter/s/b3f665/32.png) [@silisols](https://community.miniextensions.com/u/silisols)\
**Post date:** [April 14, 2023, 8:11pm UTC](https://community.miniextensions.com/t/allow-access-to-form-based-on-airtable-field/184/1 "2023-04-14T20:11:16Z")

</div>

Please include a feature to only allow access to a form based on the user matching certain options in an Airtable field. This would be handy if we want only paying customers to create a new record.

Also, the option to display an alternative message which can be edited with HTML, e.g. to re-direct them to the payment page.

---

<div class="post-metadata">

**Author:** ![Abdul](https://avatars.discourse-cdn.com/v4/letter/a/dfb087/32.png) [@Abdul](https://community.miniextensions.com/u/Abdul)\
**Post date:** [April 15, 2023, 5:49am UTC](https://community.miniextensions.com/t/allow-access-to-form-based-on-airtable-field/184/2 "2023-04-15T05:49:14Z")

</div>

We have a feature that can restrict access to the form or portal depending on an Airtable field. You can check this article for more information: [How to remove a user’s access to a form or portal?](https://docs.miniextensions.com/en/articles/6638881)

Regarding the alternative message, you can customize the success message, but it is important to note that the formatting of the message will be limited to the formatting available in the editor.

 ![image](https://canada1.discourse-cdn.com/flex035/uploads/miniextensions/original/1X/b0bb66de65e6a288ddfebb0ba061f6fc0508a7b7.png)

If this is not what you had in mind, please provide us with more information about your specific use case. Providing a screenshot would be particularly helpful.

---

<div class="post-metadata">

**Author:** ![silisols](https://avatars.discourse-cdn.com/v4/letter/s/b3f665/32.png) [@silisols](https://community.miniextensions.com/u/silisols)\
**Post date:** [April 15, 2023, 1:31pm UTC](https://community.miniextensions.com/t/allow-access-to-form-based-on-airtable-field/184/3 "2023-04-15T13:31:02Z")

</div>

Hi @Abdul

Thanks for the reply. The article states that the feature is available when the form is setup with a login. The screenshot you have provided is for a success message after submitting the form which doesn’t apply to the request which is about re-directing them if they do not have access to the form.

In our scenario, the form (created using the form extension) is a link within the portal menu. The user is already required to log in to the portal and it would not be a good user experience for them to have to login again to access the form (which is embedded in the portal) after already logging in to the portal.

The portal allows the user to view and edit their records, and the form above allows them to create new records. We want users who have a certain setting in an Airtable field to access the form which creates new records.

I realise I can simply set all of the fields to conditionally show based on the Airtable field but when you have 50 fields in the form with that number more than doubling in the future, it is counterintuitive. The simpler and better option would be for the user to access the form according to the setting in an Airtable field.

I hope that is a bit clearer.

Regards.

---

<div class="post-metadata">

**Author:** ![Abdul](https://avatars.discourse-cdn.com/v4/letter/a/dfb087/32.png) [@Abdul](https://community.miniextensions.com/u/Abdul)\
**Post date:** [April 15, 2023, 2:24pm UTC](https://community.miniextensions.com/t/allow-access-to-form-based-on-airtable-field/184/4 "2023-04-15T14:24:25Z")

</div>

Thank you for providing additional information about your use case. I recommend creating a Formula field in Airtable that generates the form URL for the menu items.

> [@Portal: Menu Items support for Dynamic URL](https://community.miniextensions.com/t/portal-menu-items-support-for-dynamic-url/110):
>
> We are excited to announce that we have added a new feature that allows you to use dynamic links for Menu Items. If you would like to learn more about this feature and how to use it, please refer to the following article: [How to add a custom menu in the portal header?](https://docs.miniextensions.com/en/articles/6475671-how-to-add-a-custom-menu-in-the-portal-header). We value your feedback and welcome any comments or suggestions you may have. Please feel free to share your thoughts with us by posting a comment below or contacting us via chat.

The formula field will now determine whether to display the form for creating a record or the URL for editing a record.

---

<div class="post-metadata">

**Author:** ![silisols](https://avatars.discourse-cdn.com/v4/letter/s/b3f665/32.png) [@silisols](https://community.miniextensions.com/u/silisols)\
**Post date:** [April 15, 2023, 4:25pm UTC](https://community.miniextensions.com/t/allow-access-to-form-based-on-airtable-field/184/5 "2023-04-15T16:25:34Z")

</div>

It might work. Let me have a play around with it.

---

<div class="post-metadata">

**Author:** ![silisols](https://avatars.discourse-cdn.com/v4/letter/s/b3f665/32.png) [@silisols](https://community.miniextensions.com/u/silisols)\
**Post date:** [April 15, 2023, 7:53pm UTC](https://community.miniextensions.com/t/allow-access-to-form-based-on-airtable-field/184/6 "2023-04-15T19:53:42Z")

</div>

Thanks for the suggestion @Abdul. This will work.

Regards.
