Forum Discussion

StevenNelson's avatar
StevenNelson
Qrew Member
5 years ago

Copy a value if the current field is null

I want to add a name field to my database.  
I will be adding values to some of the records in this new field. 
I need a formula that will copy the record owner to the field if it is blank.
If it is not blank I want it to leave the current value alone.

Seems very simple but I can't seem to get it to work

------------------------------
Steve Nelson
------------------------------
  • BlakeHarrison's avatar
    BlakeHarrison
    Qrew Captain
    5 years ago
    Formulas can't actually copy information from one field to another, though they can look at 2 fields and determine which value to show. Instead of a formula, though, you may want to consider setting up a Form Rule or an Automation. If your Name field is a User field, you can setup a Form Rule that would insert the Current User into the Name field when the record is saved. You can also set it to only do this if the Name field is empty. This is probably the easiest way to do it.

    ------------------------------
    Blake Harrison
    bharrison@datablender.io
    DataBlender - Quick Base Solution Provider
    Atlanta GA
    404.800.1702 / http://datablender.io/
    ------------------------------