Trying to use a text field in a database as a URL

Hello. I am new to Bubble but loving it!!
I am stuck on the most basic thing. I have a list of events, each with a set of datapoints. One of them is a text field containing a URL. I want to use this url behind a text field to take people to an external page on a website, different for each event.
I am getting an error message that the address is invalid. How should the text be formatted to be used as a URL?

Can someone help? I don’t want to use an image so I cannot use workflow. And the method I am using is clearly not working. Weird. I would think this is quite trivial. Thanks in advance

Use a button and then in workflow, open external website and add link there, check open tab in new window if you want.

Thanks but still not working. How should the url in text format be formatted? Does it need to contain https:// or not?

Can you show the screenshot of the tab which you are being sent after clicking on the button

I found a solution. It involved searching for a specific row in the database and then using the url. Felt complicated but I am new to this and it now works. Thanks for taking the time to reply

1 Like