How to run HTML macro script in edit mode?

[Miguel P]

So for certain Confluence pages with a template table, I want to create an HTML macro script that allows users to click a button and autopopulate cells in the template table with data retrieved from an API. The issue is that I want them to be able to do this inside the edit mode, so that they click the button and the changes are saved to the Confluence page.

The issue I'm running into is that the HTML macro doesn't seem to "run" while in edit mode, so I cannot get the script to run in edit mode and therefore I can't save any changes the script makes to the table.

Is there any way to get around this? Is it at all possible to get the macro to run in edit mode?