Create dynamic hyperlink in a table

@SynopsisLabs can you share a visual image where you need the button ?

with SQL joins currently to click a button and open a detail page one way is to create a extra column in the query via CONCAT function like this

SELECT A, B, C, 
  CONCAT('https://mydomain.com/myproject-details-page?recordId=', project_id) as  project_url
FROM ...
JOIN ...
WHERE ...

then you use action button with open external URL and put the project_url