Google Sheets Referencing Data without Special Characters #1348
-
Guys, I'm not a programmer by any means but I am usually pretty intuitive and I cannot for the life of me figure this out. My issue is that I have a column of data in a Google Sheet and I want to be able to pull the data all at once from the Google Sheet with each cell having it's own variable so I can use it in a forms block. However when I go to pull the data in my "data" referenced key Google Sheet it includes the whole HTML data not just the raw text format. For example when using: {{googleSheets.data.1}} I get [ "PF1AHP3B" ] To be able to pull all the data and do what I need, the Loop Data is very inefficient. I just need to be able to pull the data how the Loop Data function is in raw text but while using the googleSheets variable command (or smth like it) Any ideas?? I have spent way too many hours on this. |
Beta Was this translation helpful? Give feedback.
Replies: 1 comment
-
Solved eventually like so: I'm not highly skilled but using Regex commands was able to turn a variable that was set to 123456789qwertyz!@#$%^&*() into 123456789qwertyz using the following: const inputText = automaRefData('variables', 'gpt') |
Beta Was this translation helpful? Give feedback.
Solved eventually like so:
I'm not highly skilled but using Regex commands was able to turn a variable that was set to 123456789qwertyz!@#$%^&*() into 123456789qwertyz using the following:
const inputText = automaRefData('variables', 'gpt')
const outputText = inputText.replace(/[^A-Za-z0-9]+/, "");
automaSetVariable('gpt1', outputText)
automaNextBlock()
https://user-images.githubusercontent.com/141815049/272337656-5eb631e2-bd2a-463d-900f-291ed4769c5a.png