E
E
Evgenu2017-09-11 19:48:22
Database
Evgenu, 2017-09-11 19:48:22

A system for creating simple reports and collecting information?

The task of collecting data from stores or specific employees constantly arises. The report form is always simple, 1 page up to 5 fields, but the data is entered on an ongoing basis and this is not a one-time task
The new system should have the following features :
1. Easy to create forms (simple forms 4-5 fields; 1-2 drop-down lists)
2. Access control (some can only enter data into the form)
3. Information will be sent to email. tables or database on the server (the forms are simple, so there is no difference)
4. Ability to control the introduction of reports. If report is not entered notify
5. Do not update reports from end users. All information on the server, they have a link to the site or a shortcut to the program
Previous task
The task is to collect information on revenue for each store. Currently using Google forms+Docs (Role Administrator and Stores)
Stores are not allowed to modify the form and table. Administrator only.
Total : Order, nothing superfluous, but the limitations of Google Forms prevent further refinement
Could be done using excel. Each store would fill out a file and mail it. But then a person would be needed to process it, because. 100% from time to time stores would make mistakes: send extra information in a file, amounts with spaces.
Cons : No ability to control changes in the shared file, different versions, weak protection against file changes, both current and old data
1C is not suitable. It is not profitable to buy a 1C license on each TT and spend it on updating with such a simple task. Also, each introduction of new forms will be very long and expensive.

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question