Export submission id and attachment id

[Luchostein]

Include the form_id, submission_id and attachment_id s when querying the form results; specially when receiving file uploads, the exported spreadsheet/CSV only contains the filenames.

• Nextcloud-Version: any
• Forms-Version: any

Is your feature request related to a problem? Please describe.

I need to match the uploaded files with the form answers of their specific form submissions. Uploaded files are stored under a directory hierarchy consisting on the form id, the submission id and their attachment ids. Nowadays, the only way to match the files with their respective submissions is through the REST API. If the submission id and attachment ids were included in the exported sheet, it would be way easier to match them just by watching the filesystem.

Describe the solution you'd like

Permanently add a column to the exported spreadsheet/CSV including the submission id and, when uploading files, besides their filename, also include their attachment ids, so they can be easily matched looking at the directory names and sheet entries.

I mean, it is not impossible to disambiguate the association between the form submission and the multiple attachments, but is definitely not straightforward for a user without recurring into extra programming.

Describe alternatives you've considered

Querying the REST API to obtain the details from ambiguously associated uploaded files.

[susnux]

Uploaded files are stored under a directory hierarchy consisting on the form id, the submission id and their attachment ids.

Then I guess the proper solution would be to include the full filepath in the export. The IDs are internal and should not be exported, as the use case of the ODS/CSV export is for analysis and not low level data access (for that you have the REST API).