That is probably a very confusing title, I will do my best to explain what I want but I am pretty new to coding and Airtable.
I already have a Grid View with multiple fields, and I am using the Forms View to add to my Grid View. In my Form I have a multiple select option where I can add multiple pieces of equipment that will be assigned to one project.
However, for my Gantt Views I need the Primary Field to only contain one value. Right now I am using a formula to define my Primary Field.
I think what I need to do is create a script that will extract the individual values of the array and assign them their own records. You can see from the images that not every record contains an array. Just for the sake of clarity, my Forms View updates the “Equipment # and Description” field, which has the lookup field “New # (Don’t Use)” which is what is used to define the Primary field. Not really an elegant solution but it is what I have so far.
My Forms View:
My Table, with primary field formula:
Any help or suggestions here would be appreciated!