I’ve got 3 enumlists in different tables that I need to combine together in an enum on another table for it’s options.
So table’s A, B, and C have lists of email addresses that people can choose from.
In table D - all those emails need to be available as options in an enum.
I’ve got the following formula, but it’s not parsing things as I need:
split([notification_patient_facility].[notification_emails] + HCAs[HCA_Notification_Email_Options] + Hospitals[Hospital_Notification_Email_Options], “,”) - list("")
this gives me the following:
The first element of the list ([notification_patient_facility].[notification_emails]) is split into options, but the imported table options (HCAs[HCA_Notification_Email_Options] + Hospitals[Hospital_Notification_Email_Options]) are imported as a “list-option.”
I tried not including the SPLIT(), but then it was just a list of lists. I’ve also tried different split denominators: " , " (space, comma, space) and ", " (comma, space) - but all result in the same thing with the two table imports being list-options.
I also tried wrapping the whole thing in ANOTHER split, but it resulted in the same thing again (curiously).
@Aleksi help!!! (^_^)