Am I correct in thinking there is no way to set the default value of a date field to “today”? Naturally I can set the value to today’s static date (ie July 24th), but there seems no way to set it to a dynamic “today”.
Hey! You can’t set this in the new Default Value setting, you can vote for this as it should cover your use case: Allow using a Formula to define Default Values
Right now the solution is to set the default value using an automation, after the user creates the entity.
Trigger: When entity is created.
Action: Update entity
Fields: Date, set by formula, Today()
This will not show in the UI and forms as the default value before creation, but will be set after the entity is created.
Thanks Ron! Unfortunately this requires using one of my 1000 included automations on the Standard plan. I’m creating thousands of records this would apply to every month so this would use up my entire quote just to perform the basic function of setting a date.