Git Product home page Git Product logo

nextcloud / forms Goto Github PK

View Code? Open in Web Editor NEW
313.0 19.0 94.0 18.37 MB

πŸ“ Simple form & survey app for Nextcloud

Home Page: https://apps.nextcloud.com/apps/forms

License: GNU Affero General Public License v3.0

JavaScript 49.22% Makefile 0.07% PHP 34.93% Vue 14.73% CSS 0.18% SCSS 0.13% TypeScript 0.73%
nextcloud nextcloud-app form forms forms-builder form-builder survey survey-app vue vuejs

forms's Introduction

Nextcloud Forms

Downloads Code coverage Dependabot status Start contributing

πŸ“ Simple surveys and questionnaires, self-hosted

Straightforward form creation

Simple sharing and responding

Response visualization and exporting

  • πŸ“ Simple design: No mass of options, only the essentials. Works well on mobile of course.
  • πŸ“Š View & export results: Results are visualized and can also be exported as CSV in the same format used by Google Forms.
  • πŸ”’ Data under your control! Unlike in Google Forms, Typeform, Doodle and others, the survey info and responses are kept private on your instance.
  • πŸ™‹ Get involved! We have lots of stuff planned like more question types, collaboration on forms, and much more!

πŸ— Development setup

  1. ☁ Clone this app into the apps folder of your Nextcloud: git clone https://github.com/nextcloud/forms.git
  2. πŸ‘©β€πŸ’» In the folder of the app, run the command composer i && composer i && npm ci && npm run build to install dependencies and build the Javascript.
  3. βœ… Enable the app through the app management of your Nextcloud
  4. πŸŽ‰ Partytime! Help fix some issues and review pull requests πŸ‘

πŸ§™ Advanced development stuff

To build the Javascript whenever you make changes, you can use npm run build. Or npm run watch to automatically rebuild on every file save.

You run several tests by:

  • npm run lint for JavaScript linting
  • npm run stylelint for CSS linting
  • composer cs:check for the Nextcloud php coding standard
  • composer lint for php linting
  • composer test:unit and composer test:integration to run the php functionality tests
  • composer psalm for static code analysis

β™₯ How to create a pull request

This guide will help you get started:

✌ Code of conduct

The Nextcloud community has core values that are shared between all members during conferences, hackweeks and on all interactions in online platforms including Github and forums. If you contribute, participate or interact with this community, please respect our shared values. 😌

forms's People

Contributors

affan-hussain avatar ailkiv avatar barkuto avatar chartman123 avatar commanderroot avatar dependabot-preview[bot] avatar dependabot[bot] avatar hamza221 avatar jancborchardt avatar jandragon avatar jotoeri avatar justin-sleep avatar koc avatar marcelklehr avatar marcoambrosini avatar mschmidm avatar nextcloud-bot avatar nickvergessen avatar ordaolmayanadam avatar pvince81 avatar rakekniven avatar rullzer avatar simmstein avatar skjnldsv avatar slink58 avatar stefan-niedermann avatar susnux avatar tims3434 avatar tpokorra avatar valdnet avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

forms's Issues

DB-Datetime Field error by creating new Form

Which Forms version are you running? (see apps page)
1.1.0
Nextcloud or ownCloud?:
NextCloud
Nextcloud/ownCloud version: (see Nextcloud admin page)
18.0.0

Steps to reproduce
1 install nexcloud 18
2 install form
3 create new form
4 create new question
5 Expected behaviour
6 Shoudl save the form

Actual behaviour
Form can't be saved

Server configuration
Operating system:
Synology DSM 6 (Debian)
Web server:
Apache
Database:
MariaDB 10
PHP version:
7.3

Updated from an older Nextcloud or fresh install:
new installation

Signing status:

Login as admin user into your Nextcloud and access
http://example.com/index.php/settings/integrity/failed
paste the results here.
No errors have been found.

List of activated apps:
Teamfolder
Talk
Mail
Contacts
Calendar
Deck
Tasks
Accounsments
Forms
News

Nextcloud configuration:

If you have access to your command line run e.g.:
sudo -u www-data php occ config:list system
from within your instance's installation folder

or

Insert your config.php content here
Make sure to remove all sensitive content such as passwords. (e.g. database password, passwordsalt, secret, smtp password, …)

Are you using external storage, if yes which one: local/smb/sftp/...
local
Are you using encryption: yes/no
no
Are you using an external user-backend, if yes which one: LDAP/ActiveDirectory/Webdav/...
no

Client configuration

Browser:
Chrome
Operating system:
Win10
CalDAV-clients:
none

Logs

Web server error log

Insert your webserver log here

Nextcloud log (data/nextcloud.log)

Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'INSERT INTO oc_forms_events (title, description, is_anonymous, unique, access, owner, created, hash) VALUES(?, ?, ?, ?, ?, ?, ?, ?)' with params ["Test2", "", 0, false, "public", "Daniel", "2020-01-22 06:53:51", "8c06ZvbRLs9q9R28"]: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: '' for column nextcloud.oc_forms_events.unique at row 1

Browser log

How to edit a form later?

**Which Forms version are you running? 0.2

**Nextcloud or ownCloud?:nextcloud

**Nextcloud/ownCloud version:16.0.x

Steps to reproduce

  1. create and finish a form
  2. try to edit this form later

Actual behaviour

No edit button or something like that

Expected behaviour

Editing should be possible, maybe only as long as no answers were made

Breadcrumbs bar not needed for this app

The breadcrumbs bar only makes sense for deep levels of nesting, and the only app where this is really needed is Files.

Other apps like this only need the AppNavigation component. :) You simply have all the forms listed in the left navigation, and selecting one opens the detail view.

That way you always have the forms overview, and can also quickly switch between them. And on mobile or narrower sizes, the left navigation bar automatically hides.

Wish : share with Circles

Forms 1.0.3
Nextcloud, 16 and 17 (on 2 differents instances !)

Steps to reproduce

  1. create a form
  2. trying to share with a circle

Actual behaviour

Can't find circles in "Share with" form

Expected behaviour

A form could be share in a circle

Same difficulty as "Polls" maybe it is a lib or api issu, not yours ... ?
Thaks for your work

Should not call it a survey, it's a form

V1.0.3
NextCloud 16

I don't want to see the result like a survey.
When someone submit their form, the result should be sent to the admin or group of this form.

I think you should see it more like a request form.

Add Forms to Transifex

Thank you for creating this app.
Internationalization of Forms would be nice future.
Please add Forms to Transifex so users can help translate it.

Does not respect autocomplete settings

Which Forms version are you running? (see apps page)
1.0.3
Nextcloud or ownCloud?:
Nextcloud
Nextcloud/ownCloud version: (see Nextcloud admin page)
15.0.8

Steps to reproduce

  1. Uncheck checkbox 'Allow autocomplete username in sharing dialog' under '/settings/admin/sharing'
  2. Choose 'Only Shared' under Apps 'Configuration -> Access'
  3. start typing to find user to share form with

