Relative Airtable Rookie (Well, maybe a Sophomore) here…
So forgive me if this is obvious or somewhere - but I sure have looked and haven’t been able to find it!
I know you can use Airtable forms for other people to input info directly into your spreadsheets.
But I need the opposite.
What if I have all the info, but I want to generate a report or a form to distribute that? (And make it look nice?)
Case Study: I produce a television talk show and I want to generate several different “forms” or reports.
Examples: a research dossier for the hosts to prepare for their on camera interviews of these subjects with headshots, bios, topic-related background, social media links, etc. on the guest as opposed to a different one for the editor - with much of the same overlapping info but links to where all the A/V assets are (DropBox, whatever) versus one for “transpo” - providing home address and cell phone for the limo driver to pick him/her up, drop them off (but no one else should have access to this info); versus one for marketing and distribution that gives us any good dates to sync their premiere with (i.e. related charity awareness weeks, books being published, movies coming out) versus legal - one that would automatically fill out a personal release for them to sign - and for us to double check their social media handles, hashtags, etc.
A lot of the same info repurposed in different ways (protected from some, saving time for others).
How can I export content from my sheets to forms I generate/customize?