[HOW TO] Update data enumerations

[#1]

Hi all,

We'd like to know if there is any way to automate the creation of a new value in a data field authorized value: we receive a lot of information from external systems and when they add a new possible value for a field we must add it too (see image for any clarification).

We don't want to do this by hand and we'd prefer to automate it via Workflow or any other way.

Many thx,

Fabio

[#2 · Accepted solution]

Hi Fabio,

You should then rethink the design. Instead of using an ENUM field, try to store all this data inside a new table and link it to current table using a FK link.

That way every new data that you bring in can be inserted on the linked table via a workflow.

If you wish to continue as Enum you will have to update the schema manually and publish the changes.

Regards,
Vipul

[#3]

Hi Vipul,

Which workflow would you use to add the data in the enumeration?

Kind Regards

Gabriele