SOLVED
Home

Permanent home for a form for ongoing input?

%3CLINGO-SUB%20id%3D%22lingo-sub-1183210%22%20slang%3D%22en-US%22%3EPermanent%20home%20for%20a%20form%20for%20ongoing%20input%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1183210%22%20slang%3D%22en-US%22%3E%3CP%3EEach%20time%20we%20on-board%20a%20new%20customer%2C%20our%20salespeople%20have%20to%20provide%20our%20operations%20team%20with%20the%20exact%20same%20contact%20information.%20We%20on-board%205-6%20new%20customers%20a%20week.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20past%2C%20we've%20used%20a%20master%20spreadsheet%2C%20and%20the%20salespeople%20enter%20the%20required%20data%20directly%20into%20the%20sheet.%20That%20gets%20messy%2C%20as%20they%20ignore%20some%20data%2C%20or%20accidentally%20alter%20data%20in%20other%20cells%20on%20the%20spreadsheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20since%20I%20discovered%20MS%20Forms%20(yesterday!)%2C%20I%20was%20thinking%20a%20good%20solution%20might%20be%20to%20create%20a%20form%20for%20the%20salespeople%20to%20enter%20this%20data.%20That%20way%20they%20never%20have%20to%20access%20to%20the%20spreadsheet%2C%20just%20the%20form.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20my%20question%20is%20--%20How%20do%20I%20get%20them%20to%20use%20the%20form%20on%20their%20own%2C%20without%20having%20to%20ask%20me%20for%20the%20link%20to%20the%20form%20every%20time%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20first%20time%2C%20I%20can%20share%20%2F%20email%20%2F%20message%20them%20the%20link%20to%20the%20form.%26nbsp%3BBut%20it%20will%20be%20easy%20for%20them%20to%20lose%20track%20of%20that%20link%20--%20and%20then%20we're%20back%20to%20them%20asking%20me%20to%20send%20the%20link%20again.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20way%20I%20can%20make%20a%20%22home%22%20for%20the%20form%20in%20Office%20365%20or%20Sharepoint%2C%20so%20they%20can%20simply%20visit%20a%20page%2C%20click%20a%20link%2C%20and%20start%20filling%20out%20the%20form%20(without%20being%20able%20to%20edit%20the%20form%20itself)%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20they%20can%20bookmark%20a%20page%20to%20get%20to%20the%20form%2C%20they%20won't%20have%20to%20bug%20me%20as%20much%20for%20the%20link%20%3A%5E)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20that%20makes%20sense.%20Any%20suggestions%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1183210%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1183265%22%20slang%3D%22en-US%22%3ERe%3A%20Permanent%20home%20for%20a%20form%20for%20ongoing%20input%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1183265%22%20slang%3D%22en-US%22%3E-%20honestly%2C%20if%20they%20are%20old%20enough%20to%20work%2C%20and%20hold%20down%20a%20job%2C%20I%20think%20they%20should%20be%20able%20to%20manage%20bookmarking%20the%20link%20to%20the%20form%20in%20their%20browser%20on%20their%20own%20right%3F%20If%20you%20still%20need%20to%20do%20something%20you%20can%20add%20links%20to%20sites%20so%20it%20would%20show%20in%20Office%20365%20when%20they%20log%20in.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1188489%22%20slang%3D%22en-US%22%3ERe%3A%20Permanent%20home%20for%20a%20form%20for%20ongoing%20input%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1188489%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F422134%22%20target%3D%22_blank%22%3E%40OldFatDog%3C%2FA%3E%26nbsp%3Byou%20could%20have%20a%20Microsoft%20Forms%20web%20part%20on%20your%20SharePoint%20homepage%20so%20they%20just%20go%20to%20that%20site%2C%20complete%20the%20form%20and%20click%20submit%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22formsWebPartSP.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F172677i2254E431CE089498%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22formsWebPartSP.png%22%20alt%3D%22Microsoft%20Forms%20web%20part%20on%20SharePoint%20page%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EMicrosoft%20Forms%20web%20part%20on%20SharePoint%20page%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Each time we on-board a new customer, our salespeople have to provide our operations team with the exact same contact information. We on-board 5-6 new customers a week.

 

In the past, we've used a master spreadsheet, and the salespeople enter the required data directly into the sheet. That gets messy, as they ignore some data, or accidentally alter data in other cells on the spreadsheet.

 

But since I discovered MS Forms (yesterday!), I was thinking a good solution might be to create a form for the salespeople to enter this data. That way they never have to access to the spreadsheet, just the form.

 

So my question is -- How do I get them to use the form on their own, without having to ask me for the link to the form every time?

 

The first time, I can share / email / message them the link to the form. But it will be easy for them to lose track of that link -- and then we're back to them asking me to send the link again.

 

Is there any way I can make a "home" for the form in Office 365 or Sharepoint, so they can simply visit a page, click a link, and start filling out the form (without being able to edit the form itself)?

 

If they can bookmark a page to get to the form, they won't have to bug me as much for the link :^)

 

I hope that makes sense. Any suggestions?

2 Replies
Highlighted
- honestly, if they are old enough to work, and hold down a job, I think they should be able to manage bookmarking the link to the form in their browser on their own right? If you still need to do something you can add links to sites so it would show in Office 365 when they log in.
Highlighted
Solution

@OldFatDog you could have a Microsoft Forms web part on your SharePoint homepage so they just go to that site, complete the form and click submit:

Microsoft Forms web part on SharePoint pageMicrosoft Forms web part on SharePoint page

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User