I ran into problems with this before so would like to understand it better.
Is this the best way to achieve this:
- Create new google sheet tab - add the columns (fields) that you want in the form
- Create a new tab that is linked to this new google sheet tab
- Add new calculated field that is Email of User that entered (to link the submission to User, is this the best way?)
- Add form entry components for each of fields you are interested in
- Add a “submit button”?
I realise the ‘show form’ component is probably supposed to do this?
(I’m trying to avoid them having to click on tab, then click on a button - instead just display directly the form in the tab)