Form with multiple destination

Ask for Help
1

tldr. How do I enable the form results to be spread across different tables/destinations depending on the type.

I have a form and there are three different types of information A, B, C. If the form is for type A, I need it to go to the A table; if it’s for type B, to the B table. It looks like the form only allows you to select one table for “Destination.” Anything I can do aside from creating three different forms?

2

It’s not possible to do that natively, but you can store the form results in 1 sheet and use scripts/formula (QUERY, FILTER, etc.) to get the results to where you want.