I have linked a SignUp Genius signup to populate a student table in my Airtable database automatically. I have 3 custom questions, and Signup Genius exports those ALL in one custom questions field separated by commas. I need to separate those responses into 3 separate fields in my base and cannot figure out how to set that up. One of the fields is a linked field to another table in my base.
I'm assuming that I have to import that into one field in my table, then set up a formula in a different field that separates the comma-separated values. I have no clue how to do this.