"Select a field to lookup" does not show URL fields as an option

I have a table that has a column “Link to Sample” that I originally planned to set as having a “URL” datatype.

Screen Shot 2022-05-25 at 8.08.00 PM

Unfortunately if I have the datatype set to URL, it actually doesn’t show up in the “Select a field to lookup” list as an option to select.

If I make the datatype a “Single line of text” it’s fine.

I was just wondering if URL datatypes are supposed to be omitted from the list of lookup fields, is this expected behavior?

Screen Shot 2022-05-25 at 8.01.28 PM

Hey @michael ,

Thanks for spotting this! This is a bug in our code generating this dropdown, under the hood lookup fields can do this easily. I’ve created this issue to track it being fixed: URL Fields don't show in lookup field target select menu (#984) · Issues · Bram Wiepjes / baserow · GitLab

For now you could instead create a formula field with the formula lookup('Sample', 'URL Field Name') and this should work and act exactly like a lookup field of an URL.

2 Likes

I updated the field to your suggestion and it worked. Thanks for the work-around!