Using the same field across different forms in one sheet
Hi there,
I'm working to build a request management system using forms where requestors will simply see a dashboard with icons/text and can select the type of request they need to submit. Since each request is quite different and I want to track the different types of requests, I'd like to list "Request Type" in each of the different forms. Ideally, these forms would all be set up from one sheet so that it can feed into a metrics dashboard. Is there any way to do this?
Setting up a different sheet for each form isn't ideal, as the people responding to the requests are on one team, and it would be far better to see an aggregate view of all requests (not to mention needing the automatic numbering system that comes from having one sheet).
Many thanks in advance!
Best Answer
-
Yes you can do this. In the upper left of your sheet you can see the forms button. From there make a form for each request type. Per each form youll have to go in and Pre-fill the forms request type to the kind of form you want it to be and then make that question on the form hidden so the user cant change it. All of these forms will feed the same sheet.
Ricky T
Gov Contractor for USSF
Answers
-
Yes you can do this. In the upper left of your sheet you can see the forms button. From there make a form for each request type. Per each form youll have to go in and Pre-fill the forms request type to the kind of form you want it to be and then make that question on the form hidden so the user cant change it. All of these forms will feed the same sheet.
Ricky T
Gov Contractor for USSF
-
Thanks, RickyT! What I'm running into is that I can't even use a field called "Request Type" in each form - I'm getting an error message that says "column name is already in use in this sheet."
-
Nevermind - I was completely missing that "Request Type" was autopopulating whenever I tried to create a new form. The idea of auto-selecting the relevant request type and then hiding that field in the form is smart - I will be doing that. Thank you!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives