Multiple Form IDs to the same response table

[James Olivo]

Is there an efficient way to have multiple form responses go to one table vs creating multiple tables per form ID. Hoping to consolidate the work and data for exporting.

[Pramodh M]

Hi @James Olivo 

You could create Columns and Sections in order to Consolidate the Response received from multiple forms.

Let me know if this approach is fine

Thanks

[James Olivo]

I can try this route, would it be separate tables on the same page vs a new page for each table that supports a form id. 

What I am hoping to achieve are expected results (Q = Question Label, A = Answer Value):

 FormID | Form1Q1 | Form1Q2 | Form1Q3 | Form2Q1 | Form2Q2 | Form3Q3

Form1 | Form1Q1A | Form1Q2A | Form1Q3A | null | null | null

Form2 | null | null | null | Form2Q1A | Form2Q2A | Form2Q3A

It would be a layered format/layout but would achieve the consolidation for exporting.