Website info into text box

Hello!
I am using Datablaze to compile inputs from our Textblaze commands into Google sheets that then pushes the info to other places. An issue that I have run into is that the only data that pushes is if there is a manually filled out text box. Ideally, I would love to be able to use the Insert Website Information formula to first grab the info from the website, and then that be pushed over to Google sheets once the command is entered. But since it is not a manually filled in textbox or dropdown, that info does not push over. Is there a way for me to have the website info maybe push to a textbox which would then allow me to push it over to the other places? This would also be helpful if it grabbed the info from the site and put it in Textbox first because every so often I need to alter the information before inputting it, so being able to backspace or add to the Website Info pull would be great.
Any workaround ideas are greatly appreciated!

Hi @Allison_Fountain

Welcome to the community! Pleasure to have you here. There is a command called {site:text}. This captures all the page in text format. From there, you can extract any piece(s) of it you wish, using regex, assign those extracted values each a unique variable name, then push those values out wherever you would like. I do this all the time in our snippets. Glad to help if you'd like!

Thank you,
-Brad :fire:

Hi Allison,

To add to what Brad said, here is a quick example snippet of how to assign website command content to a variable and insert it as a row into Data Blaze. It also shows how to put site content into a text box by naming the text box the same name as the website command variable:

{formparagraph: name=site_content}
{site_content={site: text}}
{dbinsert: INSERT INTO test SET company=@site_content; space=54iU5ZhvT8zFurUYH6RMhE; autoaddfields=yes}

Let me know if you have any questions!

Best regards,
Alexander

Pretty neat idea Alexander - I like being able to grab all the site text and toss it into a DB row. I can think of some useful scenarios for that right away. Thank you! -Brad

Hello @Brad_Hedinger and @Alexander_Cornett. I hope you both had a great weekend!

Thank you very much for these answers. This is exactly what I was looking for and works perfectly!

That's great to hear, Allison! The community here is wonderful. Keep plugged in and I think you'll find it one of the more engaging and helpful communities out there. Especially from the Text Blaze support team. Speaking for myself - I've never worked with a team as customer-centric as these folks. They truly listen to their users feedback, ideas, calls for help, you name it. Anyhow, welcome again, and don't be a stranger!

-Brad :fire: