I’m running into an issue in automations in multiple ways.
Ultimately I’m trying to have an email sent to a list of collaborators that are listed in various collaborator fields when a certain condition is met. One of those fields will always be filled but not all of them. When all three are filled, I don’t have any issues but when just one is empty, the automation fails to construct that element.
I tried creating an automation that would essentially copy any collaborators from the other two fields into the third but that also has issues when any one of them are blank.
The idea is a student behavioral tracker. One staff submits the issue (the “Submitter” collaborator field always filled with one staff member), other staff members may be “involved” (the “Additional Staff Involved” collaborator field which could be empty), and still others could be notified but are not involved (the “Staff to notify” collaborator field). I’d like all collaborators in any one of the fields to be notified and not need the submitter to add everyone to the notification field. I tried copying the submitter and additional staff fields into staff to notify but it throws an error if the staff to notify field is already blank (I added that as an input in case there are existing choices here).
Any ideas for a workaround? Is this a bug? I don’t have any issues creating automations with other blank fields, so far just this. (I did also run into this issue with a multi select trying to have it create a list of the names included, but when it was blank…threw an error.) Perhaps the list building feature doesn’t account for empty fields? Airtable devs, is this a feature coming down the line? Shouldn’t it throw an empty array, and if it is already, can the automation gracefully handle that empty array?