Forum Widgets
Latest Discussions
Copying Excel spreadsheet
Hello Have created a group form and would like to use this form as a template for different events. Excel spreadsheet with responses is used with links and formulas in other worksheets. How can this spreadsheet containing the formulas be used as a template to use with other forms ie trying to avoid having to recreate the other worksheets that contain the formulas. Have tried various workaround which don't work: 1 Duplicate form / delete responses = does not delete responses from spreadsheet 2 Copy worksheet to new spreadsheet = does not work as the spreadsheet filename is part of the formula, so refers to the original spreadsheet (have tried find/replace all, but very cumbersome) Any suggestions, would be greatly appreciated. Thanks Andrea
Open URL in form in the same Tab
I have three forms. The first shows a link to one of the others two depending on the answers in the first. Clicking on the link opens the next form in a new tab. All well and good but the original form is left open in the original tab. Is there anyway to force the linked form to open in the original tab? I know you can force download of sharepoint files with &download=1 at the end of the urls for example, any url modifications that might do this? Other ideas welcome of course. Thanks, Sam.
Microsoft Forms: Multiple Choice Type is not showing all answers in SharePoint List
Hi, I have created a Microsoft form which contains a field "Pemohon". This field is a VLOOKUP of the type "Multiple Choice". The entries submitted in this form are reflected in the SharePoint list. After submitting the form, the multiple choices entered in the field are not visible in the SharePoint list. Only the first choice among the multiple entries is visible in the List under that field. Even if I edit the entries in the SharePoint list it is still not showing the multiple entries in that field. Is this a bug? or am I doing anything wrong? Anyone else facing this same issue?
Link an existing form with a new spreadsheet
Hi, my questions are quite simple really and are directed at Microsoft: When are you going to create the ability to link an existing form to a new spreadsheet? When are you going to make it possible to copy questions/menu options between forms? The bare functionality of MS Forms is embarassing. Regards, Noel
Custom messages for wrong/right answer in practice mode
Hi All, Creating a quiz form to do a knowledge check, and putting it in practice mode to prevent people from moving on to the next question until they get it right. If possible, I'd like to do custom messages guiding the user to the right answer, but there doesn't seem to be any way to customise this message; It just gives the same 'Nice try, you're almost there.' As per the second screenshot, it seems there is an option to put in some kind of custom message, but I can't seem to actually get those to appear when I preview the quiz in both practice and regular mode? Some clarity on how this works and if what I want to do is possible would be really welcome. Thanks, Ashleigh
Branching to previous questions in Forms??Workaround??
Hello! Does Forms allow you to branch from one question to a previously used question? I need this to collect data from multiple sections instead of creating a new Form for each question. Example: Q1: Select Insurance Coverage * Auto (what kind of Auto) * Home * Flood Q2: What kind of Auto? ** New (Would you like add'l coverage) ** Used (Would you like add'l coverage) Q3: Would you like add'l coverage? ** Yes ( Q1) .........<<????>>> ** No (End) Answering YES - The user could then go back to select another coverage and fill out the appropriate questions. Doesn't seem to work. Thanks!!! MattRestrict date submission in forms
I've recently made a digital marketing email request form so my team can better manage the email requests we get from various parts of our organization. Ideally, we would like for requesters to only be able to choose an email send date that is at least a month away from the date they are submitting the form. Is there any way to restrict requesters from picking a date that is less than 4 weeks from the date of their form fill in Microsoft Forms? Branching off of that if my above question is possible - would it be possible to to add a "Rush Request" field requiring justification/reason that appears if a requester does choose an email send date that is less than 4 weeks from the date of their form fill?
