Help

Predetermined forms

Solved
Jump to Solution
424 2
cancel
Showing results for 
Search instead for 
Did you mean: 
k_ar17
4 - Data Explorer
4 - Data Explorer

Hi everyone,

I’m looking for some guidance on creating conditional forms in Airtable. Let me explain:

I’ve set up a base for project management where each project has different tasks based on the program type (and there are multiple programs). Ideally, I want to create a form with a predefined task list, allowing Project Managers to fill in details such as start date, assignee, end date, status, etc., without having to manually enter each task name.

Is this possible with Airtable’s Teams plan? Any insights or workarounds would be greatly appreciated.

Thanks in advance!

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

Assuming the project managers have their own Airtable accounts, I'd suggest using a combination of Record Templates and Interfaces for this.  We'd create one record template per program and create all the tasks in it:

Screenshot 2024-09-03 at 8.34.53 PM.png

And here's how the Interface might work:

Screen Recording 2024-09-03 at 8.37.48 PM.gif

Link to base

---
If your project managers don't have Airtable accounts, then it gets tricker.  Airtable forms don't let you edit linked record data, so you'll need to explore something like Fillout: https://www.fillout.com/

You'd also need to figure out a way to create the tasks programmatically before sending them the Fillout link so that it's prepopulated with all the tasks

See Solution in Thread

2 Replies 2
TheTimeSavingCo
18 - Pluto
18 - Pluto

Assuming the project managers have their own Airtable accounts, I'd suggest using a combination of Record Templates and Interfaces for this.  We'd create one record template per program and create all the tasks in it:

Screenshot 2024-09-03 at 8.34.53 PM.png

And here's how the Interface might work:

Screen Recording 2024-09-03 at 8.37.48 PM.gif

Link to base

---
If your project managers don't have Airtable accounts, then it gets tricker.  Airtable forms don't let you edit linked record data, so you'll need to explore something like Fillout: https://www.fillout.com/

You'd also need to figure out a way to create the tasks programmatically before sending them the Fillout link so that it's prepopulated with all the tasks

k_ar17
4 - Data Explorer
4 - Data Explorer

Thank you so much! 😊