Form Submissions causing duplicate names on sheet
hi there!
my department is sending out forms to various departments, and when they fill in the form and submit it, it adds the entry to the bottom of the sheet. my problem is I already have the names listed on the sheet, so their names are being added twice. is there a way to delete the name that is blank above once the person submits the form?
Answers
-
Unfortunately no. within the same org it would be easier to use the "update request" option, or put the name in the url string instead of on the form itself, so that when they fill out the form it auto populates the name.
this would like this…
yourformlink?Name=persons%20name
add this string to the end of your link replace "name" with your column name to collect the data. use %20 for any spaces in columns names or person's name.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!