Set defaults on fields


#61

Loving Airtable, but it is perplexing the inconsistent support for defaults.
There is no technical reason nor is there a significant effort for you to support defaults for select fields, and to support formula.s

Come on Airtable. Save us all many thousands of hack and research time and get this done.


#62

Hi Katherine,
this key binding doesn’t seem to work on some foreign keyboards.
I’m on an Italian keyboard layout and the “;” key is secondary to the “,” key. I’ve tried CTRL+, and CTRL+SHIFT+, which would input the “;” but it won’t insert the current date into a Date field. Short of changing my keyboard layout to English, I am unable to use this feature.
Same goes for the < and > shortcuts for changing records because on my keyboard they are on the same key. It would be great if you guys could make Airtable work better on foreign keyboard layouts, too. More foreign users-friendly design choices, please :cry:


#63

While Date fields don’t support formulas, Formula fields do support dates.

You can do what you describe here by having:

  • Date = Date Field
  • ReminderDate = Formula Field with this formula:
    DATEADD( Date, 30, 'day' )

#64

+1 to allow any field to have a default value. I have a long text field that I’d like to have always start with the same basic content that can then be edited as a project evolves.


#65

Big ol’ +1 from me! Especially to the single select field.

The workaround from @James_Steed and @Noel_Howell is nice, but you can’t group by that formula field in the Kanban view.

Like @Dan_Weaver pointed out, it looks like we’re stuck with that ugly “Uncategorized” stack. That could easily be resolved with a default value for single select.

If you really wanted to get fancy, you could go so far as to have a “field required” option on fields with a defined default value. If the user tries to delete the content in the field, it could revert to the default value. And add an option to disallow “create a new option named …” so that people can’t accidentally add to the single select options with a typo. In some cases I prefer to be forced to customize the field type, in other cases creating the new option as I add content is nice. Toggling that option on or off would be cool.

But now I’ve gone off the deep end. :swimming_woman: Those extra things would be nice to have, but the only thing I actually NEED is the ability to set a default value for a single select field.


#66

Can’t we use the integration with Zapier to find and update the newest record - inserting desired “default” values into specific fields? I know it requires a paid Zapier account because it is a multi-step zap. This is what I’m trying to do now. My challenge is how to search for and select the most recent record…


#67

@James_Taylor
Create a view that filters to show only records with an empty single select field (ie, “uncategorized” in kan ban), and have Zapier act on all new records in that view.

If Zapier does it’s job, that view should stay empty.


#68

I also support this feature especially for single select field.

USE CASE:
When I create a row in GRID VIEW I want “TODO” to be added to the single field automatically so that my cards appears in the “TODO” column in kanban view automatically.


#69

Increment Requests for this option.

In grid view if I group by a field and then add a row in a group, the current field is set to the group-by value. Grouping by Status and entering rows in the TODO group would do what Aurelien wants.

I’d like to set default default values fields other than group-by (grid view) or lane (Kanban view). Ultimately I want a “working with” option that 1) filters out all rows not linked to a given project and 2) enters the given project in the PROJECT field no matter what view I’m working with.


#70

+1 I have a list of 100 items and it’s a tedious process to select each item one by one.


#71

@Paul_Berg you can also copy and paste single select fields while in a grid view


#72

+1 - defaults on checkbox, single select, date in particular would be helpful


#74

+1 for defaults in single selects, and dare I say a combination of single select and formulas would rock.
The lack of it is not game-breaking, but would certainly cut off lots of otherwise manual work.


#75

+1 - Defaults on Single Select & Text Fields


#76

Being able to set default values via formulas on single select fields, date fields, text, etc. would be a game changer.

  • Without the above feature KABANs and Grouped records that are driven by formula calculated fields cannot be moved into another grouping.

  • Adding the ability to set a default value via formula on single selects, etc would allow users to have the best of both worlds.

See other places where this feature is either requested, or would have been requested if the user had thought about asking for it:

In addition to being able to set a default value via formula, I would like to be able to UDPATE the value of a field (be it single select, text, date, or a multi select field) when the value of field that is in the formula is changed. For example, if I have a formula to calculate whether an item is DUE, OVERDUE, or NEARING DUE, or in GOOD STANDING… sometimes I need to quickly update the field to GOOD STANDING (despite such status being in conflict with dates). However, if a date changes after said manual override is made, I would like the DEFAULT value to be reapplied from the new calculation.


#77

I totally agree with these suggestions. Having a default is a necessity. It would be really nice to have a required field as well as ability to specify whether new values should be added in single select or multi select fields
I SECOND THAT MOTION!!


#78

Hey guys, I have found a way around for the default TODAY field using ZAPIER

TRIGGER - WHEN A NEW RECORD IS FOUND
then
FIND NEW RECORD BY UNIQUE ID
then
DELAY for 1 minute (Otherwise the task will be haulted)
then
UPDATE RECORD with CREATED TIME

This is possible because Zapier is registering the creation time of the ZAP.

Tadá!

Hope this helps


#79

Defaults on all field types is urgently needed (see those 77 posts in this topic?)

Airtable team: when is this coming?


#80

+1, yeah, I would really like this feature for at least my “Single Select”. When a new record is created, its status could be set by default to something. That would be helpful.


#81

Still need this, especially for Single Select fields!