Forms Results & Excel Spreadsheet

%3CLINGO-SUB%20id%3D%22lingo-sub-1417949%22%20slang%3D%22en-US%22%3EForms%20Results%20%26amp%3B%20Excel%20Spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1417949%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20There%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20seem%20to%20be%20having%20a%20problem%20with%20Forms.%20We%20have%20lots%20of%20group%20forms%20on%20the%20go.%20When%20bringing%20up%20the%20results%20via%20excel%20spreadsheet%20it%20appears%20that%20people%20have%20not%20answered%20some%20questions%20when%20they%20were%20required%20fields.%20How%20is%20this%20possible%3F%20When%20looking%20into%20this%20by%20clicking%20the%20review%20results%20button%20the%20items%20which%20they%20have%20been%20able%20to%20bypass%20are%20in%20red%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22In%20red.JPG%22%20style%3D%22width%3A%20963px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F194419iE50ACED7ABC10D11%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22In%20red.JPG%22%20alt%3D%22By%20passed%20questions%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EBy%20passed%20questions%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%20when%20I%20click%20'Open%20in%20excel'%20it%20has%20started%20opening%20it%20as%20an%20'excel%20workbook%20in%20one%20drive'%20rather%20than%20in%20the%20excel%20app%2C%20can%20this%20be%20changed%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20it%20does%20this%2C%20it%20seems%20to%20bring%20up%20the%20results%20for%20a%20totally%20different%20form%20i.e%20I%20open%20Safeguarding%20adults%20form%20and%20when%20I%20open%20the%20results%20(Excel%20workbook%20in%20one%20drive)%20I%20see%20results%20for%20the%20Urgent%20Care%20form.%20Can%20anyone%20help%20as%20this%20is%20really%20going%20to%20screw%20with%20our%20data%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1417949%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Frequent Visitor

Hi There,

 

I seem to be having a problem with Forms. We have lots of group forms on the go. When bringing up the results via excel spreadsheet it appears that people have not answered some questions when they were required fields. How is this possible? When looking into this by clicking the review results button the items which they have been able to bypass are in red

 

By passed questionsBy passed questions

 

 

Also when I click 'Open in excel' it has started opening it as an 'excel workbook in one drive' rather than in the excel app, can this be changed?

 

When it does this, it seems to bring up the results for a totally different form i.e I open Safeguarding adults form and when I open the results (Excel workbook in one drive) I see results for the Urgent Care form. Can anyone help as this is really going to screw with our data?

0 Replies