All Collections
Working With Woodpecker Fields
More about Formula Field
Automatically convert text to UPPERCASE using a Woodpecker Formula field
Automatically convert text to UPPERCASE using a Woodpecker Formula field

Automatically capitalize a field's value using Formula fields

Eszter Takacs avatar
Written by Eszter Takacs
Updated over a week ago

Because of formatting requirements you may need to have a value (a State or Country for instance) capitalized in your document. Remembering to type out a value in all caps can be error prone and time consuming. 

Thankfully, automatically capitalizing a field value using Woodpecker Formula fields is super simple! We'll walk you through how to automatically capitalize a field using the example below.

1. Create a "State" field

In this example we'll create a new field called "State" but you can skip this step if you already have an existing field that you'd like to capitalize.

2. Create a "State (Capitalized)" field

Next, we'll create another field called "State (Capitalized)" and make it a Formula field. The benefit of having two fields here (one capitalized and one not) is that we can use both of them in our document if there are locations for "State" that need to be in all caps and others that do not. 

When creating the Formula field, set the formula value to the following:

UPPER("{State}") 

Note that we're referencing the "State" field using a Woodpecker Macro (the name of the field surrounded by brackets) and that we've also surrounded the Macro with double quotes (" ). Whenever we use built in formulas (such as UPPER ) we need to surround the Macro we're referencing with quotes. 

Did this answer your question?