Oct 07, 2020 11:28 AM
It would be really nice to see automations be set to whatever conditions are specified, but allow it to still be built even if a ticket doesn’t exist that matches it yet. It’s a bit cumbersome to have to build a dummy ticket that meets each set of criteria just to move on to next steps.
being able to have the automation skip a field rather than stop would also be huge, I have multiple versions of the same automation now because I have to have one if Attachments is empty and one if it’s not versus just including attachments if present, or skip if empty.
Oct 07, 2020 01:13 PM
I agree that this would be very nice to have.
Oct 07, 2020 02:37 PM
I guess I don’t encounter this issue because I tend to use script actions to build automated processes. But even so, I wonder if there isn’t a way to combine these patterns. Perhaps you should share screen shots of the case where multiple automations are required to handle these conditions.
Oct 12, 2020 02:47 AM
Ah! I am looking at the community forum now because I need to figure out why my automation keeps failing, but only sometimes - is it because when building a new record, the entire automation will fail if any one of the fields I’ve defined happens to have no value in it?
Oct 12, 2020 10:13 AM
That depends on the how your automation was constructed. Perhaps you’d like to share more information here so that the experts can determine the cause.
Oct 14, 2020 03:14 PM
Hi @Bill.French I’ve found that seemingly simple automations keep failing - eg automaton that triggers when a record enters a view, then create a new record in a separate table, and populate it with data from fields in that first record.
I suspect because in some cases one of those fields contains null value?
I had expected that the automation would create that new record leaving any empty fields null, and populating the other field for which there is data available.
Oct 14, 2020 04:04 PM
Difficult to assess without knowing how [exactly] you are creating the new record and populating it with data from the first record. Is it a script automation?
Oct 15, 2020 09:29 PM
Hi @Bill.French its not a script - It’s probably the simplest automation imaginable where it triggers from a record entering a view, then uses the ‘Create record’ action to create a new record in a different table and populate it with some data from fields in the original record that triggered the automation - this approach seems to fail if/when on of those fields is null.
Oct 16, 2020 06:56 AM
Okay, I think it’s safe to say that any no-code automation instrumented purely by the Airtable UI and which references fields selectable in that UI to create the automation — should work even when encountering fields that are empty. Ergo, it’s reasonable to assume any empty fields referenced should create empty (null) values for the new target record.
If this were being written in a script automation, I would take care to ensure that null field values were accommodated to ensure the process wouldn’t crash, and therefore, so should the designers at Airtable.
That’s a lot of words to say - it’s probably a bug. :slightly_smiling_face: