I have created a read only grid using queried data. Now I want to export it to the excel sheet. Besodes, I am also able to export it to the excel sheet using export data store entity to excel smart service. The issue is I have a column active date in the database table as "date timestamp" but I want it as only "date value" in the sheet. And this should be done automatically when someone clicks export to excel. How can i achieve this formatting?
Discussion posts and replies are publicly visible
If you create your grid using Appian record, it will give you 'Export to Excel' functionality of record OOTB. For changing format of "date timestamp", you can create a custom record field.
But I'm not using Appian record to create grid. I was using view for the grid.
In that case you can create an Appian record from that view keeping 'Sync' disable. Use this record to create paging grid so that you can use OOTB export to excel functionality. Convert format of data timestamp in database view.
Still recommended approach is to use record sync(s). docs.appian.com/.../Records_Tutorial.html