I have a requirement to show a record with a hyperlink in excel after exporting to excel just how we show in a grid with record link. After clicking on this link in excel it should open this record. Is it possible to implement?
Discussion posts and replies are publicly visible
hi Mayuri Mestry Yes it is possible, AFAIK
Excel only supports one link per cell. If multiple links are provided, Appian will export the link label followed by each link URL as text in parenthesis.
All link types will export as expected except for these three:
Dynamic link, start process link, Authorization link. These link types will be exported as text.
Are you talking about the record export option or custom export options?
I am talking about record export. I need to export my records in such a way that Record ID is a hyperlink in excel and after clicking on each hyperlink, the relevant record opens in browser. How can that be implemented?
In that case what Abhishek has mentioned is the answer. You would not need to do any additional work if you have configured the Column value with the link field having the record link which directs to the record summary.
hi Mayuri Mestry you can use this code in your grid column
a!gridColumn( label: "Id", value:a!linkField( links: a!recordLink( label: your record Type Field recordType: your record Type identifier: fv!identifier )), align: "START" ),
Hi Abhishek Karumuru , I need a link in exported excel. The Identifier in exported excel should be a link instead of text. And that link should redirect to the current identifier summary screen.
hi Mayuri Mestry could try this and let me know please
a!gridColumn( label: "Id", value: a!richTextDisplayField( value: a!richTextItem( text: a!urlForRecord( recordType: your record type, identifier: fv!identifier, targetLocation: "TEMPO" ), link: a!safeLink( uri: a!urlForRecord( recordType: your record type, identifier: fv!identifier, targetLocation: "TEMPO" ), openLinkIn: "SAME_TAB" ), linkStyle: "STANDALONE" ) ), align: "START" ),