Forum Discussion

Shiann Weiss's avatar
Shiann Weiss
Brass Contributor
Oct 03, 2018

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.

Resources