Can I set up a formula field so that a user can overwrite the information when in edit mode?

Question

Can I set up a formula field so that a user can overwrite the information when in edit mode? Another approach would be to set the default value for one field to equal the value of another field. &nbsp;Is that possible?

mcfneil · Answer

Yes. &nbsp;A good use case for this, and the example I'm going to use, is when you have an Item price, but want to have the option to override the list price.[My List Price] is a field coming from a parent table, or an items table.[Price Override] is a field that can change the value[Price] will be the formula field that takes the list price, or take the override price.[Price] formula would be:If( IsNull( [Price Override] ), [My List Price], [Price Override])If you are using text fields, the similar, but use the sign ="" rather than the null:If( [My Override Text]="", [My Default Text], [My Override Text])

quickbasecoachd · Answer

.. just a tip. &nbsp;If you are checking a numeric field to be blank with IsNull, be sure to set that numeric field to not treat blank as null. &nbsp;There is a field property checkbox for that.

marymary · Answer

Thanks. &nbsp;That is the way I have been doing it. &nbsp;Was just wondering if there was a way using only one field.

mcfneil · Answer

Can you describe your set up a little more? as far as tables and fields you are using.

You could possibly modify the button to write the value to the field when you first load the page, but give you the option to override it in the same field. But this depends on your set up, and where the data is coming from.

marymary · Answer

Here is my specific situation...I have a stipend field and a benefits field. &nbsp;Both are currency.Once I enter the stipend amount, I want the benefits field to be auto-populated as 25% of the stipend. &nbsp;This is our estimate. &nbsp;Once the stipend has been processed and paid, I will know the actual benefits dollar amount.I would like to overwrite the auto-populated benefit amount with the exact benefits amount in the same field.

Forum Discussion

Can I set up a formula field so that a user can overwrite the information when in edit mode?

Related Content

Formula Assistance

Formula Url Buttons

Formula Query with custom key

Formula Date Field

Date Field Formula