Home > Forum > Actions > Change multiple fields with Empty Value

Change multiple fields with Empty Value
0

Hi everyone!

Hope you're doing great!

I need some help here! I want to change a selection of fields with empty value on path transition. The idea is that I have a cyclical process and I need to clean some fields in order to be available on the next step.
I'm trying to use the Multiple Change Values to make them as empty, but I'm being unsuccessful here!

Does anyone have any ideas?
Thank you all!

MVP

It looks like you are misusing this action.

In Attribute mappings
* column 'Field' - it's a field on form which should change value
* column 'Column' - it's a value based on SQL.

Right now you are selecting values with query, and setting them all to the same field called 'Clean Field'.

So based on your screenshot i'd say it should look like this:

Query: SELECT '' As Empty (note: I'm not sure what value should be used here, as empty string might not work, and i'm not sure if 'Empty' means NULL in db)

Field:
* Bank
* Issue Date
* Guarantee Expiration Date
* Counter-Guarantee Expiration Date
* Collateral Duration
* Collateral Counter Validity

Column:
* Empty
* Empty
* Empty
* Empty
* Empty
* Empty