How to solve the eternal problem with data collection?

Question

Work organization

Hello everyone, does anyone know an application for flexible data collection from employees within the company, in which a programmer is not needed to create tables in the database or interface, so that any employee can set himself, for example, what fields he needs, what restrictions on them, etc. .p., and based on this, some kind of interface will appear? And then you constantly either collect from all excels by mail, which no one can fill out correctly, or you have to involve programmers.

PS Entering restrictions in Excel does not help, often everyone just deletes your file and throws a new one or disables them, nothing similar could be found on the Internet.

Answer 1

Google forms. A poll is created in the visual editor - the types of possible answers are selected (up to regular expressions). It is possible to request some data depending on the previous answers. As a result, all this stuff is automatically collected in Google spreadsheet.
At the same time, it is not even necessary that all employees have a Google e-mail. True, then there is no protection against fools and they can answer several times and generally anonymously write any kind of game.
If the company has a gsuite, then it's even easier, but it's not required.

Answer 2

Google Forms allows you to create a questionnaire to fill out, the results of which are added to a Google spreadsheet. Users do not need to give access to the table.

Answer 3

No, most likely. Try Google Sheets. There is no way to delete the file. And they won't send another one. Complete with hints to make it easier for them to understand. Use formatting so that they are not afraid of letters.