This can be done with workflow.
{Field 1} || ' ' ...
# suiteflowk
KevinJ of Kansas
10/22/2019, 1:52 PMThis can be done with workflow.
{Field 1} || ' ' || {field2}
j
Jessica Bickis
10/22/2019, 6:21 PMThanks again! This totally works. One last question on this. I am adding the values of a multi-select field. I've added the condition of an UPDATE FIELD 1 checkbox to trigger the workflow.
The first time it runs, it copies all selected values from the multi-select and adds to the end of the text in Field 1 just fine. If I edit the record again, the checkbox is NOT checked, and I save, only the first value of the muti-select remains.
Jessica Bickis
10/22/2019, 6:21 PMThoughts? If this it too much, totally understand!
Jessica Bickis
10/22/2019, 6:28 PMnevermind! I think I figured out the issue, just need to solve.
The values are separated by a . When the record is edited then saved, anything beyond the is removed from Field 1
Jessica Bickis
10/22/2019, 6:28 PMsorry - There should be a small box in those missing spaces
k
KevinJ of Kansas
10/22/2019, 7:09 PMMaybe use a listagg saved search value as a field
KevinJ of Kansas
10/22/2019, 7:09 PMand then use that to do your update
j
Jessica Bickis
10/22/2019, 8:14 PMI ended using the REPLACE function for the list, and replaced the symbol with a comma.
This kept all of the logic in the formula on the workflow.
7 Views