corebos icon indicating copy to clipboard operation
corebos copied to clipboard

Global Variable for Import to not create new pick list values

Open joebordes opened this issue 7 years ago • 1 comments

Create a global variable called

Import_Create_PicklistValues

which can have values: 0 and 1

By default, it is set to 1.

If set to 1 when importing new records any value not found in the picklist will be added as a new value. This is the current behavior.

If set to 0, the selected picklist default value will be used instead of creating a new picklist value.

https://discussions.corebos.org/showthread.php?tid=1205

joebordes avatar Aug 22 '18 15:08 joebordes

Thinking about this I realized that a much better solution would be to add a checkbox on each picklist row in the import so we could decide how we want each picklist to behave instead of an "affect all" global variable.

This is a more flexible solution and more evident for the user doing the import. It is also more complicated as we have to save the selection in the mapping, especially for scheduled imports.

This second solution should be implemented instead of the global variable.

importpicklist

joebordes avatar Aug 22 '18 16:08 joebordes