Option to tick and enter email address for a form confirmation email

[ehnz]

Hello, we have a form capturing data, we would like the option for the user to tick a box and enter their email address so they can get a copy of the form they have entered. Currently we don’t have any spare columns in the spreadsheet and we would like to avoid adding more columns to enable this. Is there any ideas about using another table or virtual columns to achieve this?

[Steve]

Virtual columns cannot accept input.

A form cannot save data to a different table directly.

Perhaps automatically navigate the user to a form for a different table after submitting the first form?