'Hyperlink' table values to relevant URLs

I'm displaying some 'ID' values in a table, these IDs correspond to orders that can be accessed at https://orders.com/[ID.value]. How can I display these ID values, but have them link to the relevant URLs when clicked on?

The ID values and URLs are all present in the data for each entry, stored as separate values.

The best I can manage at the moment is one 'number' column with the ID values and another separate 'link' column with the URLs. Hoping I can condense this!

Thanks!

There are several ways you can achieve this.

One is by changing your column type to URL and use something like https://orders.com/{{currentSourceRow.id }} to build the url.

Alternatively, you can use the mapped value option in the column if you want the whole url to show.