Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Set defaults on fields

cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Mike_Ball
6 - Interface Innovator
6 - Interface Innovator

Simply the ability to set a default on fields other than numeric

On a date, the obvious is Today

On a string, just set a default value

138 Comments
Leslie_Peterson
4 - Data Explorer
4 - Data Explorer

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.

Dave_Nykanen
5 - Automation Enthusiast
5 - Automation Enthusiast

The date field should also support formulas.

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.

Robert_Andrews
6 - Interface Innovator
6 - Interface Innovator

+1

Seems like a clear need.

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โ€.

James_Steed
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

Mark_Bolton
4 - Data Explorer
4 - Data Explorer

+1

Like others, I am surprised this isnโ€™t already available and will need to rethink my workflow, too. Airtable, PLEASE add this feature.

Dan_Weaver
6 - Interface Innovator
6 - Interface Innovator

Another +1 for this :boom:

Airtable, please stop making us use โ€œUncategorizedโ€ as the first column in our Kanban views! :slightly_smiling_face:

Noel_Howell
6 - Interface Innovator
6 - Interface Innovator

Hey I noticed this and wrote a separate post! Using Filters to auto-fill fields with data

entropic
6 - Interface Innovator
6 - Interface Innovator

+1

This would be such a nice feature to see implemented!

Florian_Jourda
4 - Data Explorer
4 - Data Explorer

It would be great to be able to use a Formula to define the default value. It would allow to make all the use cases mentioned above work.

joe12south
4 - Data Explorer
4 - Data Explorer

+1 Really need this obvious feature.