Registration form
Autor: Rajiv S.
Visitado 1307,
Seguidores 1,
Compartilhado 0
Hi,
I want to have a registration form (google form type) and want to collect data in an excel file. How do I set it up?
Please help.
Publicado em
You can use the contact form object, set in TAB SEND the TAG include collected data in CSV.
see also help available from x5::
https://help.websitex5.com/en/v2021.5/pro/ins_form.htm
and
https://guide.websitex5.com/en/support/search?term=contact+form+object
and
https://www.youtube.com/watch?v=X2PFit3sik0&list=PLAu5EP-j4Fj-kci7Tnhu8Y4R_sQHDhPGu&index=22
Autor
Hi
But this collects data in file ech time an entry is made. I wish to capture all subsequent data, i.e., add all data in one single file as entries are made (like google form collects)
Autor
Also when CSV file is opened, the data does not show in column forms, it is all mingled in one cell (see screen shot)
you need to import it in excel and select correct options (you will see a small preview) once done it should do the same with next file.
you can also use a database (in Send TAB on top data transmition)
the database can be viewed with the database viewer object.
There are many way's but i am not sure how you want to use it, what you want to collect and how you would like to view it. Without that i can only point you in a direction that helps you.
x5 can do a lot but not everything. sometime you need eather other tools or custum writing.
maybe an example of what you would like and how you would like to see it might be better for us to hep you out if above answers do not help you enough
Autor
Hi
Thanks Andre - your answers helps but
1. I want to collect data in Google form style
https://docs.google.com/forms/d/e/1FAIpQLSfU7gHmXo9s6Ypp4O6Kycj-zYqb2lm-PH5tBgesoR7pcUNOSw/viewform?usp=sf_link
including file uploads
2. I want data to be added to one single excel file (.csv or .xlsx) - as they are entered (one after another)
3. Yes I learnt that the entries can be sent to data bases but guides are not detailed as to how to set up a database and for excepting entries (I know it is done at server end but a bit help with examples) will be helpful.
4. Since forms and data collection are rudimentary to any website. a detailed help with examples will help us mediocre users such as me
Hello Rajiv
What you're requiring is very specific and I believe you will need custom coding to achieve something quite like this
Alternatively, you can configure an Email Form to send data to a Database as advised before.
You just need to setup a database on your hosting provider and then retrieve its credentials to insert into the software ( your hosting provider can help with this ).
You can then export the data from the table into a CSV file
Please try this out and let me know if you encounter any difficulties linking a Database
Thank you
Stefano