Yeah, that's possible. Personally I'd just have one table that contained all the form submissions for all the programs instead of having one table per program. Each of those form submissions would be linked to the appropriate program in the table of beta programs, and then I'd use rollups to get the customer counts
Yeah, that's possible. Personally I'd just have one table that contained all the form submissions for all the programs instead of having one table per program. Each of those form submissions would be linked to the appropriate program in the table of beta programs, and then I'd use rollups to get the customer counts
Do you know if there is a way to do it so each beta program has their own table? The reason is each beta program manager will need to track different things for the potential customers, so I want to give them the flexibilities of adding whatever columns they want after someone submits the form.
Hello there,
Thanks for sharing these insights mate as I found it very much useful and informative.
Do you know if there is a way to do it so each beta program has their own table? The reason is each beta program manager will need to track different things for the potential customers, so I want to give them the flexibilities of adding whatever columns they want after someone submits the form.
Yeap, use Airtable's Google Forms trigger: https://support.airtable.com/docs/google-workspace-triggers#google-forms-trigger
Then use conditional logic to feed the form submission into the table of your choice: https://support.airtable.com/docs/conditional-groups-of-automation-actions
Yeap, use Airtable's Google Forms trigger: https://support.airtable.com/docs/google-workspace-triggers#google-forms-trigger
Then use conditional logic to feed the form submission into the table of your choice: https://support.airtable.com/docs/conditional-groups-of-automation-actions
Ok I got that. But How do I link each table into a summary view "List of all Active Beta Programs" sheet and it shows you all the accounts that are tied to that beta program. So for example,
Beta Program #1 table is set up like this
Similarly Beta program #2 is set up in the same way like this
However, the aggregated view looks really weird. I had to create separate columns to link the "Active Beta Programs" view to each of the individual beta program tables.
Is there a better way to do this?
Ok I got that. But How do I link each table into a summary view "List of all Active Beta Programs" sheet and it shows you all the accounts that are tied to that beta program. So for example,
Beta Program #1 table is set up like this
Similarly Beta program #2 is set up in the same way like this
However, the aggregated view looks really weird. I had to create separate columns to link the "Active Beta Programs" view to each of the individual beta program tables.
Is there a better way to do this?
Given the requirement of needing one table per beta program I'm afraid what you've done is the only way
