How can I use Automations to update a field in the same table as the trigger?

Yes it is quite possible. Even QB Actions, and Webhooks can do that. In the Action, choose the "other" table (where is says advanced...) then select the same app and the same table and in the conditions, select where Record ID# = Trigger:Table:Record ID#.