Creating a form with calculations

%3CLINGO-SUB%20id%3D%22lingo-sub-860406%22%20slang%3D%22en-US%22%3ECreating%20a%20form%20with%20calculations%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-860406%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Guys%2C%3C%2FP%3E%3CP%3EI%20have%20a%20form%20which%20works%20really%20well%20where%20individual%20can%20record%20the%20response%20to%20each%20individual%20question%20set%20but%20thats%20is%20only%20achievable%20for%20half%20of%20the%20part.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EScenario%3A%3C%2FP%3E%3CP%3EI%20am%20wanting%20my%20team%20members%20to%20fill%20out%20a%20consumption%20pre%20event%20%26amp%3B%20post%20event%20which%20should%20give%20me%20the%20final%20numbers.%20Example%20as%20below%3A%20that%20should%20update%20my%20sharepoint%20list%20via%20flow.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EItem%26nbsp%3B%20%26nbsp%3BStarting%20Stock%26nbsp%3B%20%26nbsp%3BClosing%20Stock%26nbsp%3B%20%26nbsp%3BFinal%20Stock%2FActual%20consumption%3C%2FP%3E%3CP%3ECoke%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%2010%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%205%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%205%3C%2FP%3E%3CP%3ESprite%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%208%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B2%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%206%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EQuestion%20is%2C%20if%20this%20is%20achievable%20as%20a%20part%20of%20the%20same%20form%2C%20if%20not%20how%20can%20it%20be%20achieved%3F%3C%2FP%3E%3CP%3EThanks%20Himanshu%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-860406%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Eautomated%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Ecalculations%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-860706%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20a%20form%20with%20calculations%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-860706%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F410747%22%20target%3D%22_blank%22%3E%40HimanshuS87%3C%2FA%3E%26nbsp%3Bare%20you%20using%20Forms%20or%20Forms%20Pro%3F%20If%20Forms%20Pro%20you%20could%20do%20something%20with%20Microsoft%20Flow.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20don't%20see%20it%20being%20part%20of%20one%20form%20unfortunately.%20I%20think%20I%20see%20it%20more%20like%20this%3A%3C%2FP%3E%3CP%3EFORM%20QUESTIONS%3C%2FP%3E%3CP%3EQuestion%201%20-%20Event%20Name%2FCode%20-%20ideally%20something%20unique%3C%2FP%3E%3CP%3EQuestion%202%20-%20Choice%20-%20Pre%20Event%20or%20Post%20Event%20(user%20selects%20which%20one%20they%20are%20completing)%3C%2FP%3E%3CP%3EQuestion%203%20-%20Text%20-%20Coke%20Stock%20-%2010%3C%2FP%3E%3CP%3EQuestion%204%20-%20Text%20-%20Sprite%20Stock%20-%208%3C%2FP%3E%3CP%3EAnd%20so%20on%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThen%20the%20user%20fills%20the%20same%20form%20out%20again%20at%20the%20end%20of%20the%20event%2C%20with%20everything%20being%20filled%20out%20and%20Question%202%20being%20selected%20as%20Post%20Event.%20If%20your%20event%20name%20or%20code%20is%20unique%20and%20the%20person%20completing%20it%20is%20unique%2C%20you%20could%20do%20something%20with%20the%20results%20to%20add%20to%20your%20SharePoint%20list.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi Guys,

I have a form which works really well where individual can record the response to each individual question set but thats is only achievable for half of the part. 

 

Scenario:

I am wanting my team members to fill out a consumption pre event & post event which should give me the final numbers. Example as below: that should update my sharepoint list via flow. 

 

Item   Starting Stock   Closing Stock   Final Stock/Actual consumption

Coke          10                      5                      5

Sprite          8                       2                      6

 

Question is, if this is achievable as a part of the same form, if not how can it be achieved?

Thanks Himanshu

1 Reply
Highlighted

@HimanshuS87 are you using Forms or Forms Pro? If Forms Pro you could do something with Microsoft Flow. 

I don't see it being part of one form unfortunately. I think I see it more like this:

FORM QUESTIONS

Question 1 - Event Name/Code - ideally something unique

Question 2 - Choice - Pre Event or Post Event (user selects which one they are completing)

Question 3 - Text - Coke Stock - 10

Question 4 - Text - Sprite Stock - 8

And so on

 

Then the user fills the same form out again at the end of the event, with everything being filled out and Question 2 being selected as Post Event. If your event name or code is unique and the person completing it is unique, you could do something with the results to add to your SharePoint list.