I’m running a school and trying to automatically generate a sheet that shows which students will be in attendance on which days. We have several part-time options, for example, someone can come Mon-Tues, others may come Wed-Friday, some Mondays only…
For reason that seem unnecessary to explain here, I’m using Jotform to collect initial info, so I’ve created an automation that searches the field Jotform populates (Days attending. Looks like “M; T”, etc.) for “M”, and the action it takes is to select “M” from the linked field of days attending.
It worked great. Then I created one for Tuesday. It also worked great. Except that if someone is attending Monday AND Tuesday, one will cancel out the other. How do I get it to put in BOTH?
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.