Hi,
At devisrenovation.lu I'm using a form and I'm exporting the data in a .csv file. But one thing I don't know how to export is the note field (I'm adding a note to each of the entries.)
How can I achieve that please?
Thank you!
Hi,
At devisrenovation.lu I'm using a form and I'm exporting the data in a .csv file. But one thing I don't know how to export is the note field (I'm adding a note to each of the entries.)
How can I achieve that please?
Thank you!
Currently this is not possible due to the complexities involved. The entry export CSV file is a simple CSV file where each row represents an entry.
Because an entry could contain multiple notes, adding them to the CSV export would make things much more complex.
It would become so complex the likelihood that the end result would be used would be minimal given the parsing that would need to take place to import such a complex CSV file. The vast majority of our users simply wouldn't use it because they wouldn't have the capability to then write the import routine necessary to import the data into wherever they need to import it.
Exporting data as a CSV isn't ideal for complex situations such as this where you could have a row that contains child rows of data associated with it. It's a situation where something such as an XML export would make more sense.
Because XML is typically so custom based on the use case and the schema required it's not something we currently offer as an export option.
You would need to write some custom PHP to query the data and return it in a custom format. Then you could pull in Notes at the same time and format the output however you see fit as it would be a custom implementation that you'd have complete control over.
Thank you for replying. What I need is to have a field not visible to visitors but in which I can add a note at a latter time.
Can I maybe create field, hide it to visitors and in which I can write after that? So it will be easier to export it....
Thank you!
You can have nearly any field as an admin-only field without issue. It is in the advanced settings for fields.
Yes, you can add a field to your form and set its visibility to admin only. You do this by editing the field, selecting the Advanced tab and select Admin Only for its visibility.