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
