Airtable silently rolled out a cool new feature in automations. You can now specify the “user who took the action”.
I think they meant to say the “user account that triggered the automation”.
But nonetheless, a very cool new feature!
Airtable silently rolled out a cool new feature in automations. You can now specify the “user who took the action”.
I think they meant to say the “user account that triggered the automation”.
But nonetheless, a very cool new feature!
It isn’t necessarily the person who triggered the automation. The person may not even realized he triggered the automation. He may have just changed a field value that updated a formula that triggered the automation.
I haven’t tested to see what happens with automations based on conditions of a formula with a time based formula like NOW() or TODAY(). But I generally avoid those formulas anyway.
I first found out about this feature here.
If they change a field that updates a formula that triggers the automation, their name would still show up as the user, correct? I guess we should test and find out!
Yup. At least that is what happened in the quick test that I did. It didn’t work when I was testing the automation, but it did work in the live automation.
So this is useful for far more than just interface buttons.
I have not tested if a “when record created” automation brings in who created the record, but I suspect that it should.
Yep, this is a very cool feature. And thank you for testing this!
Interesting that it works with the live automation, but not during testing.
But this does seem to confirm that it is the person (i.e. user account) who triggered the automation — whether they realize they triggered it or not. Of course, the “person” could be any user account or service account that is linked to a Personal Access Token.
Just tested with “when record created”. It works when I create the new record in an Airtable grid view. It does not work when I create a record using a form view, even when I have the form setup to identify who submitted the form. Maybe a bug.
Wow, very interesting! Great job catching that! Yeah, it seems like that might be a bug.
I updated my original post above to say “user account” instead of “user”, which is what I originally meant. I think I confused @Kamille-Parks as well on yesterday’s podcast, because I was saying “user” instead of “user account” (which could also include a “service account”).