This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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.