combine two list lockup choices into one field on form

  • 29 September 2020
  • 3 replies
  • 3 views

Badge +3

List a has Topic / Category &IssueToCover

and List B needs RACI which combines all three as the title. 

I have used a list look up cascade to pick on form.

They work ok, however, I cannot seem to figure out how to combine the answers picked onto the form into the RACI Field (last one below)

Any detailed help please?

9096iF3B4E851D8F84C2E.png

9097i5D0393A16BC05A17.png

9098i24BDDE9C3F9FACF2.png

9099i968D77BC28C96A9A.png

9100i112AD92E4CA73D1B.png

Thank you

 


3 replies

Userlevel 6
Badge +22

Hi,

The formula should be structured like:
parseLookup(named control1)+" "+parseLookup(Named Control2)+" " +parseLookup(Named control3)

Badge +3

AWSOME!!!!!!!! Thank you so much. I don't know why but I could not get this to work over this last 2 weeks. Thank you again  / You solution worked great. 

Badge +3

🙂

Reply