AnsweredAssumed Answered

How do I append to a multi line text field

Question asked by davidjohnson5000 on Aug 5, 2017
Latest reply on Aug 15, 2017 by courtney.shelton

I have a list workflow where I have a column called "column change"

I have a 3 separate workflows that have conditional workflows on modify

WF1- If Column called First Name  changes then update column called "column change" to "First Name"

WF2- If Column called Last Name  changes then update column called "column change" to "First Name;Last Name" assuming First Name also changed

WF3- If Column called Fitness Test  changes then update column called "column change" to "First Name;Last Name,Fitness Test" assuming First Name and Last Name also changed

 

However, when I attempt to run the 3 workflows only 1 value will display even in cases where all 3 columns have changed.  

Workflows

At the Start of WF 1 I clear the column called "column change" and then set the value to "First Name"

 

At the start of the WF 2 I save the existing value value found in  the column called "column change" to a variable.  In the Set Value I indicate to update the field to the variable and Last Name varCol Change & " " & "Last Name"

 

At the start of the WF 3 I save the existing value value found in  the column called "column change" to a variable.  In the Set Value I indicate to update the field to the variable and Last Name varCol Change & " " & "Fitness Test"

 

How do I achieve the column called "column change" to reflect all column names (First, Last, and Fitness Test) if all columns actually have changed...Note the conditional WF works in that the comparsion of previous vs current detects if a column has changed, I just cant figure out how to update the "column change" column to reflect what essentially the conditional workflow found.

 

Desired Results

End Result if all 3 columns change

Column Change should display

First Name;Last Name;Fitness Test (note not the value of the column, but just the column name should display in this column)

 

End Result if all 2 columns change

Column Change should display

First Name;Last Name (note not the value of the column, but just the column name should display in this column)

OR

First Name;Fitness Test (note not the value of the column, but just the column name should display in this column)

OR

Last Name Name;Fitness Test (note not the value of the column, but just the column name should display in this column)

 

End Result if 1 column change

Column Change should display

First Name (note not the value of the column, but just the column name should display in this column)

OR

Last Name (note not the value of the column, but just the column name should display in this column)

OR

Fitness Test (note not the value of the column, but just the column name should display in this column)

 

 

Outcomes