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

# Update Field Data

> Populate a set of data into a selected field in a group of like objects.

This automation allows you to populate data into a selected field in a group of like objects. You can copy fields
directly, modify, merge, or set them to a default value.

## Why you would use this feature

This is a quick, easy way to modify data in the Floor Planning fields. For example, if you had data in two fields that you
wanted to merge and save in a third field, this automation would allow you to do that.

## Feature Options

### Add Update Field

![Folder options image](https://mintcdn.com/crispinc/BhWWiYvsoitb8WXT/mission-control/images/fp_update_field_data/fp_field_update.png?fit=max\&auto=format\&n=BhWWiYvsoitb8WXT\&q=85\&s=ea684cccdf5ca94b592a6a1564dbc238)

***

#### ![](https://mintcdn.com/crispinc/BhWWiYvsoitb8WXT/mission-control/images/numbers/1.png?fit=max\&auto=format\&n=BhWWiYvsoitb8WXT\&q=85\&s=1d6ed169143a636c5f4525966967614f) What type of fields do you want to change?

Select the object type of the fields you want to update. This will populate
all the available fields for that object into the update field selection dropdown.

#### ![](https://mintcdn.com/crispinc/BhWWiYvsoitb8WXT/mission-control/images/numbers/2.png?fit=max\&auto=format\&n=BhWWiYvsoitb8WXT\&q=85\&s=c3e5beb246e7871550c37ea4c09f8eef) Which field do you want to update?

Select the field you want to update. Only fields that are writable of the object type specified in the field type
selection will be listed here.

#### ![](https://mintcdn.com/crispinc/BhWWiYvsoitb8WXT/mission-control/images/numbers/3.png?fit=max\&auto=format\&n=BhWWiYvsoitb8WXT\&q=85\&s=e3bc67ceab892288710996ffc3d09324) What do you want to update the field to?

Select one of the available update options.

| Option | Update type |
| - | - |
| Field's default value | Updates the field to its default value in Floor Planning.  **Numeric Fields** - Usually 0 **Text Fields** - Usually blank **Case fields** - Value this field has when a new object of its type is created |
| Specified value | Updates the field to the value you enter. |
| Another field's value | Updates the field with the value stored in another field. |
| Value of a formula | Updates the field to the value of the formula specified. |

> [!TIP]
>
> The option you select for the update type will change or hide the options below.

#### ![](https://mintcdn.com/crispinc/BhWWiYvsoitb8WXT/mission-control/images/numbers/4.png?fit=max\&auto=format\&n=BhWWiYvsoitb8WXT\&q=85\&s=957b491a87ac5465ed026e7e5bd7dfa6) Update value options

##### What value do you want to use?

Enter the value you want to be stored in this field. The specified value will be saved into the field being updated.

> [!NOTE]
>
> The value you enter here will automatically be converted to the value type expected for the specified field. So a number
> will be converted to text if you update something like a description field. For case fields, you can enter either the
> numeric value of the case option you want to update or the option's name.
>
> If the value you specify here cannot be converted (e.g. setting a text value into a numeric field), the field will be
> updated to its default value.

##### Which object do you want to update from?

Select an object type to populate the list of available fields.

> [!NOTE]
>
> Only objects that can be copied will be available here. Objects that can be copied are the same or at
> a higher level than the object type selected for the update. See the Floor Planning help file for more information on
> the object hierarchy.

##### Which field do you want to update the field from?

Select the field you want to copy the value from. The current value of this field will be copied into the field
being updated.

> [!NOTE]
>
> The value of the field selected here will automatically be converted to the value type expected for the field you
> specified. So a number will be converted to text if you update something like a description field. For case fields, you can use either the case option's numeric value or the name of the option.
>
> If the value you specify here cannot be converted (e.g. setting a text value into a numeric field), the field will be
> updated to its default value.

##### What formula do you want to use?

Specify a field or formula, and the value of that formula will be stored in the field you selected to be updated. You can launch the formula builder to get assistance with building your formula by clicking the **F** button.

> [!TIP]
>
> Suppose you need to combine two field values and store them as a single field. This option will allow you to do that.

#### ![](https://mintcdn.com/crispinc/BhWWiYvsoitb8WXT/mission-control/images/numbers/5.png?fit=max\&auto=format\&n=BhWWiYvsoitb8WXT\&q=85\&s=aee7533a7cfe5f520502ab10b7c75777) What values should be updated?

Select an option here to determine if the updates should update all objects within your project or floorplan or should
filter objects before applying the update.

| Option | Update type |
| - | - |
| Update all field values | Updates the specified field for all objects of the specified type in each floorplan/project. |
| Only update field values that match a rule | Updates only the fields for objects where the specified formula evaluates to true. |
| Only update field values that are blank/the default value | Updates only the fields whose current value is the default value.   *This option allows you only to update fields that are not currently set.* |

#### ![](https://mintcdn.com/crispinc/BhWWiYvsoitb8WXT/mission-control/images/numbers/6.png?fit=max\&auto=format\&n=BhWWiYvsoitb8WXT\&q=85\&s=652dc593c6e4b1f4ac82733bbfdfc285) What rule do you want to use?

Enter a formula that will be used to check each object before updating the data. Only objects that evaluate true
for the specified formula will be updated.

### Field Updates

![Folder options image](https://mintcdn.com/crispinc/BhWWiYvsoitb8WXT/mission-control/images/fp_update_field_data/fp_update_list.png?fit=max\&auto=format\&n=BhWWiYvsoitb8WXT\&q=85\&s=e8bf127acc04e6ea84e0c70b6f69b400)

|  #  | |
| - | - |
| ![](https://mintcdn.com/crispinc/BhWWiYvsoitb8WXT/mission-control/images/numbers/1.png?fit=max\&auto=format\&n=BhWWiYvsoitb8WXT\&q=85\&s=1d6ed169143a636c5f4525966967614f) | Use the **Add Field Update** button to add additional update options. |
| ![](https://mintcdn.com/crispinc/BhWWiYvsoitb8WXT/mission-control/images/numbers/2.png?fit=max\&auto=format\&n=BhWWiYvsoitb8WXT\&q=85\&s=c3e5beb246e7871550c37ea4c09f8eef) | Each field update will copy data into the specified field based on the method you selected. You can reorder the fields by dragging and dropping them within the list. |
| ![](https://mintcdn.com/crispinc/BhWWiYvsoitb8WXT/mission-control/images/numbers/3.png?fit=max\&auto=format\&n=BhWWiYvsoitb8WXT\&q=85\&s=e3bc67ceab892288710996ffc3d09324) | Information on the value being copied into the specified field is displayed in the center. You can edit an existing update by double-clicking on it. |
| ![](https://mintcdn.com/crispinc/BhWWiYvsoitb8WXT/mission-control/images/numbers/4.png?fit=max\&auto=format\&n=BhWWiYvsoitb8WXT\&q=85\&s=957b491a87ac5465ed026e7e5bd7dfa6) | Update options can be removed from the list by clicking on the trash can. |
| ![](https://mintcdn.com/crispinc/BhWWiYvsoitb8WXT/mission-control/images/numbers/5.png?fit=max\&auto=format\&n=BhWWiYvsoitb8WXT\&q=85\&s=aee7533a7cfe5f520502ab10b7c75777) | Ability to select and deselect those field updates that you want to execute. |
