+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.
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.
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!!
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.
+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.
We’d love more defaults too, specifically being able to select a default time for date + time fields. Right now it defaults to midnight which sometimes causes confusion across time zones - e.g. for some people it’s today, for others it’s tomorrow.