Actual behaviour

Full list of users matching partial input shows

Expected behaviour

Only on full name match it should show match list

"Upload file" as question/response

Hello!

Currently it is not possible to set up file uploads within forms, however, it would be quite useful to have to collect information other than answers or text from users. So I am suggesting this idea if some developer is bored and wants to work on it!

I may end up implementing this but not right now because time is lacking.

Thank you

Don't show Nextcloud Toolbar with all apps

Which Forms version are you running? (see apps page)
1.0.3

Nextcloud or ownCloud?:
Nextcloud

Nextcloud/ownCloud version: (see Nextcloud admin page)
16.0.1

Steps to reproduce

  1. Create a form, make it public
  2. Copy the link
  3. Open the link in another browser or in icognito mode, so you're not logged into the Nexcloud instance

Actual behaviour

On the top, the Nextcloud Toolbar is shown, including all apps that are installed.

Expected behaviour

The toolbar shouldn't show the installed apps, because it leaks information about the installation.
Instead, a "blank" blue toolbar could be shown, like e.g. the Polls app does for public polls.

Is translation planned?

Forms 1.0.3
Nextcloud 17

Is a translation into other languages planned ?
My main interest is the frontend.

Thanks for your efforts.

Uploading a CSV file to quicly create a form

Which Forms version are you running?
1.0.3

Nextcloud or ownCloud?:
Nextcloud

Nextcloud/ownCloud version:
16.0.5

Actual behaviour

Option not available yet
Expected behaviour

Uploading a CSV file to create the form

Answering options cannot be added in v1.1.0

Which Forms version are you running?
1.1.0, installed today from app store via Nextcloud web interface

Nextcloud/ownCloud version:
Nextcloud 17.0.2

Steps to reproduce

  1. Start to create form
  2. Pick any clickable answer type (radio, checkboxes, dropdown)
  3. Any given answer option will not be accepted by the Forms app
    Bildschirmfoto von 2020-01-15 15-29-42

Tested on Firefox 72.0.1 and Chromium 79, both on Ubuntu 19.10

Actual behaviour

There seem to be no way to enter answering options. The visible input field does not do anything. If you enter the answer options there, you won't be able to finish creating – when clickin on "Fertig" (Finish?): there is a message that all questions need answers.

Expected behaviour

Some possibility to enter answering options for checkboxes, radio buttons and dropdown questions.

Repository organization

We would love to support you with development on the app and make it possible for more people to see it and contribute! :)

In the readme, you write:

Note: This will be moved to https://github.com/nextcloud/forms.git once the app has been accepted to the NextCloud app store

Are you interested in doing that? The way this generally needs to be done is that you as app owners need to transfer it to an admin of the Nextcloud org (like @rullzer or me) and then we move it to there.

Let us know what you think! @Barkuto @Affan98 @TimS3434 @slink58

Forms app review

@skjnldsv @rullzer & @jancborchardt at Contributor Week June 2019

We also looked at Google Forms and Typeform for comparison. We think it’s best to mainly model it after Google Forms as it’s quite widely used.

Below are detail review points of the current state so we can make small steps in the right direction based on the current app. :)

cc @nextcloud/forms

Initial list view

  • Forms should be listed in the left navigation instead of the main content. The main content is to edit the form.
  • Help button too present
  • Home icon is confusing and not necessary?
  • List header shows even though no forms
  • Emptycontent message missing?

Form creation

  • No way to submit/confirm answer with mouse
  • Misalignment of answers
  • Too many delete buttons visible at the same time
  • Too many different font-sizes
  • Interface doesn’t reflect how the form will look for people afterwards
  • No way to reorder answers or put things inbetween
  • Replies are not autosaved

Answer types:

  • Icons for answer types
  • No way to change the answer type
  • "Radio button" β†’ Multiple choice
  • "Checkboxes" β†’ Checkboxes
  • "Short response" β†’ Short answer
  • "Long response" β†’ Long text
  • "Drop Down" is the same as Single choice?

Sidebar

  • Only 1 tab, which is not necessary β†’ use sidebar component
  • Spacing on owner is strange
  • Settings are in 2 columns – unusual
  • Settings like "Anonymous form" need explanation
  • Use main Nextcloud sharing – default is public access which means everyone on the instance can see it

List after creation

  • Icon not clear (with green dot)
  • Clicking form should open editing configuration
  • Delete too present
  • "Created" date unnecessary

Share view

  • Header should not show apps or contacts menu <- this is the logged-in view
  • Header should not show "Nextcloud" placed a bit to the top <- this is unauthenticated view
  • Header should have the survey title
  • Input fields and textareas don’t look like inputs cause the other answer types have a container like that around it too
  • Asterisk * before questions is confusing? Mandatory? Not possible to set or unset. Should instead say "mandatory" in a subline
  • "Thank you for completing he survey!" page is very bland

Results view

  • Should simply be another tab in the sidebar? Or a switch of views in the app-content, kind of like we have the grid/list view? (Google Forms does this well, collapsing a block when not editing that specific one.)

Potential

  • Randomize order of choices in multiple choice and checkboxes (like in Google Forms, to reduce bias)
  • Print submissions

No Forms are listed

Steps to reproduce

Installed app via nextcloud.->Added a new public form.->Saved with "Done"->Says Form is saved

Expected behaviour

List created Form

Actual behaviour

List with forms is empty

Server configuration detail

Operating system: Linux 4.4.0-042stab140.1 #1 SMP Thu Aug 15 13:32:22 MSK 2019 x86_64

Webserver: Apache/2.4.18 (Ubuntu) (apache2handler)

Database: mysql 10.0.38

PHP version:

7.1.33-1+ubuntu16.04.1+deb.sury.org+1
Modules loaded: Core, date, libxml, openssl, pcre, zlib, filter, hash, Reflection, SPL, session, standard, apache2handler, mysqlnd, PDO, xml, bz2, calendar, ctype, curl, dom, mbstring, fileinfo, ftp, gd, gettext, iconv, igbinary, intl, json, exif, mcrypt, mysqli, pdo_mysql, Phar, posix, readline, shmop, SimpleXML, sockets, sysvmsg, sysvsem, sysvshm, tokenizer, wddx, xmlreader, xmlwriter, xsl, zip, Zend OPcache

Nextcloud version: 16.0.6 - 16.0.6.1

Updated from an older Nextcloud/ownCloud or fresh install: Updated from 15.0.13

Where did you install Nextcloud from: unknown

Signing status

Array
(
)

