Solved

SharePoint Online - How to create form for list and then create multiple list items from its completion?

Posted on 2016-10-27
9
45 Views
Last Modified: 2016-10-31
That title may have sounded weird, but hopefully this explanation makes it easier to understand.

Imagine a form with various items on it,each with a quantity drop down.  A user might select only certain of this items to change the default quantity from 0 to a larger number.  When the form is submitted, a list entry is created for each non-zero item.  Even better, the form itself is created dynamically from another SP list with one entry on the form for each item in the list.

Let me put some icing on the cake problem set.  The user would get an email listing the items he or she selected, and in this particular case since the items will be delivered to them, would reply - or something else similar - to update the list times by changing their status from ordered to received without specifically accessing the SP list.  I know that SP online cannot have emailed enabled lists, so is there another mechanism?

I am a bit open to third party products to solve this problem.
0
Comment
Question by:lmheimendinger
  • 4
  • 4
9 Comments
 
LVL 15

Expert Comment

by:Walter Curtis
ID: 41862681
You describe a classic e-commerce system. Take some time and design more accurately your requirements and things will become clearer for you, and anyone assisting.

Good luck...
0
 

Author Comment

by:lmheimendinger
ID: 41862720
I know exactly what it would look like and operate, but I am trying to map that into SP features.  That was the intent of my question.  Anyone else, please?

I would not characterize it as classic eCommerce, but do appreciate the analogy.  It is an internal system for moving test equipment and other physical assets around based on need.
0
 
LVL 15

Expert Comment

by:Walter Curtis
ID: 41862748
It is classic e-commerce is just an analogy based on what you describe. Basically, you have an order form that has items listed (with a pull down to select desired quantity). The order form then builds a pick list that so that the order is physically built in the warehouse, then generates a delivery order (showing details and anything that is on back order), sent to shipping, user notified of status and the mailman brings the goodies to the door.  So you aren't dealing in products and eCommerce, but from the design point of view, it is very similar.

SharePoint supports such a scenario with relational lists, lookup columns, connected web parts, BCS and some other things.

Good luck...
0
 

Author Comment

by:lmheimendinger
ID: 41862965
well yes it does.  Let me be a bit more specific.

1. How would I create a form that is populated from items in another list?  Variable in scope.
2.  How would I take a completed form and created multiple entries in an - call it an item requested - list from that single form?
3. What mechanism can I use to update a group of those created items in step 2, to wit, that they were actually received?  I want to make it very simple for the user to essentially just click that it has been done without editing each item.
0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
LVL 10

Expert Comment

by:Michael Vasilevsky
ID: 41863273
Since this is SharePoint Online you're going to be using JavaScript - what you're describing cannot be done out-of-the-box.

1. Run some JavaScript that generates an HTML form using REST or CSOM
2. On form submit populate an existing SharePoint list or create a new one
3. Some custom HTML with JavaScript could do this

Hope this helps!
0
 

Author Comment

by:lmheimendinger
ID: 41863302
Thank you.  Yeah, afraid of that.  I hung up my coding spurs years ago, just do a bit of HTML here and there but nothing elaborate.  I don't have a clue as to how to do #1 - run some JavaScript using REST or CSOM.  Don't know of REST to connect to or how to get it to run JS either!  Same goes for #2.

Would you be able to point me to some links that I might use to cookbook a solution?  If I get it to be a basic solution I can probably hack out a form

Then I would be onto the next issue:  how to take the submitted form and create multiple list entries from the fields on the form.  And lastly, of course, a way to get a response from a user that they did not receive the items so the list rows could be updated without individual editing.  At least I am not asking for much.
0
 
LVL 15

Accepted Solution

by:
Walter Curtis earned 500 total points
ID: 41863305
This is hard to say without seeing exact requirements, but nothing really seems as if it can't be done out of the box. Possibly some of the relational items need a small JavaScript function, but that is so common now it is basically out of the box. With the assistance of SharePoint workflows, the requirements can be met.

The problem, the procedure is not something that can be written up in a forum in just a few hundred characters. There are some links to references about creating such a system, again just a classic system. I will dig those up and post them.

Maybe I am missing something, but I don't think so...
0
 

Author Comment

by:lmheimendinger
ID: 41863307
Thanks I am looking at some JavaScript in REST articles now.  As in so many posts like those, they leave out a lot of steps assuming one knows them:  essentially how to get started in the first place, and then concentrate on the particular JS code.  I appreciate your assistance.
0
 
LVL 15

Expert Comment

by:Walter Curtis
ID: 41867263
Thanks
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I used to be SharePoint evangelist in our company, so my Outlook always full of questions about how to do this, or where I can find that. One day I found such an email with the following question: "how to attach 3-State workflow (one of the workflow…
Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now