Data Blaze Help

I'm very confused on how I can use data blaze to solve this problem. Any help would be appreciated. I'm trying to avoid having to use a very long if/then condition and instead use datablaze to fill from a table.

Essentially, I have this table

I want it to auto fill from a data blaze table I made that looks like this. Where the first column is the SS number and the second number is the output.

I want to be able to inout a number into the SS Phonemic Proficiency text box and have it access the data blaze table, find the output that is associated with that number and insert that number into the percentile rank box. So for example, if I entered 127 as the value for SS Phonemic Proficiency, the ranking box would display 96. For whatever reason, I can't seem to make this work.

Any tips are appreciated, thank you :slight_smile:

Hi,

Thanks for your post. I created a quick example showing you how to do this. Essentially you would need to use the conditions field in the Data Blaze Read command, to filter the output column by the value of the SS number column. This guide explains conditions in depth

Here is the link to the snippet and table I used. I would be happy to schedule a live call to show you how to set this up with your specific table. Feel free to email me at alexander@blaze.today to set something up.

Best regards,
Alexander

Hi Alexander,

I appreciate the quick response. I still don't seem to be able to make this work. I will email you tomorrow about it.

Best,

Nic

Hi Nic,

Sounds good, I think it would be easiest to help you set it up over a meeting. Looking forward to hearing from you!

Best regards,
Alexander