Difficulty with TextBlaze / DataBlaze Integration

Hello,

I am trying to use DataBlaze to select numbers from a table and integrate them into a written output snippet. I have built the snippet, but when I run it, the numbers do not appear in the written text output (just blank spaces) even though they do appear in the drop downs when I run the snippet. Can you please let me know what I am doing wrong? Thank you!

The {formtext: name=number} model examined variance in {formmenu: word reading accuracy (WRA) growth; default=word reading fluency (WRF) growth; text reading fluency (TRF) growth; the prevalence of phonology-based oral reading errors as measured by the ratio of phonology errors to orthography and attention errors; the prevalence of orthography-based oral reading errors as measured by the ratio of orthography errors to attention and phonology errors; the prevalence of attention-based oral reading errors as measured by the ratio of attention errors to phonology and orthography errors; name=outcome}. The first regression model with the predictors of LWID and WA accounted for 23.4% of variance, F(2,57) = {dbselect: SELECT F FROM Q1M2 WHERE contains(Field 1, "Block"); space=36CaSBNpQow4vvWPj4Y9yU; multiple=no; menu=yes}, p {formmenu: =; default=<}{dbselect: SELECT Sig. FROM Q1M2 WHERE F = @f; space=36CaSBNpQow4vvWPj4Y9yU; menu=no}. In this model, LWID significantly positively predicted ΔWRA (β = {dbselect: SELECT R FROM Q1M2 WHERE startswith(Field 1, "B1 LWID"); space=36CaSBNpQow4vvWPj4Y9yU; menu=no}, t(57) = {dbselect: SELECT F FROM Q1M2 WHERE startswith(Field 1, "B1 LWID"); space=36CaSBNpQow4vvWPj4Y9yU; menu=no}, p = {dbselect: SELECT Sig. FROM Q1M2 WHERE startswith(Field 1, "B1 LWID"); space=36CaSBNpQow4vvWPj4Y9yU; menu=no}), such that for every unit increase in LWID there was corresponding a {dbselect: SELECT R FROM Q1M2 WHERE contains(Field 1, "B1 LWID"); space=36CaSBNpQow4vvWPj4Y9yU; menu=yes} increase in the difference of the sample-based scaled score of{formmenu: WRA between time 1 and time 2; default=WRF between time 1 and time 2; TRF between time 1 and time 2; ratio of phonology errors to orthography and attention errors; ratio of orthography errors to phonology and attention errors; ratio of attention errors to phonology and orthography errors}.

Hi Jody,

Thanks for posting, and welcome to our community.

Just including the dbselect will not make the content appear in your snippet.

The Read from table command only presents the fields being read. You have to click on the field to add it to the snippet. To do this, you can give each dbselect a name and then click the field. Here's an example:

Jun-09-2023 15-27-01

Here's what it would look like in your snippet with each dbselect being named:

The {formtext: name=number} model examined variance in {formmenu: word reading accuracy (WRA) growth; default=word reading fluency (WRF) growth; text reading fluency (TRF) growth; the prevalence of phonology-based oral reading errors as measured by the ratio of phonology errors to orthography and attention errors; the prevalence of orthography-based oral reading errors as measured by the ratio of orthography errors to attention and phonology errors; the prevalence of attention-based oral reading errors as measured by the ratio of attention errors to phonology and orthography errors; name=outcome}. The first regression model with the predictors of LWID and WA accounted for 23.4% of variance, F(2,57) = {dbselect: SELECT F FROM Q1M2 WHERE contains(Field 1, "Block"); space=36CaSBNpQow4vvWPj4Y9yU; multiple=no; menu=yes; name=db1}{=db1}, p {formmenu: ; default=<}{dbselect: SELECT Sig. FROM Q1M2 WHERE F = @f; space=36CaSBNpQow4vvWPj4Y9yU; menu=no; name=db2}{=db2}. In this model, LWID significantly positively predicted ΔWRA (β = {dbselect: SELECT R FROM Q1M2 WHERE startswith(Field 1, "B1 LWID"); space=36CaSBNpQow4vvWPj4Y9yU; menu=no; name=db3}{=db3}, t(57) = {dbselect: SELECT F FROM Q1M2 WHERE startswith(Field 1, "B1 LWID"); space=36CaSBNpQow4vvWPj4Y9yU; menu=no; name=db4}{=db4}, p = {dbselect: SELECT Sig. FROM Q1M2 WHERE startswith(Field 1, "B1 LWID"); space=36CaSBNpQow4vvWPj4Y9yU; menu=no; name=db5}{=db5}), such that for every unit increase in LWID there was corresponding a {dbselect: SELECT R FROM Q1M2 WHERE contains(Field 1, "B1 LWID"); space=36CaSBNpQow4vvWPj4Y9yU; menu=yes; name=db6}{=db6} increase in the difference of the sample-based scaled score of{formmenu: WRA between time 1 and time 2; default=WRF between time 1 and time 2; TRF between time 1 and time 2; ratio of phonology errors to orthography and attention errors; ratio of orthography errors to phonology and attention errors; ratio of attention errors to phonology and orthography errors}.

Let me know if this works for you and if you have any questions. Have a great weekend!

This section of our guide explains it as well.

Hi Dylan,

Yes, this helped! The text is only inserting with brackets and quotations (see example). Is there anyway to make it only insert the number instead of these characters? For example, I want it to appear as 13.365, not ["f"; "13.365"].

Thank you!

@Jody_Gregory I'm going to recommend something a little different than Dylan. Instead of using the "name" field that Dylan shows in his gif, you should instead apply unique nicknames to each variable it creates.

If you look at your dbselect commands, you're selecting a few fields twice, and they end up named the same thing (for instance, there are two cases of SELECT F and SELECT R).

I would rename those instead to uniquely-named variables (F1, F2, R1, R2 for example), and then use those variable in the locations where they need to be like Dylan had instructed.

You can do that by updating the dbselect commands in the snippet, either through the right side bar's settings (see below) or changing the text to SELECT F AS newvariablename

Screenshot 2023-06-09 at 2.05.22 PM

{dbselect: SELECT R as R2 FROM Q1M2 WHERE startswith(Field 1, "B1 LWID"); space=36CaSBNpQow4vvWPj4Y9yU; menu=no}
To then use that field, I'd write {=R2}

This might be easier to explain over a call, reach out to me andrew@blaze.today and I can help out.