Dynamic Values in SQL Query

Ask the community
1

Hi everyone! :wave:

I’m working on a project in Softr and need some help with the SQL editor. Specifically, I’m trying to pass dynamic values (like user inputs or variables) into my SQL queries. Is there a way to access dynamic values within the SQL editor to make my queries more flexible?

Any tips or examples on how to achieve this would be greatly appreciated! :pray:

Thanks in advance! :blush:

2

Hi there, while some others may be able to speak to this further (@matthieu_chateau @acjnas ) I’ll do what I can to help you!

You can pass fields from the user record like {loggedin_username}

You can also pass data from forms using our form submission events (Advanced Form Features – Softr Help Docs)

But otherwise, i’m not sure if you can access any other data. Hope this helps you!

3

I would also like to explore the possibilities we could have,
SQL support is very recent, there is still a lot to grasp in terms of user customization.