Forum Discussion
Submit another response and duplicate some fields
I have set up a form to process internal communication requests. Each response will feed an excel table which will update an excel pivot that works like a calendar view. In order to have different communication requests for the same campaign that happen on different days (or series of days), I need several fields to be the same row to row.
Simplified Example: I want to send an email on 10/3 and another email on 10/7 as part of multi-wave campaign. In order for my pivot to update my calendar view correctly, I would need two rows like this:
Campaign Name | Communication Type | Start Date | End Date
Email Campaign1 | email | 10/3 | 10/3
Email Campaign1 | email | 10/7 | 10/7
It would make it easier on the submitter if they only had to update Communication Type | Start Date | End Date
Therefore, I was wondering if it was a way to add a button at the end of the form (next to submit another response) that would either:
A. Duplicate all fields again and allow for edits
B. Duplicate specific fields and leave blank other fields that need to be differentiated.
- Not currently no. Forms is a pretty simple forms app. If it's internal, I would recommend SharePoint custom list. You can set the form column defaults there no problem. You can also tie it better to flow etc.