List of activated apps
Enabled:
 - accessibility: 1.2.0
 - activity: 2.9.1
 - bruteforcesettings: 1.4.0
 - calendar: 1.7.1
 - cloud_federation_api: 0.2.0
 - comments: 1.6.0
 - contacts: 3.1.6
 - dav: 1.9.2
 - federatedfilesharing: 1.6.0
 - federation: 1.6.0
 - files: 1.11.0
 - files_markdown: 2.1.0
 - files_pdfviewer: 1.5.0
 - files_rightclick: 0.15.1
 - files_sharing: 1.8.0
 - files_texteditor: 2.8.0
 - files_trashbin: 1.6.0
 - files_versions: 1.9.0
 - files_videoplayer: 1.5.0
 - firstrunwizard: 2.5.0
 - forms: 1.0.3
 - gallery: 18.3.0
 - issuetemplate: 0.5.0
 - logreader: 2.1.0
 - lookup_server_connector: 1.4.0
 - nextcloud_announcements: 1.5.0
 - notes: 3.0.3
 - notifications: 2.4.1
 - oauth2: 1.4.2
 - password_policy: 1.6.0
 - polls: 0.10.4
 - privacy: 1.0.0
 - provisioning_api: 1.6.0
 - recommendations: 0.4.0
 - registration: 0.4.7
 - serverinfo: 1.6.0
 - sharebymail: 1.6.0
 - spreed: 6.0.4
 - support: 1.0.0
 - survey_client: 1.4.0
 - systemtags: 1.6.0
 - theming: 1.7.0
 - theming_customcss: 1.4.0
 - twofactor_backupcodes: 1.5.0
 - updatenotification: 1.6.0
 - viewer: 1.2.0
 - workflowengine: 1.6.0
Disabled:
 - admin_audit
 - encryption
 - files_external
 - mindmaps
 - user_ldap

Configuration (config/config.php)
{
    "dbtype": "mysql",
    "version": "16.0.6.1",
    "logtimezone": "UTC",
    "installed": true,
    "skeletondirectory": "",
    "htaccess.RewriteBase": "\/",
    "maintenance": false,
    "loglevel": 0,
    "updater.release.channel": "stable"
}

Are you using external storage, if yes which one:

Are you using encryption:

Are you using an external user-backend, if yes which one:

Client configuration

Browser: Mozilla/5.0 (X11; Linux x86_64; rv:70.0) Gecko/20100101 Firefox/70.0

Operating system:

Logs

Nextcloud log
[index] Error: BadFunctionCallException: unique is not a valid attribute at <<closure>>

 0. /var/www/nextcloud/lib/public/AppFramework/Db/Entity.php line 146
    OCP\AppFramework\Db\Entity->setter("unique", ["0"])
 1. /var/www/nextcloud/lib/public/AppFramework/Db/Entity.php line 70
    OCP\AppFramework\Db\Entity->__call("setUnique", ["0"])
 2. /var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php line 284
    OCP\AppFramework\Db\Entity::fromRow({id: "1",hash: " ... "})
 3. /var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php line 301
    OCP\AppFramework\Db\QBMapper->mapRowToEntity({id: "1",hash: " ... "})
 4. /var/www/nextcloud/apps/forms/lib/Db/EventMapper.php line 87
    OCP\AppFramework\Db\QBMapper->findEntities(OC\DB\QueryBuilder\QueryBuilder {})
 5. /var/www/nextcloud/apps/forms/lib/Controller/ApiController.php line 378
    OCA\Forms\Db\EventMapper->findAll()
 6. /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 166
    OCA\Forms\Controller\ApiController->getForms()
 7. /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 99
    OC\AppFramework\Http\Dispatcher->executeController(OCA\Forms\Contro ... "}, "getForms")
 8. /var/www/nextcloud/lib/private/AppFramework/App.php line 126
    OC\AppFramework\Http\Dispatcher->dispatch(OCA\Forms\Contro ... "}, "getForms")
 9. /var/www/nextcloud/lib/private/AppFramework/Routing/RouteActionHandler.php line 47
    OC\AppFramework\App::main("OCA\\Forms\\Controller\\ApiController", "getForms", OC\AppFramework\ ... {}, {_route: "forms.api.get_forms"})
10. <<closure>>
    OC\AppFramework\Routing\RouteActionHandler->__invoke({_route: "forms.api.get_forms"})
11. /var/www/nextcloud/lib/private/Route/Router.php line 297
    undefinedundefinedcall_user_func(OC\AppFramework\ ... {}, {_route: "forms.api.get_forms"})
12. /var/www/nextcloud/lib/base.php line 975
    OC\Route\Router->match("/apps/forms/get/forms")
13. /var/www/nextcloud/index.php line 42
    OC::handleRequest()

GET /apps/forms/get/forms
from ip by user at 2019-11-15T18:41:41+00:00

Notification/Activity for new form responses

Which Forms version are you running? (see apps page)
1.0.3
Nextcloud or ownCloud?:
Nextcloud
Nextcloud/ownCloud version: (see Nextcloud admin page)
15.0.5

A customizable notification on form submission (either to the owner or to a defined email address) would be another great feature.

Allow custom/other answer for 'multiple' questions (radio & checkbox)

Which Forms version are you running? (see apps page)
1.0.3

Nextcloud or ownCloud?:
Nextcloud

It would be cool to be able to enable an "other" option with a free form text input for radio buttons and checkboxes, to give the user the possibility to provide other answers than those that are explicitly given.

Increase length for description and show proper errors

Which Forms version are you running?
1.0.3

Nextcloud or ownCloud?:
Nextcloud

Nextcloud/ownCloud version: (see Nextcloud admin page)
16.0.4

Steps to reproduce

  1. Try to submit a form with a description with more than 1024 characters

Actual behaviour

Form does not get saved and shows a generic "Error on saving form, see console".
Request gives a 500 Internal Server Error.

Expected behaviour

Form does get saved (or at least an error message saying that descriptions with more than 1024 characters are not supported).

How are statistics calculated?

Which Forms version are you running? (see apps page)
1.0.3
Nextcloud or ownCloud?:
NC
Nextcloud/ownCloud version: (see Nextcloud admin page)
NC 16, demo.nextcloud.com

Steps to reproduce

  1. Create a form with 2 questions
    1.1. Question 1 with 3 radio buttons
    1.2. Question 2 with 2 check boxes
  2. Vote one time
  3. See the statistics

Actual behaviour

Question 1: 50.00% of respondents voted for answer choice: radio b

Expected behaviour

since there was only 1 vote, i expect 100% for each statistic.:
Question 1: 100.00% of respondents voted for answer choice: radio b
Question 2: 100.00% of respondents voted for answer choice: box a

Format of results, especially in CSV

A feature request:

Which Forms version are you running? (see apps page)
1.0.3

Nextcloud or ownCloud?:
Nextcloud

Nextcloud/ownCloud version: (see Nextcloud admin page)
16.0.1

Steps to reproduce

  1. Create Form
  2. Provide some answers
  3. View results

Actual behaviour

Results are shown with one line per answer:

Name    Question #   Question             Response
anon1   1            Pineapple on pizza?  Yes
anon1   2            Favorite editor?     Emacs
anon2   1            Pineapple on pizza?  No
anon2   2            Favorite editor?     vim

Expected behaviour

I'd actually like the output to be one line per user, so I have all answers in one line, like

Name    Question #   q1                   r1      q2                 r2
anon1   1            Pineapple on pizza?  Yes     Favorite editor?   Emacs
anon2   1            Pineapple on pizza?  No      Favorite editor?   vim

or even like

Name    Question #   Pineapple on pizza?    Favorite editor?
anon1   1            Yes                    Emacs
anon2   1            No                     vim

That would make the data easier to work with for my use with (using the exported CSV file as a data file for jekyll).

(I'm interested if other users found this useful, too. Currently, I could work around this by doing a custom SQL query as I only have one form).

How to set up the development environment on macOS?

Hello, I would like to work on the codebase and I am just wondering how to set up the development environment on macOS as easily as possible, from setting up the Nextcloud instance to compiling and debugging the app on real time. This might be rather a general question.

Any suggestions would be appreciated. Thanks in advance.

SCSS scoped inside vue files vs. SCSS files inside css folder

Basically there are two ways of styling components:

  • SCSS scoped inside vue files
  • SCSS files inside css folder

I'm sort of being unable to keeping myself up to the conventional coding style of Vue stuff, still I feel the styles are scattered over the codebase and not quite organized. IMO it's one of the hurdles for those who are willing to work on the UI. There should possibly a naming rule like BEM be adopted to maintain the codebase clean and organized, also to prevent UI regressions.

Mandatory/non mandatory questions

Which Forms version are you running?
1.0.3

Nextcloud or ownCloud?:
Nextcloud

Nextcloud/ownCloud version: (see Nextcloud admin page)
17

Steps to reproduce

  1. create a form with non-mandatory fields
  2. enter data into mandatory fields (*) leave non-mandatory fields empty

Actual behaviour

  1. cannot submit form without filling some non-mandatory fields with eg β€žn/aβ€œ or some other non-null value

Expected behaviour

Option to submit anyway or preset fields with some default text eg β€žn/aβ€œ

Server configuration

Where did you install Nextcloud from:
Nextcloud App store
Operating system:
Linux
Web server:
Apache2
Database:
MySql/MariaDB
PHP version:
7.2

Spinner is blue

Which Forms version are you running? (see apps page)
Current master :)

Nextcloud or ownCloud?:
Nextcloud ✊

Nextcloud/ownCloud version: (see Nextcloud admin page)
Latest master

Steps to reproduce

  1. Load the app
  2. Check out the spinner
  3. See that it uses a blue element

Actual behaviour

It’s modified to be blue, which is only to be used for highlighting.
https://github.com/affan98/forms/blob/da21b60ef0e40ca18589b2fb6500b633432e5db7/src/js/components/_base-LoadingOverlay.vue#L25

Expected behaviour

The normal standard grey loading spinner should be used. :) If you use the class you should need no additional CSS? cc @skjnldsv

Create PDF after form submit

It would be nice if forms could create a PDF after each submit. This PDF should contain the entered data.
With that, it's easy to ask for declaration of consent or and store the answers automatically

Ability to edit forms after creation

Thanks for this great app!
some things have disturbed me a bit or maybe not yet understood after saving a Survey is no longer possible to edit it again .

can users vote multiple times the same survey would make sense only once for IP address or session?

possibly the possibility to customize the survey with a template where html or something like that for example by adding a photo and so on

Forms app disappointing, buggy and unusable

Which Forms version are you running? (see apps page)
1.1.0
Nextcloud or ownCloud?:
Nextcloud
Nextcloud/ownCloud version: (see Nextcloud admin page)
18

Steps to reproduce

  1. Use Nextcloud Forms
  2. Look for a Ggle forms like behaviour
  3. Use Framaforms or Google forms

Hello,
The Nextcloud forms app is really unusable since a lot of functionnalities are missing :

  • Can't edit forms (replacing "form" by "edit" in the URL display and empty form page)
  • Radioboxes, checkboxes and dropdown are not working anymore in NC18 (No options are displayed)
  • Results are not usable (list of mixed answers, and no way to display results by question, or some graphs...)
  • No possibility to add another admin to the form
  • Get internal server error when sharing the link in public...

Any chance this could be improved soon ? Users are leaving Nextcloud fast for another solution :(

Thanks

Write responses into spreadsheet (like Google Forms)

if the CSV file is storage on the nextcloud instance it can be process with another app called "workflow external script" make a automatic form processing.
the idea to set a file path/name in the form configuration
thanks this app is the "piece missing in the puzzle" !!!

cheers
maps

Use the IP address of the user if userId is empty

Which Forms version are you running? (see apps page)
git [master]
Nextcloud or ownCloud?:
Nextcloud
Nextcloud/ownCloud version: (see Nextcloud admin page)
17.0.2

Description

If the patch proposed in #178 is applied, the form is not configured as Anonymous Form and Access is set to Public access the Name column in the results view will be left empty. The patch included below is using the IP address from where the request is received as userId and as a result the IP address will be shown in Name column.

diff --git a/lib/Controller/PageController.php b/lib/Controller/PageController.php
index dcb60f0..5ba188b 100644
--- a/lib/Controller/PageController.php
+++ b/lib/Controller/PageController.php
@@ -278,7 +278,11 @@ class PageController extends Controller {
                $questions = $this->questionMapper->findByForm($form->getId());

                try {
-                       $notification = $this->notificationMapper->findByUserAndForm($form->getId(), $this->userId);
+                       if($this->userId === null) {
+                               $notification = $this->notificationMapper->findByUserAndForm($form->getId(), '');
+                       } else {
+                               $notification = $this->notificationMapper->findByUserAndForm($form->getId(), $this->userId);
+                       }
                } catch (DoesNotExistException $e) {
                        $notification = null;
                }
@@ -400,6 +404,9 @@ class PageController extends Controller {
                                if($form->getIsAnonymous()){
                                                $vote->setUserId($anonID);
                                }else{
+                                               if ($userId === '') {
+                                                       $userId = $this->request->getRemoteAddress();
+                                               }
                                                $vote->setUserId($userId);
                                }
                                $vote->setVoteOptionText(htmlspecialchars($questions[$i]['text']));

[REQUEST] Make already chosen options unavailable

Which Forms version are you running?
1.0.3

Nextcloud or ownCloud?:
NC

Nextcloud/ownCloud version: (see Nextcloud admin page)
16.0.1.1

I'd like to use this plugin as a Doodle replacement, but Doodle has the option to disable entries, which got already chosen by another person, which is missing in Forms.

Overlapping lines when form has long title / description

Steps to reproduce

  1. Create a form with a long title or description. Make it so long the resulting text won't fit on a single line
  2. Open the form's response page

Expected behaviour

The lines containing the title should be aligned neatly without overlap

Actual behaviour

Title lines overlap

Server configuration detail

Operating system: Linux 4.15.0-55-generic #60-Ubuntu SMP Tue Jul 2 18:22:20 UTC 2019 x86_64

Webserver: Apache (fpm-fcgi)

Database: mysql 5.7.27

PHP version:

7.2.20
Modules loaded: Core, date, libxml, openssl, pcre, sqlite3, zlib, bz2, ctype, curl, dom, hash, fileinfo, filter, ftp, gd, SPL, iconv, intl, json, ldap, mbstring, pcntl, PDO, session, pdo_sqlite, posix, Reflection, standard, SimpleXML, mysqlnd, exif, tokenizer, xml, xmlreader, xmlwriter, zip, pdo_mysql, cgi-fcgi, redis, Zend OPcache

Nextcloud version: 15.0.10 - 15.0.10.0

Updated from an older Nextcloud/ownCloud or fresh install: fresh install

Where did you install Nextcloud from: unknown

Signing status

Array
(
)

List of activated apps
Enabled:
 - accessibility: 1.1.0
 - activity: 2.8.2
 - admin_audit: 1.5.0
 - announcementcenter: 3.4.1
 - apporder: 0.6.0
 - checksum: 0.4.3
 - cloud_federation_api: 0.1.0
 - comments: 1.5.0
 - dav: 1.8.2
 - deck: 0.6.5
 - federatedfilesharing: 1.5.0
 - federation: 1.5.0
 - files: 1.10.0
 - files_accesscontrol: 1.5.0
 - files_automatedtagging: 1.5.0
 - files_mindmap: 0.0.13
 - files_pdfviewer: 1.4.0
 - files_retention: 1.4.2
 - files_sharing: 1.7.0
 - files_texteditor: 2.7.0
 - files_trashbin: 1.5.0
 - files_versions: 1.8.0
 - files_videoplayer: 1.4.0
 - firstrunwizard: 2.4.0
 - forms: 1.0.3
 - fulltextsearch: 1.2.10
 - fulltextsearch_elasticsearch: 1.2.6
 - gallery: 18.2.0
 - groupfolders: 3.0.2
 - groupquota: 0.1.0
 - issuetemplate: 0.5.0
 - keeporsweep: 0.2.1
 - logreader: 2.0.0
 - lookup_server_connector: 1.3.0
 - nextcloud_announcements: 1.4.0
 - notifications: 2.3.0
 - oauth2: 1.3.0
 - password_policy: 1.5.0
 - polls: 0.10.2
 - provisioning_api: 1.5.0
 - quota_warning: 1.4.0
 - richdocuments: 3.3.14
 - serverinfo: 1.5.0
 - sharebymail: 1.5.0
 - spreed: 5.0.4
 - support: 1.0.0
 - survey_client: 1.3.0
 - systemtags: 1.5.0
 - terms_of_service: 1.1.2
 - twofactor_backupcodes: 1.4.1
 - user_ldap: 1.5.0
 - user_usage_report: 1.1.2
 - workflowengine: 1.5.0
Disabled:
 - encryption
 - files_external
 - theming

Configuration (config/config.php)
{
    "apps_paths": [
        {
            "path": "\/snap\/nextcloud\/current\/htdocs\/apps",
            "url": "\/apps",
            "writable": false
        },
        {
            "path": "\/var\/snap\/nextcloud\/current\/nextcloud\/extra-apps",
            "url": "\/extra-apps",
            "writable": true
        }
    ],
    "supportedDatabases": [
        "mysql"
    ],
    "memcache.locking": "\\OC\\Memcache\\Redis",
    "memcache.local": "\\OC\\Memcache\\Redis",
    "redis": {
        "host": "***REMOVED SENSITIVE VALUE***",
        "port": 0
    },
    "instanceid": "***REMOVED SENSITIVE VALUE***",
    "passwordsalt": "***REMOVED SENSITIVE VALUE***",
    "secret": "***REMOVED SENSITIVE VALUE***",
    "trusted_domains": [
        "nextcloud.bamberg.wienet.ads"
    ],
    "datadirectory": "***REMOVED SENSITIVE VALUE***",
    "dbtype": "mysql",
    "version": "15.0.10.0",
    "overwrite.cli.url": "http:\/\/nextcloud.bamberg.wienet.ads",
    "dbname": "***REMOVED SENSITIVE VALUE***",
    "dbhost": "***REMOVED SENSITIVE VALUE***",
    "dbport": "",
    "dbtableprefix": "oc_",
    "mysql.utf8mb4": true,
    "dbuser": "***REMOVED SENSITIVE VALUE***",
    "dbpassword": "***REMOVED SENSITIVE VALUE***",
    "installed": true,
    "ldapIgnoreNamingRules": false,
    "ldapProviderFactory": "OCA\\User_LDAP\\LDAPProviderFactory",
    "mail_from_address": "***REMOVED SENSITIVE VALUE***",
    "mail_smtpmode": "smtp",
    "mail_sendmailmode": "smtp",
    "mail_domain": "***REMOVED SENSITIVE VALUE***",
    "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
    "mail_smtpport": "25",
    "loglevel": 2,
    "maintenance": false
}

Are you using external storage, if yes which one: none

Are you using encryption: false

Are you using an external user-backend, if yes which one: LDAP

LDAP configuration (delete this par if not used)

Client configuration

Browser: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:60.0) Gecko/20100101 Firefox/60.0

Operating system: Windows 10

Logs

Web server error log
Insert your web server log here 
Nextcloud log
Insert your Nextcloud log here
Browser log

Insert your browser log here, this could for example include:

a) The javascript console log
b) The network log
c) ...

