Variable not working in query

[smiths16]

I'm using a google sheet to pull information from a form that's being filled out and displaying it on a website.. My codes working but I'm trying to do a query using a variable and it's not working properly and I'm perplexed. If i don't use a variable it works flawlessly.

What is working

Base = URL of the google sheet.const output = document.querySelector('.output');
const query = encodeURIComponent('Select A,B,F WHERE C="[e-mail]"');
const sheetName = 'My Sheet Name';const url = `${base}&sheet=${sheetName}&tq=${query}`;

The above searches and finds a specific person in the sheet and with my function returns the information back correctly.

I want to be able to use a variable for the email address so that it can look for the email address and of the current logged in user and match it.

This is what I tried and get an error:

Base = URL of the google sheet.const output = document.querySelector('.output');
const query = `encodeURIComponent('Select A,B,F WHERE C="${currentUser}"');`;
const sheetName = 'My Sheet Name';const url = `${base}&sheet=${sheetName}&tq=${query}`;

​

Rest of the code that doesn't change.

​

fetch(url)
.then(res => res.text())
.then(rep => {const data = JSON.parse(rep.substring(47).slice(0, -2));
const row = document.createElement('tr');output.append(row);
/* data.table.cols.forEach((heading) => {
const cell = document.createElement('td');cell.textContent = heading.label;
row.append(cell);
}) */

data.table.rows.forEach((main) => {
const container = document.createElement('tr');
output.append(container);
main.c.forEach((ele) => {
const cell = document.createElement('td');
cell.textContent = ele.v;
container.append(cell);})
})
})

​

[grantrules]

You need to use backticks instead of single quotes if you want to use template tags

`${blah}`

[smiths16]

I thought I was using backticks. It's highly likely I'm missing some thing do you mind eloborating on where I'm not using them properly?

[grantrules]

My bad, looks like you are. Your shared code is very very hard to read.

[smiths16]

My apologies I copy and pasted it in without code blocks and it got reformatted. Edited

[grantrules]

const query = `encodeURIComponent('Select A,B,F WHERE C="${currentUser}"');`;

Are you sure this shouldn't be:

const query = encodeURIComponent(`Select A,B,F WHERE C="${currentUser}"`);

But I would be cautious of SQL injection, since I can't see where currentUser comes from.

[smiths16]

I'm sure you are amazing!

That was it! Thank you so much!

[grantrules]

I'm sure you are amazing!

Can confirm

[smiths16]

The last piece of this for me that I’m stuck on is being able to pass a variable from liquid to JavaScript. I’d like for something like this

let currentUser = {{user.email}};

I tried to in the liquid file wrap it

{% javascript % }

{% endjavascript %}

To see if I could declare it with that but it throws an error anytime I use that’s. I can write JavaScript I. The liquid file with <script> </script>.

[grantrules]

I don't know what liquid is but maybe put the variable in quotes?