I am creating a payroll timesheet app. When adding each timesheet the first column needs to be the current User email as per the User Profile BUT I dont want it editable in the form.
I have been able to set the field to default to the user id email but if I remove the field it doesnt add email to google sheet. If I leave it in the list it allows user to edit.
How do I include the user ID email for each timesheet I add without user being able to edit it?