Home > Forum > Data sources > Data table field not working

Data table field not working
0

Hello all,

I have a data table field where I'm selecting the fields using a SQL query. One of the field is a picker and I want to show just the Text and not the ID.
I've tried many options but as soon as I try using the Database-Name, it's giving errors. I believe it's because the option has space on it : 'Non Ok'.
But the system should overcome this right? Even using the DBO function, it doesn't work.
Adding quotes is not allowed. I'm running out of ideas.

Did this happened to any of you?

Did you know that with WEBCON you can automate virtually any process? Even baking cookies 🍪
 
Speaking of cookies: we use the ones that are essential for our website to function properly, as well as additional ones that help us customize our content to your preferences. If you don’t mind cookies, click Accept. If you want to learn more, explore settings.
Settings