Skip to main content
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 Space 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

Keep calculated fields current?

When updating field data, you have several choices related to how calculated fields in Space Planning should be handled.
The Never option will perform the fastest (especially for batches of CKB planograms) as it will never open the planograms in Space Planning to perform the field updates. The Always option will cause planograms to be opened in Space Planning to perform the field updates guaranteeing the calculated fields will always be updated, but this option will perform slower (especially for batches of CKB planograms).

Add Field Update

Folder options image

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.

Scope of update

You can update specific fields individually by choosing the Single field option, or you can update a range of description, value, or flag fields by choosing the Range of fields option.

Which field do you want to update?

Single field
Folder options image 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.
Range of fields
Folder options image When updating a range of fields, choose the type of field you want to update (Descriptions, Values, or Flags) in the Which field do you want to update dropdown list, and then in the Which fields do you want to update text box, enter the range of the fields to update. For example, to update description fields 1 through 5, enter 1-5. You can separate ranges with commas. For example, to update description fields 1 through 5, and also description field 7 and description field 9, enter 1-5,7,9.

What do you want to update the field to?

Select one of the available update options.
The option you select for the update type will change or hide the options below.

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.
The value you enter here will automatically be converted to the value type expected for the specified field. For example, 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. (e.g. unit or 0 will update a position merch style to Unit.)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.
If you are updating a text field with a specific value, you can also include field placeholders allowing you to incorporate data contained in other fields into the specified value text. If field placeholders are used, enclose the name of the field (along with its object type) within square brackets in the update text value. Make sure the Enable field replacement checkbox is selected.For example, if you wanted to update the planogram Notes field with a brief description of the planogram including its name and width, you could use the following as the specified value to use to update the planogram Notes field:Folder options imageIf you ran this field update on a planogram whose name was 12’ Coffee Makers and whose width is 144 inches, the notes field would be updated with the text The planogram 12’ Coffee Makers is 144 inches wide.
Which object do you want to update from?
Select an object type to populate the list of available fields.
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 Space 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.
The value of the field selected here will automatically be converted to the value type expected for the field you specified. For example, 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 (e.g. unit or 0 will both update a position merch style to Unit.)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.
Suppose you need to combine two field values and store them as a single field. This option will allow you to do that.

What values should be updated?

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

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 Update List

Each field update you create will be listed in the Update Field Data list. You can add multiple updates by clicking the ADD FIELD UPDATE button. Updates in the list can be reordered by dragging and dropping them. Use the three-dot menu on each update to edit, copy, move, or delete the update.