I am creating an Appian Application that has Data Model based on CDTs (SQL Server Tables and Views).
For the Record List Page, I have created Record Type from the CDTs which is sourced from a SQL Server View. The main ID on the list page is hyperlinked to navigate user to the Record View Page of the record in the same Appian Application.
However, I have a second column in the Record List Page, which contains the ID of a Record List View Item from another Application. I want this ID Hyperlinked as well, which navigates the user to Record View Page of another Appian Application through this Hyperlinked ID.
On the backend, I have simply created a Database View in SQL Server which contains ID of of both record item i.e. the individual record in the new application and the existing record in the old application. But on the front-end, I am not able to discover a way through which I can hyperlink the ID in the second column which navigates user to the Record View of the other application.
Is there anyway through which I can handle this? Thank you in advance.
Discussion posts and replies are publicly visible
use a!richTextDisplayField with richTextItem() and configure its link property with a!recordLink() where you pass the record and the ID. Did you try this? What problems are you facing?