forms icon indicating copy to clipboard operation
forms copied to clipboard

Link Form to a CSV

Open Mannshoch opened this issue 3 years ago • 0 comments

Nextcloud (please complete the following information):

  • Nextcloud-Version: 24
  • Forms-Version: 2.5.1

Is your feature request related to a problem? Please describe. Developing Question and Answers need some Datatranslation we usually use CSV.

Describe the solution you'd like Link a Form bidirectional to a CSV which auto-create a form depending on the content of the CSV. A CSV binding automatically limit the possibility of the Form depending of the limits of CSV. It should be possible to break a link to a CSV.

  1. Select a CSV
  2. Open it in Forms
  3. Forms ask about delimiter
  4. Forms ask if Questions are separated in the first line into several row or if Questions are per line "Question 1","Question 2","Question 3" or
Question 1
Question 2
Question 3
  1. If default use Longtext.
  2. If the first line contain a specific codetext e.g. checkbox the folowing rows could contains possible answers.
"checkbox","Question 1","Answer 1.0","Answer 1.1","etc."
"Dropdown","Question 2","Answer 2.0","Answer 2.1","etc."
Question 3
Question 4
  1. Don't hesistate to modify the CSV according the need of Forms.

Describe alternatives you've considered Currently, we mostly work with Excel

Mannshoch avatar Aug 18 '22 14:08 Mannshoch