Airtable Forms, is a Dynamic/Conditional input field possible?

[DennisTSS]

Hi,

As the subject line states, I am looking for a function within airtable forms that can allow me to change the available inputs based on the condition of a previous answer.

The purpose of this, is to submit an attendance form of such.
I am using a table consolidate all of the different departments as an individual record, and within that record, each employee is linked to their respective department.
My intent is to use the form to submit a list of attendees, based on which department is involved.
For example, I had a meeting today with Marketing, Finance, and Operations.
On the form, there will be a linking field, where I input these three departments.
Then I have an Attendee field, where I can link the individual attendees, based on the above selected departments.

Is this possible? Is there a way around this?

[TheTimeSavingCo · Accepted solution]

Unfortunately, limiting available options in fields is not possible with Airtable forms, you can only limit the availability of the fields themselves. 

With reference to your example, this would require you to have one linked field per department, with each linked field limited to a view that would display the personnel from said department

If one field per department doesn't work for you, you'll probably need to use some kind of third party form service, examples of which would be On2Air forms, miniExtensions or Fillout.  I'm not sure any of them have the exact functionality you're looking for though, and the quickest way for you to find out might be to just open a support ticket with them and ask them to provide you with an example form set up the way you described

[pressGO_design]

+1 to everything Adam said above.

Could you have the form collect attendees of all of your meetings and then use a lookup to give you an array of the departments that those people are in?

[DennisTSS]

Thank you both, it's kind of a weird limitation to have.

[CristianCG]

Hi there!

To give you even more options to work with conditional fields, at miniExtensions, we've created a third-party form that integrates seamlessly with Airtable. With our form, you can create individual or grouped conditions to show or hide fields based on the values of other fields. Plus, with our versatile Save & Continue mode, you can calculate formula fields and use them to control field visibility as well!

You can calculate the formulas manually before submitting the form or periodically every few seconds:

Feel free to try out these features with a free account on miniExtensions