Update a multiple select field using Airtable API

[Molly_Hyde]

I want to combine a linked field containing a job title with each item in a multiple select field, which contains different statuses and sub-statuses in the application process. Ultimately, I need to be able to keep track of each status that a candidate has ever been in. I’m using the simple formula below:

{Job Title} & "_" & Status

But it seems like Airtable treats the different items in the multiple select field as an array. The formula produces the job title followed by a string of each of the statuses separated by a comma.

I’d like for it to produce the different combinations - Job F_1.a, Job F_2.a.

Does anyone know how to do this?

[Molly_Hyde · Accepted solution]

Was able to modify this solution for my purposes.