Hi,
I have two separate forms, both have a projectName field defined. So essentially I have two lists of Projects. Is there a way to create a new form, where I can define a smart dropdown that pulls the list of entries from both of the forms and displays it as a single, combined list?
I tried creating three fields on form3:
projectName1 = smart dropdown from form1
projectName2 = smart dropdown from form2
combinedProjects = calculated using CONCAT with projectName1 and projectName2, but didn't work.
Thank you,
Peter