Asking users to structure their base in a way that is conducive to Airtable's best practices falls short (requires workarounds like automations) when they would like a single form to contain EVERYTHING they need to capture during the intake process.
Allowing users to ask the questions they need and manage their data properly without hacky solutions leads to a better user experience and understanding of how to get the most out of Airtable.
What is the proposed idea/solution?
Improve the form view to support creating new linked records and accessing linked record fields as questions on the form. Displaying these fields would depend on whether an existing or new linked record is desired by the submitter.
How does is solve the user problems?
It allows the base owner to ingest data in a way that is organized and structured relationally without relying on automations to duplicate data across tables or submitters submitting multiple forms in some required order.
How was this validated?
n/a
Who is the target audience?
base builders/everyone
