Is it possible to use CONCAT function for links?

[Junard]

We have a tracking system that tracks case submissions regardless if it is a valid submission or not. There are 2 case ID fields. Field1 is an autolink of case IDs that are valid submissions. It links directly to the case itself (other database). Field2 is a autonumber for invalid submissions. No case created hence the autonumber as its case number.

In a table view, we can to display the Case ID to one column only. We are using CONCAT function to concatenate the Field1 and Field2. We are encountering the following error for Field1 in the table view:

Expression: [CONCAT("<a href="https://xxxxxx"target="_blank"></a>", "xxxxx")] could not be calculated, Unknown operator '://' at position 23

[fbunting]

One thing that jumps out is that your double-quoted string itself contains double-quotes ... which may be why it encounters the double-slash outside of the strings, and tries to interpret it as an operator.

Perhaps if you change the double-quotes to single quotes.