The previous article guided you through the process of Adding a Custom Field in Excel. Besides changes to the regular single value data points, it is possible to add drop-down select boxes containing a list of many options. For such purposes, there is an enum data point type. It becomes particularly handy while adding, for example, GL codes or document types:
This is the prime use-case for the Excel approach to schema updates. When you create an enum field using elisctl, you need to create a new enum data type field and add a new sheet called
Options of + the id of the respective enum field:
When creating an enum field, it has to have at least one option filled. Options consisting of values such as None or empty string are not allowed. There must always be values for two columns - value and label. The "label" is shown to the user while the "value" is placed in the exported data.
After you are finished, update the schema in your Rossum account.
elisctl schema update 234900 --rewrite myschema.xlsx
The enum dropdowns are designed for a few thousand options at most. There is no hard upper limit, but with too many options, the user interface may become sluggish and documents will load slowly.
In case of having a field with many enum options, it is best to store them in an external database and use a custom connector extension to load the options dynamically based on type-ahead. Our Python sample connector shows such an example.
A common scenario that would produce too long dropdowns is vendor matching or product matching – we have a dedicated connector extension that you may deploy for these purposes.
Updated 3 months ago