It would make my life so much simpler if we could write functions to pre-fill default values for fields. At the moment, I have many columns in pairs, one column with a computed “default” value, and the other with an editable value. (When the values are equal, I make the computed field display “…”) It works but it makes my rows really long!
Set defaults on fields
Lookup or fill out
This would save me a lot of time too!
In my case, I have an Expenses table that has an Object field (the reason for the expense) and that can potentially be linked to an Order object from the Order table. I want the Object field to be pre-populated with the Order name if there is one linked for this record, or to be left blank and editable otherwise.
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:
- New Matrix block, create Trello-style project management?
- Better Default Field Value Behavior
- Date Field Default Value
- Set defaults on fields
In addtion 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.