I have a table called Contacts, for which I allow updates and adds. For Contacts I have a Detail View so that users can see the content and a Form View (system generated because of the allowance of updates and adds) so that users can, obviously, update or add data. I am able to select which fields to display in the Detail View, but would like to also select which fields to offer on the Form View, and these are not the same. I want to display only the editable fields (columns), not the same ones I show in Detail View.
For example, in the form I want a field for First Name and a field for Last Name, but on the Detail View I want to display the concatenated names in a field called Full Name. (these three fields exist as columns in my Google Sheet.)
I’ve tried creating a slice to apply to my Contacts table, but if I choose only those fields I want on the Form View, the others are not available in Detail View and vice versa.
How can I select which fields to display in a system-generated Form View?