Solved: When using action to add a new row to another tabl... - Page 2

mdanaher31 · 03-13-2023 06:49 AM

I am trying to use the action "Data: add a new row to another table using values from this row" but when the data gets added to the other table, the value of the column that should be Yes or No changes to TRUE or FALSE. The original column is an Enum that requires Yes or No. I have tried to figure out a workaround without luck.

Any advice? Thanks.

Suvrutt_Gurjar

@mdanaher31 wrote:

but when the data gets added to the other table, the value of the column that should be Yes or No changes to TRUE or FALSE.

Could you mention what is the base type of the enum column or more importantly the other table's column where it is updating through action.

My testing did not show any problem in saving in backend as well as showing up in the email delivered from automation, properly as Yes/No Values.

Email received from automation:

Backend data saved:

Column configuration:

The column saved in another table through action:

In the other table also the column type is "enum" with "Yes", "No" enum options.

View solution in original post

When using action to add a new row to another table, No changes to FALSE?