I'm new to BTT and think it's a very impressive app, but I'm also a bit overwhelmed by its possibilities.
I would like to copy data from a Numbers spreadsheet into a custom database on the internet. The data has to be entered in specific fields in the database and BTT should be able to choose items in a pulldown-menu (for categorizing the data).
Is that kind of automation possible with BTT? If so, what would be the best way to start?
You could maybe do this with BTT, but first consider exporting the data out of Numbers into a CSV file, then importing it into your target database. This will save you a ton of time.
CSV is standard for data exchange between spreadsheet programs, so it is likely that the target database will support it.
@telephant is definitely right, you should try to work directly with the data instead of trying to achieve something like this via UI scripting or similar.
Using AI it is probably easy to create a script that extracts the relevant data from your spreadsheet, you can then call such a script from BTT.