New Line .csv export
I am trying to export a file.
This export is coming from a layout that has many fields; April, May ... Dec ... Mar. Next to each month horizontailly, I've got five fields that I would like to export with a row for each month.
How do you tell file maker you want a new row in the .csv export file. I created a field and enterd a calc "Code(11) but that only created a carriage return within each fields, nice to know but now what I need.
Can someone guide me here, how do I create new row exporting data. Current, all 60 fields ( 12 x 5 ) is exported on one line.
I've attached a .pic of my export window showing were enter my field to tell filemaker to create a new line but is doesn't seem to work correctly.
Any help would be grateful.
Easiest way to start a new row is to structure your data so that each row is from a different table. From what little I can see here, restructuring your table might well be a good idea for more reasons than just the data export.