I am using below logic to convert and display Source location ID to Source Location name in Read only grid but when am using same logic while downloading Excel sheet. Its providing me Source location ID instead of Source Location name. Is there any way how i can get Source Location name in Excel Sheet.
a!gridColumn( label: "Source Location", sortField: "SourceLocation", value: { rule!ABC_DE_getLocationNameBasedOnLocationId( locationId: fv!row.collectionfromlocationid ) },
Discussion posts and replies are publicly visible
I recommend using a Record Type grid because you can export the contents of your grid without any additional configurations and your field formatting will also get exported. https://docs.appian.com/suite/help/20.4/Paging_Grid_Component.html#read-only-grid. This means you should create a record type for the table backing your data and then use interface design mode to create the grid as it's much easier than doing it from scratch.