• Resolved Heat Sink

    (@heat-sink)


    I would like completed forms to be added to a local XLS or ODS file when they are submitted. CSV would be an acceptable alternative. Ideally this would be written to a path and updated with new rows when additional entries are submitted. Each form would have to be saved in a separate output file.

    Exporting to Google sheets/forms is not acceptable in this environment.

    Is this supported by the “Standard” license?

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author EDGARROJAS

    (@edgarrojas)

    Hello!

    This is kind of complex:

    The entries screen can create a csv file but it would put all the entries in a single file and also needs to be triggered manually

    The google sheet add on is not an option according to your requirements

    So the best option would be to use the automation add on, this one can send the entry information to a url, then you could do an small script (which i can provide if you need it) that would catch that request and do whatever you want with it like saving the info in a single file.

    Would that work? The automation plugin is part of the diamon version (which give you access to all the plugins) or you can purchase just that add on here: https://allinoneforms.rednao.com/add-ons/

    Hope this helps but if it doesn’t please let me know!

    Thread Starter Heat Sink

    (@heat-sink)

    Thanks for the fast reply. Seems a lot of work for a simple thing. I suspect I would be better off with a similar amount of effort to just export the entriesfrom the database, triggered by the submission email if necessary.

    What form would the data be in if sent to a URL at the time of submission?

    Plugin Author EDGARROJAS

    (@edgarrojas)

    Is configurable but by default it send them in json format using the field label as property and its value in text format as the value.

    Regards!

    Thread Starter Heat Sink

    (@heat-sink)

    OK, still considering this… is there a way to generate a proper header line for the CSV that includes all of the field names, even those that are conditional and may not be present in a given submission?

    For my needs, it would be sufficient if this was something I generated once and used as a reference when importing new rows.

    Plugin Author EDGARROJAS

    (@edgarrojas)

    Oh that is possible you just need to configure the plugin to send each field in the http request. But now that i think about it, i could create a csv action so instead of having to send an http request and then process it yourself to create the csv you would select that csv action, define where you want to save the csv files (a location in your server) and the plugin could create this csv and save the files there. If that is what you need and you can wait a bit (a week or two) i could add this feature in the automation plugin, just let me know.

    Regards!

Viewing 5 replies - 1 through 5 (of 5 total)

You must be logged in to reply to this topic.