Can I set a dynamic default value in a form?
I use a form to help my team record a log of completed work but I have an issue with recording the date. There's a date field on the sheet and I've added it to the form but I want it to default to today's date (whatever that may be when someone uses the form) and I can't find a way to do so. I can set a default value in the form but it'll be the date the form was edited - hence the only way to avoid everyone entering the date every time is for me to edit the form daily and update the default value.
Does anyone know how I can achieve this? Thanks.