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?
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.”