Sending a form fails due to the connected spreadsheet not having sufficient rights

[dorkmaneuver]

Please use the 👍 reaction to show that you are affected by the same issue. Please don't comment if you have no relevant information to add!

Describe the bug
Users fill a form and get an error message without being directed to the completion page. The data is saved in the database but usually users will click on the button several times since they do not get a confirmations which leads to multiple identical entries.

To Reproduce
Steps to reproduce the behavior:

1. Share a folder with user X, without "delete" rights, so sudo -u www-data php /var/www/nextcloud/occ info:file will show for the user X "/user-x/files/: read, update, create"
2. In user X account, create a form
3. Connected a spreadsheet for the results in the folder, shared in step no. 1.
4. If you fill the form now, data is taken, but the app seems to delete and then re-export the spreadsheet, which is not possible, so it will fail.

Nextcloud:

• Nextcloud-Version: 28.0.9
• Forms-Version: 4.2.4

Possible resolution
Checking for delete rights of the folder or full permissions before being able to connect a spreadsheet could prevent this, including an understandable error message for the users to understand. In our case this was saved in a shared folder in order to make the results accessible for the whole team.

Thanks a lot for the wonderful plugin and your amazing work!!

[Chartman123]

Duplicate of #2067