Maintaining formatting from form to export

  • will2016

    (@will2016)


    9 years, 1 month ago

    Hello,

    On our user input form we have two date fields. We are using Fast Secure Contact Form. When we export our data from CFDB into an XLXS format, they are exported from CFDB as “General” fields.

    We set the date fields on our FSCF to “date” format, but that does not seem to carry over to CFDB, or else it is not exported as that to XLSX, not sure which.

    Is it possible to have data inputted to CFDB from FSCF in “date” fields to be exported as “date” formatted fields into an xlsx spreadsheet?

    We’re trying to automate our process as much as possible, but right now we have to reformat each datefield column we export so that when we mailmerge, the dates come out correctly. They do not appear as dates in our mailmerge document if the fields are formatted to “general”, they appear as “12:00:00am”.

    Thanks

Viewing 1 replies (of 1 total)
  • Plugin Author Michael Simpson

    (@msimpson)

    9 years, 1 month ago

    CFDB captures the string that FSCF sends for a date and does not try to infer its type. It is just a string. The export to .xlsx does not set the type of the data in the cells in Excel. Perhaps adding a transform to the export to format the date data to something that Excel will interpret as a date might help.

Viewing 1 replies (of 1 total)

The topic ‘Maintaining formatting from form to export’ is closed to new replies.