---
title: "Change field values with formulas"
slug: "change-field-values-with-formulas"
updated: 2026-04-27T20:02:38Z
published: 2026-04-27T20:02:38Z
canonical: "help.quickbase.com/change-field-values-with-formulas"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://help.quickbase.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Change field values with formulas

This article explains how to use a formula in a Change value action in a form rule.

Use the **Change value** action to change the value of a field. You can use a formula to update values in a form rule action. Using a formula gives you more control, and you can update values dynamically. That is, create a form rule that uses a single action for multiple factors with a formula, instead of creating an action for each scenario.

For example, in a Tasks app you have a field for the status change log. That is, a field that tracks who changes a status, to what, and when.

Instead of creating multiple **Change value** actions, you can use a formula in a single action.

![the rule builder that shows then logic to change the value of the Status Change Log field to the value in the formula UserToName(User()) & has changed the status to &status](https://cdn.document360.io/dd260e4e-10bb-4b66-8fb3-5504c272b904/Images/Documentation/20712234690836.png?sv=2026-02-06&spr=https&st=2026-10-16T01%3A59%3A00Z&se=2026-10-16T02%3A59%3A00Z&sr=c&sp=r&sig=CB17hwODsTB9FsaWxTUfouvT1UAU%2F1Brc%2FJ2r43TcYQ%3D)

Use this formula

`UserToName(User()) & " has changed the status to " & [Status]`

This formula:

- Identifies the user
- Sets the field value
- Uses in the value of the status field
- Calculates a value for the Status Change Log field

> [!TIP]
> Tip
> 
> Use the controls in the formula builder to add relevant fields and the browse functions you can add to a formula.
> 
> Learn more about [using the formula builder](/v1/docs/create-a-form-rule#create-a-form-rule-condition-with-the-formula-builder).