Generate values in newly created calculated properties in all your documents

 When you create calculated properties, their values aren't immediately generated in all your documents. This is expected behaviour: values of calculated properties are generated only when documents are updated and saved, either manually or automatically. 

Learn more about conditional logic. 

This article describes a workaround to let you generate values of calculated properties in all documents in a document class or a view. 

1. Create your calculated property. 

In our example, we created a calculated property "Language" that is calculated from the value of the property "Country":

- if the value of "Country" is "Spain" or "Mexico, the value of "Language" is "Spanish"

- if the value of "Country" is anything else or empty, the value of "Language" is "English"

Learn more: Calculate the value of a category from another manually-filled category.

2. Create another property of any type. In our example, we created a String property called "Test".

Learn more: Create and configure custom properties. 

We will use Bulk Updater to update this property in all the documents in the document class. All documents will therefore be updated and saved, which will trigger the calculation of the calculated property "Language".

We will then delete the property.  

3. Open Bulk Updater.

4. Configure and run an advanced export: select your domain, library and document class or view, then click Export. 

5. Open the spreadsheet.

6. Find the column containing the property you created (in our example, "Test").

Enter any value in all the cells in this column.

7. Return to Bulk Updater and run the update.

8. Return to AODocs and check your documents. The calculated properties have values. 

9. Delete the property you created for the update.