I have created an automation button called transfer for a database in a space:
The button action executes correctly when executed from a button press using the transfer button made visible in a view of the database:
When the button is executed from the Actions button in the space design view, the feedback is that the action was executed successfully but the action is not triggered: