Skip to main content
A
akshayg0006
Inspiring
January 11, 2021
Question

Excel sheet issue

  • January 11, 2021
  • 1 reply
  • 0 views

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
)
},

    1 reply

    danny.verb
    danny.verb
    Brainy
    January 12, 2021

    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.

    Terms & ConditionsAccessibility statement