When performing calculations with fields from related categories, it is not necessary to have those fields defined in the category you need to use them. For example, in a structure:

Country -> State-> City

If in a City formula we need the value of a field of its Country, it is not necessary to create a related field.

The getField function allows you to access the value of any accessible field in the data structure:

Document.getField(Path)

Where:

Path: It is a text string enclosed in quotation marks that allows us to locate the field univocally. To do this, we must start from the category we are in. After that, we can search for the target field using Dropdown Lists to Other Category. This path can be typed manually or by using the Create button from the Tag Viewer.

For example:

'Data:State->Data:Country->Data:Per Capita Income'

The arrow operator -> Always comes out of a Dropdown List that must exist in the category and is used as a data source. We can do the same as with creating read-only fields for a category. We just drill down through the names of other Dropdown Lists until we end up in the target field.

Important: The final target field must be a field specific to the target category. It means that it can not be a related field.

 

Take the free trial

Use it yourself free for 30 days (no credit card needed)

Free Trial
-->