Welcome to the Airtable community!
No, it is not possible to have a custom extension run automatically in the background.
In order for a custom extension to run, it dashboard must be open.
If you want code to run automatically in the background, you can use a scripting action in an automation. If a script is too limiting, you can pair the action script with an outside service.