Struggling with If/Else pulling from Data Blaze with empty fields

Questions and Help
1

I've tried a dozen different ways and read the thread, but I can't get this one figured out.
I have a Data Blaze Table. For some of the text fields, I want the If/Else field to evaluate if it is empty or has data.
If it has data, it would insert a field - then TAB
If it's empty, then it would just TAB
What am I missing?

2

Hey @JGnTX welcome back to the forum! :slightly_smiling_face: Does something like the following work for you:

{note} Loading data
{dbselect: SELECT Name, Count FROM Table1; space=id; menu=yes}
In the next part we do the if/else on the data:
{endnote}
{if: name<>""}{=name}{endif}{key:tab}

3

Hey Gaurang! Thanks for the help - it's a good sign that I haven't been here - it means I'm getting better at figuring things out!
I'm not sure it does. Here's what I have:

{if: `ta-name`=""}{=`ta-name`}{key: tab}{else}tab{endif}

I want it to fill in the ta-name if there is one in the DB -or- skip the field if there's not a record in the DB.
Thanks again for an amazing tool

4

The if condition you have shared is:

`ta-name`=""

It should instead be using the not equals operator:

`ta-name`<>""

Let me know if it works for you.