You have to put a comma in between the values, and send all of the values together into the linked record field.
However, I would recommend switching away from JotForm and using Fillout’s advanced Airtable forms for this instead, because you can do all of this natively with Fillout.
Fillout is 100% free, and it offers hundreds of features that Airtable’s native forms don’t offer, including the ability to display linked record fields on your form, the ability to update Airtable records using a form, display Airtable lookup fields on forms, control access to a form via SSO or email domains, perform math or other live calculations on your forms, accept payments on forms, collect signatures on a form, create multi-page forms with conditional paths, create new linked records on a form, connect a single form to dozens of external apps simultaneously, add CAPTCHAs to your form, and much more.
I show how to use a few of the advanced features of Fillout on these 2 Airtable podcast episodes:
Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
I understand that if I’m doing one automation, but it seems like each automation overwrites the last one.
I understand that if I’m doing one automation, but it seems like each automation overwrites the last one.
You only need one automation action to do this. Just create a formula field that substitutes your semicolons for commas, and insert that formula into your linked record field.
However, if you really want to break it up into extra automation actions, then you need to insert the existing field first, followed by a comma, and then add the new value after the comma.
But I would just switch from JotForm to Fillout, and then you don’t need to worry about any of this.
- ScottWorld, Expert Airtable Consultant
You only need one automation action to do this. Just create a formula field that substitutes your semicolons for commas, and insert that formula into your linked record field.
However, if you really want to break it up into extra automation actions, then you need to insert the existing field first, followed by a comma, and then add the new value after the comma.
That’s what I’m thinking, but I can’t figure out what to put in the Update Record step to retain the existing inputs. I believe I need multiple inputs, because I need to only add linked value “M” to records that include “Monday”, and only add “T” to records that include “Tuesday.”
