Create dynamic columns for the gridField based on the data.

Question

Hello, 
 I am new to Appian and have a requirement to create grid columns dynamically based on the data available in the database. I need to generate these columns dynamically according to the available data. Thank You..!!

Prasanta Paul · Answer

Query the data, Store the data in a local variable, use that local variable as grid data. 
 Else you can use the record as a grid data directly.

Prasanta Paul · Answer

a!gridField(
 label: "",
 labelPosition: "ABOVE",
 data: local!name,
 columns: {
 a!gridColumn(
 label: "First Name",
 sortField: local!name['recordType!GT CustomerDetails.fields.firstName'],
 value: fv!row['recordType!GT CustomerDetails.fields.firstName']
 ),
 a!gridColumn(
 label: "Last Name",
 sortField: local!name['recordType!GT CustomerDetails.fields.lastName'],
 value: fv!row['recordType!GT CustomerDetails.fields.lastName']
 )
 },
 pageSize: 16
 )
 }
)