I am looking for suggestions on the best way to do the following.
We want to run an essay contest where a member can go to a Marketo landing page with a form to fill out their information, copy and paste their essay into a field in the form.
In my testing the essay field is a text area and since we are limiting the essay to 800 words, it should handle the 30,000 character maximum.
The form works, the problem is downloading the list of people with their essays. This list is created by a smart list. When downloading the list we are limited to a tab delimited or a csv. When I open it the essays will not be contained in their cell because either a carriage return is recognized as a tab or a comma in the essay moves the copy into a cell.
Is there a better way to go about this? Is using a text area to hold the essay the best field to use? Is there another option for downloading a list besides tab delimited or csv?