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 i...
Forum Discussion
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/
------------------------------
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------