Show apps icons with public link

Forms 1.0.3 on Nextcloud 16.0.5

Steps to reproduce

  1. create a form
  2. set public access
  3. copy link
  4. open link in non logged in browser

Actual behaviour

Display nextcloud apps installed (without access), click on app redirct to loggin

Expected behaviour

Don't display apps (should look the same as public share in Survey app)

Server configuration

Nextcloud instance is installed on OVH shared host with Apache (cgi-fcgi), Php 7.1.30, Mysql 5.6.42

Missing localizations in v1.1.0

Which Forms version are you running?
1.1.0 on NC 17.0.2

Actual behaviour

There are two very visible things that seem not to be localized yet: I tried in German, French, Spanish (and English):

  • The big 'Complete' button
  • The warning "ο»Ώ *NOTE: This form is anonymous"

Expected behaviour

localization ;-)

Error on saving form, see console

Which Forms version are you running?
1.1.0

Nextcloud or ownCloud?:
Nextcloud

Nextcloud/ownCloud version:
17.0.1

Steps to reproduce

  1. Fresh install of Forms plugin
  2. Create new form
  3. Add fields to form, click "Done."

Actual behaviour

Upon clicking "Done," message appears: "Error on saving form, see console."
Form does not save.

Expected behaviour

Form should be added, saved successfully.

