Hello,
I am building an infopath form to export to excel. I have two sections (one static and one repeating). I am looking for a solution where I can add values to a field in the repeating section based on following:
Values are copied from field4, field8, field11, Field15, Field19......(the values in these fields are separated by comas(fields 4 and 8 are in static section & field 11, 15, 18 and more are in repeating section)
it ALSO removes values (copied above) and remove values found in Field22.
this helps me create a column in excel file that gives me patients current medication while removing the discontinued medications