SOLVED

Form for multiple entries over weeks with multiple users

%3CLINGO-SUB%20id%3D%22lingo-sub-2943946%22%20slang%3D%22en-US%22%3EForm%20for%20multiple%20entries%20over%20weeks%20with%20multiple%20users%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2943946%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20create%20a%20form%20where%20each%20user%20completes%20the%20form%20and%20the%20data%20populates%20a%20particular%20column%20and%2For%20row%20of%20the%20spreadsheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20an%20effort%20to%20minimize%20user%20error%20is%20it%20possible%20to%20send%20the%20same%20form%20each%20week%20over%20ten%20weeks%20but%20cause%20the%20form%20to%20populate%20different%20columns%2Frows%2Ftabs%20based%20on%20who%20the%20user%20is%20using%20email%20address%20and%20the%20date%20the%20form%20is%20filled%20out%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2943946%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESurvey%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2946732%22%20slang%3D%22en-US%22%3ERe%3A%20Form%20for%20multiple%20entries%20over%20weeks%20with%20multiple%20users%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2946732%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1196595%22%20target%3D%22_blank%22%3E%40brainstewn%3C%2FA%3E%26nbsp%3BForms%20certainly%20has%20no%20functionality%20to%20do%20anything%20like%20that.%20You%20would%20probably%20need%20to%20build%20a%20flow%20in%20Power%20Automate%20with%20a%20link%20to%20the%20form.%20You'd%20either%20have%20one%20flow%20per%20week%20or%20have%20a%20separate%20flow%20for%20each%20week.%20You%20could%20set%20it%20going%20automatically%20with%20a%20recurrence%20schedule%20trigger.%20But%20then%20you'd%20have%20to%20work%20out%20whether%20the%20flow%20was%20saving%20all%20the%20responses%20into%20the%20smae%20spreadsheet%20or%20have%20a%20separate%20spreadsheet%20for%20each%20week%20then%20merge%20them.%20Not%20simple.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I want to create a form where each user completes the form and the data populates a particular column and/or row of the spreadsheet.

 

In an effort to minimize user error is it possible to send the same form each week over ten weeks but cause the form to populate different columns/rows/tabs based on who the user is using email address and the date the form is filled out?

1 Reply
best response confirmed by brainstewn (Occasional Contributor)
Solution

@brainstewn Forms certainly has no functionality to do anything like that. You would probably need to build a flow in Power Automate with a link to the form. You'd either have one flow per week or have a separate flow for each week. You could set it going automatically with a recurrence schedule trigger. But then you'd have to work out whether the flow was saving all the responses into the smae spreadsheet or have a separate spreadsheet for each week then merge them. Not simple.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User