WebSite X5Help Center

 
Rajiv S.
Rajiv S.
User

Registration form  en

Author: Rajiv S.
Visited 1370, Followers 1, Shared 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.

Posted on the
8 ANSWERS
Rajiv S.
Rajiv S.
User
Author

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)

Read more
Posted on the from Rajiv S.
Rajiv S.
Rajiv S.
User
Author

Also when CSV file is opened, the data does not show in column forms, it is all mingled in one cell (see screen shot)

Read more
Posted on the from Rajiv S.
Andre E
Andre E
Moderator
Best User of the month EN
Rajiv S.
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.

Read more
Posted on the from Andre E
Andre E
Andre E
Moderator
Best User of the month EN
Rajiv S.
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)

you can also use a database (in Send TAB on top data transmition) 

the database can be viewed with the database viewer object.

Read more
Posted on the from Andre E
Andre E
Andre E
Moderator
Best User of the month EN

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

Read more
Posted on the from Andre E
Rajiv S.
Rajiv S.
User
Author

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   

Read more
Posted on the from Rajiv S.
Incomedia
Stefano G.
Incomedia

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

Read more
Posted on the from Stefano G.