Separate Imported Field with Commas into Different Fields
We are using FMP to keep track of enrollments in camps. Data will be imported from an online form that will be exported as a CSV file.
In the CSV we have fields week1camps, week2camps, week3camps, etc.
In each of these fields you might have 3 camps people have registered for.
So, week1camps might come in as:
baseball, soccer, basketball
Is there any way I could import the week1camps field and have it add a "Y" into the names of the fields referenced in that field? As in, in this example a "Y" would be added to a baseball field, soccer field, and basketball field?
Thanks for any help.