Home > Forum > Data sources > link to a selected element in the choice field (SQL data source)

link to a selected element in the choice field (SQL data source)
0

MVP

Hi,
I have a choice field with SQL data source connected to it.
Is it possible to create a link (into the choice field) to a selected element like as in the case of BPS Internal view?

Simplify, I need the same option as in the selected screenshot but for the sql data source.

MVP

Hi Jack,

there's an "old" way to achieve something similar.

Since I don't know the syntax I'm always using this approach:
1. Create a data row/table and activate the 'Functions' tab.
2. Select the correct hyperlink function.
3. Setup some dummy parameters
4. Click on show to see generated statement.

Afterwards I will modify the statement to fit my needs.

This should also work in the SQL data source.

Best regards,
Daniel

MVP
In reply to: Jacek Wojnar

thanks Daniel - I don't know if I understood correctly but unfortunately it doesn't work for me :(

I'm sorry, I should have put a little bit more thought into it before I answered: Now I have only caused confusion. There's a reason why I added a similar user voice in the past..

This works only in data rows and table but not if it's used in a choose field.

Best regards,
Daniel

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