Google Sheets: Issue with Formula in Table referencing value in same row by column name

I share here an issue I have faced with Google Sheets when using a formula in a Table that references a column by name.

Problem / Use Case Description

The behavior is not similar to Microsoft Excel.

The structured reference Table[Column Name] refers to the whole column and not the value of the cell of the named Column in the same row as the current cell in the table referring to it. (Contrary to Excel [@[Column Name]]

What I could find about this issue in the Internet are these 2 references:

https://www.mrexcel.com/board/threads/reference-cell-value-in-same-row-by-assigned-name-in-google-sheets.1258517/

https://www.benlcollins.com/spreadsheets/tables-in-google-sheets/#comment-292606

unfortunately without solution

Solution/ Workaround

I haven't found a clean solution.

My current workaround is to cast the column with a string function like LOWER or UPPER as shown below:

=HYPERLINK(CONCATENATE("https://www.",LOWER(Books[Purchased at]),"/dp/",UPPER(Books[ASIN])),"Link")

I have submitted a Feedback/ Request via Help -> Help Sheets Improve

If you know a solution please comment below.

See also

https://dataful.tech/google-sheets/tables/#features-table-references