WebSite X5Help Center

 
Rajiv S.
Rajiv S.
User

Registration form  en

Автор: Rajiv S.
Просмотрено 1369, Подписчики 1, Размещенный 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.

Размещено
8 Ответы
Rajiv S.
Rajiv S.
User
Автор

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)

Читать больше
Размещено От Rajiv S.
Rajiv S.
Rajiv S.
User
Автор

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

Читать больше
Размещено От Rajiv S.
Andre E
Andre E
Moderator
Лучший пользователь месяца 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.

Читать больше
Размещено От Andre E
Andre E
Andre E
Moderator
Лучший пользователь месяца 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.

Читать больше
Размещено От Andre E
Andre E
Andre E
Moderator
Лучший пользователь месяца 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

Читать больше
Размещено От Andre E
Rajiv S.
Rajiv S.
User
Автор

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   

Читать больше
Размещено От 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

Читать больше
Размещено От Stefano G.