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 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.
Option
Effect
Only when used
If calculated fields are used as part of a formula to update a field, this option will ensure that the calculated fields are up to date when the calculation is performed.
Always
This option ensures calculated fields are always kept up to date during processing.
Never
This option will not automatically update calculated fields. For calculated fields to be updated, the planograms need to either be run through a recalc process or opened and saved manually in Space Planning.
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
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
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
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.
Option
Update type
field’s default value
Updates the field to its default value in Space 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.
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:If 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.
Option
Update type
Update all field values
Updates the specified field for all objects of the specified type in each planogram/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.
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.
Was this page helpful?
Assistant
Responses are generated using AI and may contain mistakes.