search

formtools / core

The Form Tools Core.
https://formtools.org
207 stars 78 forks source link

Export to google sheets #775

Open rafiee opened 3 years ago

rafiee commented 3 years ago

Hi,

I just need a web-hosted form builder and I found Form Tools. I'm not sure if this is what I'm looking for since there is no Demo site. I would be so appreciated of someone to help me understand if :

  1. There is an option to expert (Live Link) all submitted data to google sheet.
  2. There is an option to create hidden fields
  3. there an option to send timestamp (with various formats) when the form is submitted. Thank you.
rafiee commented 3 years ago

Well, I just found the Demo website, So I'm going to answer my question in case someone else in considering those options:

  1. NO, there is not.
  2. No, There is not.
  3. Date and time in separate format, not timestamp.
ghost commented 3 years ago

Hey There!

Form Tools provides a framework you can use to do some of this - however it is not out of the box available with the functionality custom to your enviorment.

For the Export of data to a Google Sheet, you could using the Submission Pre-parser (https://docs.formtools.org/modules/submission_pre_parser/) script write custom PHP to write the data to Google's Sheets API to a specific sheet. Otherwise, you could just download your results as an Excel file via Export Manager and upload the data to your Google Sheet.

Regarding Hidden Fields, this is absolutely supported. Check out here for creating a custom field in a form (after you initialized it for example) for your hidden field https://docs.formtools.org/userdoc/form_management/edit_form_fields_tab/ and then check out the View configuration for how you would display it https://docs.formtools.org/userdoc/views/editing/

For Date and Time, if you require this as two fields, you can use the Submission Pre-Parser to handle this by writing the date and time to two fields on save. https://docs.formtools.org/modules/submission_pre_parser/

Hope this helps!