In case of a bug, please answer the following questions

Server configuration

Where did you install Nextcloud from:
https://github.com/nextcloud/vm/blob/master/nextcloud_install_production.sh

Operating system:
Ubuntu 18.04 LTS

Web server:
Default (Apache 2.4.29)

Database:
Default (PostgreSQL 10.10)

PHP version:
Default (PHP 7.2.24)

Signing status:
Don't known what that means.

Login as admin user into your Nextcloud and access
http://example.com/index.php/settings/integrity/failed
paste the results here.

No errors have been found.

List of activated apps:

AppOrder
0.8.0
Bookmarks
2.3.1
Calendar
1.7.1
Official
Camera RAW Previews
0.7.2
Extract
1.2.2
Full text search - Files - Tesseract OCR
1.3.1
Group folders
5.0.4
Official
Mail
0.20.0
Official
Notes
3.0.3
Official
ONLYOFFICE
3.0.2
Official
Suspicious Login
3.0.0
Accessibility
1.3.0
Official
Activities for shared file downloads
1.6.0
Activity
2.10.1
Official
Announcement center
3.6.1
Official
Auditing / Logging
1.7.0
Official
Collaborative tags
1.7.0
Official
Comments
1.7.0
Official
Contacts
3.1.6
Official
Deleted files
1.7.0
Official
DropIt
0.3.0
External sites
3.4.1
Official
Favorites Quickaccess Sorting
1.0.2
Federation
1.7.0
Official
File access control
1.7.0
Official
File sharing
1.9.0
Official
Files automated tagging
1.7.0
Official
First run wizard
2.6.0
Official
Forms
1.1.0
Full text search
1.3.6
Full text search - Files
1.3.6
Gallery
18.4.0
Official
Guests
1.3.1
Impersonate
1.4.0
Official
Log Reader
2.2.0
Official
Metadata
0.10.0
Monitoring
1.7.0
Official
Nextcloud announcements
1.6.0
Official
Notifications
2.5.0
Official
Password policy
1.7.0
Official
PDF viewer
1.6.0
Official
Preview Generator
2.2.0
Privacy
1.1.0
Official
Quota warning
1.6.0
Ransomware protection
1.5.1
README.md
1.1.3
Recommendations
0.5.0
Official
Retention
1.6.0
Official
Right click
0.15.1
Official
Share by mail
1.7.0
Official
Support
1.0.1
Official
Talk
7.0.2
Official
Terms of service
1.3.1
Text
1.1.1
Official
Theming
1.8.0
Official
Update notification
1.7.0
Official
Usage survey
1.5.0
Official
User usage report
1.1.2
Versions
1.10.0
Official
Video player
1.6.0
Official
Viewer
1.2.0
Official
W2G2
3.0.0

If you have access to your command line run e.g.:
sudo -u www-data php occ app:list
from within your Nextcloud installation folder

Nextcloud configuration:
{
"system": {
"passwordsalt": "REMOVED SENSITIVE VALUE",
"secret": "REMOVED SENSITIVE VALUE",
"trusted_domains": [
"localhost",
"REMOVED DOMAIN"
],
"datadirectory": "REMOVED SENSITIVE VALUE",
"skeletondirectory": "/mnt/ncdata/skeleton",
"defaultapp": "activity,files",
"dbtype": "pgsql",
"version": "17.0.1.1",
"overwrite.cli.url": "https://REMOVED DOMAIN/",
"dbname": "REMOVED SENSITIVE VALUE",
"dbhost": "REMOVED SENSITIVE VALUE",
"dbport": "",
"dbtableprefix": "oc
",
"dbuser": "REMOVED SENSITIVE VALUE",
"dbpassword": "REMOVED SENSITIVE VALUE",
"installed": true,
"instanceid": "REMOVED SENSITIVE VALUE",
"log_type": "file",
"logfile": "/var/log/nextcloud/nextcloud.log",
"loglevel": "2",
"mail_smtpmode": "smtp",
"remember_login_cookie_lifetime": "1800",
"log_rotate_size": "10485760",
"trashbin_retention_obligation": "auto, 180",
"versions_retention_obligation": "auto, 365",
"simpleSignUpLink.shown": "false",
"memcache.local": "\OC\Memcache\APCu",
"filelocking.enabled": true,
"memcache.distributed": "\OC\Memcache\Redis",
"memcache.locking": "\OC\Memcache\Redis",
"redis": {
"host": "REMOVED SENSITIVE VALUE",
"port": 0,
"timeout": 0.5,
"dbindex": 0,
"password": "REMOVED SENSITIVE VALUE"
},
"logtimezone": "Australia/Melbourne",
"htaccess.RewriteBase": "/",
"maintenance": false,
"updater.secret": "REMOVED SENSITIVE VALUE"
}
}

Are you using an external user-backend, if yes which one: LDAP/ActiveDirectory/Webdav/...
No.

Client configuration

Browser:
Firefox 72.0.1

Operating system:
Windows 10

Logs

Console: https://postimg.cc/nsjWNFg2
Nextcloud: https://postimg.cc/7CFR4vyk

Join a Nextcloud event and let’s work on the design? :)

This is more of a contact than an issue report. ;)

I’m working on design at Nextcloud, and because the Forms app looks pretty cool I’d love to collaborate on it more. We have 2 events coming up in Germany – the Contributor Week in Stuttgart, and the yearly conference in Berlin:
https://nextcloud.com/blog/contributor-week-nextcloud-conference-time-to-apply-for-travel-support/

It would be cool to have some of you there @TimS3434 @Affan98 @slink58 @Barkuto! I’ll also try and give design feedback here, but it’s always good to meet and go through the design together. :)

Feature Request: Upload files

Not entirely sure where to submit feature requests for this app. But, it'd be nice if it had the ability for one to upload files like the Google Forms allows.

Scenario Example:
One uses a "private" form to create a record of things done and needs to attach pictures or documents of things to reference or document.

Don't change language

Hello!
My Nextcloud in Russian and default language in config Russian too.
But when I installed Forms, Forms stay in English.
As I understand, language files must be in l10n folder, but my folder is empty.
I tried put language files in l10n folder, but it no result.

Thanks and sorry for my bad english.

Internal server error when public link is used

Which Forms version are you running? (see apps page)
git [master] - see #166 why
Nextcloud or ownCloud?:
Nextcloud
Nextcloud/ownCloud version: (see Nextcloud admin page)
17.0.2

Steps to reproduce

  1. Create a form, set the access type to Public.
  2. Open the form link from private window.

Actual behaviour

Internal server error.

Expected behaviour

The link should provide access to the form.

Logs

  • Log from the admin panel:
[index] Error: Exception: Argument 2 passed to OCA\Forms\Db\NotificationMapper::findByUserAndForm() must be of the type string, null given, called in
<removed>/apps/forms/lib/Controller/PageController.php on line 281 at <<closure>>

