Solved: Issue with column name in export CSV file - Page 2

Ernest_Lau1 · 04-09-2024 08:31 PM

Hello, my app needs to generate a CSV file that conforms to a template provided by an external application. I am having issues with matching column header with the template.

The template requires a column name = ContactName

I have used the same in a column in my table (i.e. ContactName) but have specified the 'Display Name' for this column to be 'Requestor' which is more appropriate in my app.

When I export the data, the CSV file shows the column header as Requestor which would cause problem when the file is imported by the external application.

I have tried imposing the condition below in the Display Name :

IF(CONTEXT("VIEW") = "Filtered data for export", "ContactName", "Requestor")

The result is in the concerned view, the column header shows correctly "ContactName", however, when the date is exported, the column header in the CSV file continues to show Requestor.

Need help to resolve this please. Ideas and advise on how to resolve this would be very much appreciated.

Thanks.

TeeSee1

Since the view name does not exist (at least system does not seem to match any name) during CSV export, you should change your expression to something like

IF(
 IN(CONTEXT("VIEW"), {"view1",//list other views that you want to see Requestor//}
 ),
 "Requestor"
 "ContactName"
)

View solution in original post