I agree with this - specifically, being able to set a “single select” field type option’s default value. I hope that can be arranged! It would be super useful.
Use case: I am creating a base that lists invoices issued. A date field containing the date 30 days after the invoice date is necessary to create a calendar view showing when payment reminders should be sent. Currently, a manual date would need to be created. If the date field supported date formulas, this manual entry could be automated.
Changes my workflow a fair bit, to discover this.
I was going to have “Requested” be the first status for an item submitted through form.
But I guess it will just have to be “Uncategorized”.
My work around for this is to use a second field. I have a “status” field and a “status_chooser” field. “status_chooser” is single select, as we all know the default is blank when adding a new record. My “status” field is a formula. if(status_chooser = “”,“in process”,status_chooser)
if status_chooser field is still blank, then status = “in process” otherwise it = status_chooser. And still works if later someone selects “in process” from the status_chooser.
I am doing this in grid view. Not sure how it would work in an online form.
