Using retrieved website data as condition for Datablaze output

Questions and Help
1

We work with 30+ brands and I have made a DataBlaze sheet with all the info needed such as links, terms and conditions, email addresses etc. and currently manually select the brand# needed ,

In zendesk there is a field from which I can retrieve the brand# , is there a faster way to auto choose the brand# from the database than using 30+ if else statements?
For example if {site: text} matches the first column (brand#) of the data base to automatically output the corresponding link, address etc. ?

Or maybe have the retrieved brand# autofill in the DataBlaze dialog box?

2

Hi Donald,

I created the snippet below and in the dbselect command, I added a condition that makes sure the brand # read from Data Blaze is equal to the one read by the site selector in Zendesk.

In the example I created, I used a selector for a tag in Zendesk (the tag would equal the brand number), but you can change the selector to the field that you use to retrieve the brand #.

Here's the snippet & example space. Please update the site selector in the form field and let me know if this works for you.

Here's a video showing it being used:

3

Hello, Sorry for the later reply.

Thank you for the help, it's working great now, my mistake was not giving the selector a name, and as such not being able to use it as a conditional in the data blaze read.

Happy Holidays!

1 Like