Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

[HOW TO] Update data enumerations

Avatar

Avatar
Shape 1
Level 2
fabios23415219
Level 2

Likes

10 likes

Total Posts

10 posts

Correct Reply

0 solutions
Top badges earned
Shape 1
Give Back
Validate 1
Boost 5
Boost 3
View profile

Avatar
Shape 1
Level 2
fabios23415219
Level 2

Likes

10 likes

Total Posts

10 posts

Correct Reply

0 solutions
Top badges earned
Shape 1
Give Back
Validate 1
Boost 5
Boost 3
View profile
fabios23415219
Level 2

06-06-2018

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).previewFile.png

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
Employee
Vapsy
Employee

Likes

369 likes

Total Posts

726 posts

Correct Reply

342 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Validate 1
Employee
Vapsy
Employee

Likes

369 likes

Total Posts

726 posts

Correct Reply

342 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile
Vapsy
Employee

06-06-2018

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

Answers (1)

Answers (1)

Avatar

Avatar
Validate 1
Level 2
gabrieleg615679
Level 2

Likes

12 likes

Total Posts

36 posts

Correct Reply

3 solutions
Top badges earned
Validate 1
Boost 10
Boost 5
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 2
gabrieleg615679
Level 2

Likes

12 likes

Total Posts

36 posts

Correct Reply

3 solutions
Top badges earned
Validate 1
Boost 10
Boost 5
Boost 3
Boost 1
View profile
gabrieleg615679
Level 2

18-09-2019

Hi Vipul,

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

Kind Regards

Gabriele