Hello! I was able to successfully reproduce the random number generation using a button in Groov View. My next task is to have a button in Groov View that executes a MSSQL query. A few weeks ago, in this post, I got everything going in terms of having Node-RED connect to our SQL database and populating values into my PAC Control strategy variables.
In the last part of the above post (control flows with groov View), the function node labeled as DO ACTION should obviously be replaced with the SQL query nodes from my other post, but that is where I am stuck. My flow was starting with an Inject node then followed by an MSSQL node then the PAC write node. I believe I can put some JavaScript into the function node that will name the location, password, etc. of the database and also put the SQL query in there, but that’s a bit over my head (I have no JavaScript experience whatsoever). If possible, I would prefer to skip the function node and use the Inject node like I had been doing originally, but Inject nodes do not have input connections and therefore I do not believe I can use it.