Add new record in mysql depending of multi select values

[bradlymathews]

The first thing I see is trMakeBulkInsertArray is not a javascript transformer, it a javascript query.

Here is a post with some info on transformers and when you use them over queries:

Tip for writing transformers - Retool scope

Another tip about proper use cases for transformers I discovered that isn't spelled out in the docs clearly enough for those of us of the more mentally addled persuasion. Transformers are reactive and will run on page load and whenever the values change so you can't really use them like functions. So if it OK that they just run whenever until you get around to needing their bounty, or you always want their .value nice and fresh just in case then transformers are your ticket. If you onl…

Another thing to note, you can't put the code into the Transformer of the bulk insert query, that only executes after the query finishes running.