0. <removed>/lib/private/AppFramework/App.php line 126
   OC\AppFramework\Http\Dispatcher->dispatch(OCA\Forms\Controller\PageController {}, "gotoForm")
1. <removed>/lib/private/AppFramework/oRuting/RouteActionHandler.php line 47
   OC\AppFramework\App::main("OCA\\Forms\\Controller\\PageController", "gotoForm", OC\AppFramework\ ... {}, {hash: "2tk0hQCg     ... "})
2. <<closure>>
   OC\AppFramework\Routing\RouteActionHandler->__invoke({hash: "2tk0hQCg ... "})
3. <removed>/lib/private/Route/Router.php line 297
   undefinedundefinedcall_user_func(OC\AppFramework\ ... {}, {hash: "2tk0hQCg ... "})
4. <removed>/lib/base.php line 997
   OC\Route\Router->match("/apps/forms/form/2tk0hQCgNLExJ9xK")
5. <removed>/index.php line 42
   OC::handleRequest()
GET /index.php/apps/forms/form/2tk0hQCgNLExJ9xK

Reason

userID will remain null in the scenario described above, which in turn causes the reported error.

Fix

The following patch contains a fix.

PageController_notifMapper_patch.txt

Cannot create new form

Forms version 1.1.0
Nextcloud version 18.0.0

Steps to reproduce

  1. Open a new form
  2. Enter name, description, and a question. Long Response was tested
  3. Click create

Expected behaviour

Create the form

Actual behaviour

[index] Error: Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'INSERT INTO oc_forms_events (title, description, is_anonymous, unique, access, owner, created, hash) VALUES(?, ?, ?, ?, ?, ?, ?, ?)' with params ["Title of Form", "Description of form", 0, false, "public", "jivvy", "2020-02-02 02:13:31", "7bJLcI1cVrMFGQSJ"]:

SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'unique' at row 1 at <>

  1. /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 169
    Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException("An exception oc ... 1", Doctrine\DBAL\Dr ... ]})
  2. /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 145
    Doctrine\DBAL\DBALException::wrapException(Doctrine\DBAL\Driver\PDOMySql\Driver {}, Doctrine\DBAL\Dr ... ]}, "An exception oc ... 1")
  3. /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php line 1063
    Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Doctrine\DBAL\Driver\PDOMySql\Driver {}, Doctrine\DBAL\Dr ... ]}, "INSERT INTO `oc ... )", {1: "Title of Fo ... "})
  4. /var/www/nextcloud/lib/private/DB/Connection.php line 220
    Doctrine\DBAL\Connection->executeUpdate("INSERT INTO `oc ... )", ["Title of Form" ... "], [2,2,1,2,2,2,2,2])
  5. /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php line 203
    OC\DB\Connection->executeUpdate("INSERT INTO `oc ... )", {dcValue1: "Titl ... "}, {dcValue1: 2,dcV ... 2})
  6. /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php line 215
    Doctrine\DBAL\Query\QueryBuilder->execute()
  7. /var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php line 126
    OC\DB\QueryBuilder\QueryBuilder->execute()
  8. /var/www/nextcloud/apps/forms/lib/Controller/ApiController.php line 495
    OCP\AppFramework\Db\QBMapper->insert(OCA\Forms\Db\Event {id: null})
  9. /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 170
    OCA\Forms\Controller\ApiController->writeForm({id: 0,hash: "", ... "}, {formQuizQuestio ... ]}, [], "create")
  10. /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 99
    OC\AppFramework\Http\Dispatcher->executeController(OCA\Forms\Contro ... "}, "writeForm")
  11. /var/www/nextcloud/lib/private/AppFramework/App.php line 125
    OC\AppFramework\Http\Dispatcher->dispatch(OCA\Forms\Contro ... "}, "writeForm")
  12. /var/www/nextcloud/lib/private/AppFramework/Routing/RouteActionHandler.php line 47
    OC\AppFramework\App::main("OCA\Forms\Controller\ApiController", "writeForm", OC\AppFramework\ ... {}, {_route: "forms.api.write_form"})
  13. <>
    OC\AppFramework\Routing\RouteActionHandler->__invoke({_route: "forms.api.write_form"})
  14. /var/www/nextcloud/lib/private/Route/Router.php line 299
    call_user_func(OC\AppFramework\ ... {}, {_route: "forms.api.write_form"})
  15. /var/www/nextcloud/lib/base.php line 1008
    OC\Route\Router->match("/apps/forms/write/form")
  16. /var/www/nextcloud/index.php line 38
    OC::handleRequest()

POST /nextcloud/apps/forms/write/form
from 192.168.254.15 by jivvy at 2020-02-02T02:13:31+00:00

Server configuration detail

Operating system: Linux 5.0.0-38-generic #41-Ubuntu SMP Tue Dec 3 00:27:35 UTC 2019 x86_64

Webserver: Apache/2.4.38 (Ubuntu) (apache2handler)

Database: mysql 5.7.28

PHP version:

7.2.24-0ubuntu0.19.04.2
Modules loaded: Core, date, libxml, openssl, pcre, zlib, filter, hash, Reflection, SPL, sodium, session, standard, apache2handler, mysqlnd, PDO, xml, apcu, bz2, calendar, ctype, curl, dom, mbstring, fileinfo, ftp, gd, gettext, gmp, iconv, igbinary, imagick, imap, intl, json, ldap, exif, msgpack, mysqli, pdo_mysql, apc, posix, readline, redis, shmop, SimpleXML, smbclient, sockets, sysvmsg, sysvsem, sysvshm, tokenizer, wddx, xmlreader, xmlwriter, xsl, zip, Phar, memcached, libsmbclient, Zend OPcache

Nextcloud version: 18.0.0 - 18.0.0.10

Updated from an older Nextcloud/ownCloud or fresh install:

Where did you install Nextcloud from: Nextcloud website

Signing status

Array
(
)

List of activated apps
Enabled:
 - accessibility: 1.4.0
 - activity: 2.11.0
 - admin_audit: 1.8.0
 - apporder: 0.9.0
 - breezedark: 18.0.2
 - bruteforcesettings: 1.5.0
 - cloud_federation_api: 1.1.0
 - cms_pico: 1.0.4
 - comments: 1.8.0
 - dav: 1.14.0
 - deck: 0.8.0
 - extract: 1.2.3
 - federatedfilesharing: 1.8.0
 - files: 1.13.1
 - files_pdfviewer: 1.7.0
 - files_rightclick: 0.15.2
 - files_sharing: 1.10.1
 - files_trashbin: 1.8.0
 - files_versions: 1.11.0
 - files_videoplayer: 1.7.0
 - firstrunwizard: 2.7.0
 - forms: 1.1.0
 - groupfolders: 6.0.1
 - issuetemplate: 0.6.0
 - logreader: 2.3.0
 - lookup_server_connector: 1.6.0
 - metadata: 0.11.1
 - nextcloud_announcements: 1.7.0
 - notes: 3.1.1
 - notifications: 2.6.0
 - oauth2: 1.6.0
 - privacy: 1.2.0
 - provisioning_api: 1.8.0
 - serverinfo: 1.8.0
 - settings: 1.0.0
 - sharebymail: 1.8.0
 - spreed: 8.0.1
 - survey_client: 1.6.0
 - systemtags: 1.8.0
 - tasks: 0.11.3
 - text: 2.0.0
 - theming: 1.9.0
 - twofactor_backupcodes: 1.7.0
 - updatenotification: 1.8.0
 - viewer: 1.2.0
 - workflowengine: 2.0.0
Disabled:
 - encryption
 - federation
 - files_external
 - guests
 - password_policy
 - photos
 - recommendations
 - support
 - user_ldap

Configuration (config/config.php)
{
    "passwordsalt": "***REMOVED SENSITIVE VALUE***",
    "secret": "***REMOVED SENSITIVE VALUE***",
    "trusted_domains": [
        "localhost",
        "192.168.254.14",
        "47.185.211.240"
    ],
    "datadirectory": "***REMOVED SENSITIVE VALUE***",
    "dbtype": "mysql",
    "version": "18.0.0.10",
    "overwrite.cli.url": "http:\/\/localhost\/nextcloud",
    "dbname": "***REMOVED SENSITIVE VALUE***",
    "dbhost": "***REMOVED SENSITIVE VALUE***",
    "dbport": "",
    "dbtableprefix": "oc_",
    "instanceid": "***REMOVED SENSITIVE VALUE***",
    "htaccess.RewriteBase": "\/nextcloud",
    "mysql.utf8mb4": true,
    "dbuser": "***REMOVED SENSITIVE VALUE***",
    "dbpassword": "***REMOVED SENSITIVE VALUE***",
    "installed": true,
    "app_install_overwrite": [
        "sharerenamer",
        "activitylog"
    ],
    "memcache.local": "\\OC\\Memcache\\APCu",
    "maintenance": false
}

Are you using external storage, if yes which one: local/smb/sftp/...

Are you using encryption: false

Are you using an external user-backend, if yes which one: LDAP/ActiveDirectory/Webdav/...

Client configuration

Browser: Brave, but autofill says: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.130 Safari/537.36

Operating system: Windows 10 Pro

Logs

Web server error log

Nextcloud log
[index] Error: Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'INSERT INTO `oc_forms_events` (`title`, `description`, `is_anonymous`, `unique`, `access`, `owner`, `created`, `hash`) VALUES(?, ?, ?, ?, ?, ?, ?, ?)' with params ["Title of Form", "Description of form", 0, false, "public", "jivvy", "2020-02-02 02:13:31", "7bJLcI1cVrMFGQSJ"]:

SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'unique' at row 1 at <<closure>>

 0. /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 169
    Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException("An exception oc ... 1", Doctrine\DBAL\Dr ... ]})
 1. /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 145
    Doctrine\DBAL\DBALException::wrapException(Doctrine\DBAL\Driver\PDOMySql\Driver {}, Doctrine\DBAL\Dr ... ]}, "An exception oc ... 1")
 2. /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php line 1063
    Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Doctrine\DBAL\Driver\PDOMySql\Driver {}, Doctrine\DBAL\Dr ... ]}, "INSERT INTO `oc ... )", {1: "Title of Fo ... "})
 3. /var/www/nextcloud/lib/private/DB/Connection.php line 220
    Doctrine\DBAL\Connection->executeUpdate("INSERT INTO `oc ... )", ["Title of Form" ... "], [2,2,1,2,2,2,2,2])
 4. /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php line 203
    OC\DB\Connection->executeUpdate("INSERT INTO `oc ... )", {dcValue1: "Titl ... "}, {dcValue1: 2,dcV ... 2})
 5. /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php line 215
    Doctrine\DBAL\Query\QueryBuilder->execute()
 6. /var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php line 126
    OC\DB\QueryBuilder\QueryBuilder->execute()
 7. /var/www/nextcloud/apps/forms/lib/Controller/ApiController.php line 495
    OCP\AppFramework\Db\QBMapper->insert(OCA\Forms\Db\Event {id: null})
 8. /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 170
    OCA\Forms\Controller\ApiController->writeForm({id: 0,hash: "", ... "}, {formQuizQuestio ... ]}, [], "create")
 9. /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 99
    OC\AppFramework\Http\Dispatcher->executeController(OCA\Forms\Contro ... "}, "writeForm")
10. /var/www/nextcloud/lib/private/AppFramework/App.php line 125
    OC\AppFramework\Http\Dispatcher->dispatch(OCA\Forms\Contro ... "}, "writeForm")
11. /var/www/nextcloud/lib/private/AppFramework/Routing/RouteActionHandler.php line 47
    OC\AppFramework\App::main("OCA\\Forms\\Controller\\ApiController", "writeForm", OC\AppFramework\ ... {}, {_route: "forms.api.write_form"})
12. <<closure>>
    OC\AppFramework\Routing\RouteActionHandler->__invoke({_route: "forms.api.write_form"})
13. /var/www/nextcloud/lib/private/Route/Router.php line 299
    call_user_func(OC\AppFramework\ ... {}, {_route: "forms.api.write_form"})
14. /var/www/nextcloud/lib/base.php line 1008
    OC\Route\Router->match("/apps/forms/write/form")
15. /var/www/nextcloud/index.php line 38
    OC::handleRequest()

POST /nextcloud/apps/forms/write/form
from 192.168.254.15 by jivvy at 2020-02-02T02:13:31+00:00
Browser log

ProxyBus.js:65 Proxying an event bus of version 1.1.2 with 0.2.1
t @ ProxyBus.js:65
globals.js:66 Handlebars is deprecated: please ship your own, this will be removed in Nextcloud 20
ne @ globals.js:66
issuetemplate:1 [DOM] Found 2 elements with non-unique id #operating-system: (More info: https://goo.gl/9p2vKq) <input id=​"operating-system" type=​"text" class=​"form-control">​ <input id=​"operating-system" type=​"text" class=​"form-control">​

Change language

Which Forms version are you running? (see apps page)
Version 1.0.3

Nextcloud or ownCloud?:
Nextcloud

Nextcloud/ownCloud version: (see Nextcloud admin page)
Nextcloud 16.0.4.1

Steps to reproduce

  1. Start Forms
  2. Search for language setting

Actual behaviour

Tell us what happens
--> can't change to german (or any other language than english).

Expected behaviour

I'd like to the Forms app to either assume the nextcloud language setting (which is german) or to be able to change the Forms app language manually.
Where can I do that?

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    πŸ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. πŸ“ŠπŸ“ˆπŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❀️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.