leek | GA tracking - Initial implementation was based on Insight

I've written some JavaScript function (selectMeal) to loop 7 times randomly selecting 1 item from an array (tempMealList) then push the item to another Array (dinnersPicked). Once the items been added to the new array (dinnersPicked) it's then removed from the original array (tempMealList) to avoid it from being selected again.

In the console, each run of this function (selectMeal) yields no issue, but when I trigger the function on a button click in HTML, each time the buttons clicked the array being used seems to be permanently altered, with the items randomly selected on the first run of the function not being considered on the second click and similarly for any successive click, any item previously shown is not considered.

I've tried to resolve this in the function by redefining the variables at the start of the function to reset the array being considered on each click but this doesn't seem to work.

What am I doing wrong and how can I make sure that with every click the original array is considered?

Here is the code:

I am creating a kind of dictionary where a user enters an input value and the output in different languages/ways are showed in multiple different fields.

1 input can have multiple outputs. The output is already stored against specific input so if a specific input is present, its specified output is displayed

I am using the below code(s).

HTML

I'm trying to filter a dataframe based on a list of character vectors and to obtain an output for each of those vectors. Here is an example to clarify my problem:

This is the type of data I have

BigQuery supports:

1. User Defined Functions (UDFs) in SQL and JavaScript.
2. Analytic functions that compute values over a group of rows and return a single result for each row. These functions can be used with OVER clause. There is a predefined set of analytic functions.

The question #1: "Does BigQuery support analytic user-defined functions?"

The motivation behind this is that I want to implement the split-apply-combine pattern that is usually seen in Python pandas code. This could be useful for in-group normalization and other transformations that use group statistics.

I did a small test in Standart SQL:

Here's my SQL:

I am making a random meal generator that uses the API The mealdb and the results that come back are something like this.

I have this table

I'm trying to deploy my app on Heroku and I'm getting a type error when I npm run migrate on heroku run bash. The error on the terminal is saying that it's a SQL typo error but I cannot see what is the error. I've tried to change the quotes, but it's not working either. Any help will be welcome.

error:

Goal: create a Google Calendar event.

Blocker: the date formatting.

background: I'm trying to create a meal planner that takes recipes from a given database and creates events with their name in a google calendar. The database looks like this: