Solved

SharePoint Custom List APP or Not?

Posted on 2011-03-25
2
280 Views
Last Modified: 2012-05-11
Looking for guidance to see if SharePoint lists can handle this logic...

Where you have two lists, list1 is the detailed record and list2 are records associated with an entry in list1

For example

LIST1
SiebelID            Opportunity Name         Original B&P     Orig Date          Approved B&P              Last Update


LIST2
SIebeID            ReqType           Date     Approver          Status               Amount


So the first time a request is placed with a SIEBEL ID and approved in LIST2 it creates a record in LIST1 and the original B&P and Approved B&P are set to amount from LIST2
Each time a subsequent approved record is added to LIST2 corresponding LIST1 is updated adding Amount to Approved B&P
0
Comment
Question by:Matt Pinkston
2 Comments
 
LVL 5

Expert Comment

by:navdeepmadan
ID: 35217031
sure. it can be achevable thought workflows and event handler.
0
 
LVL 3

Accepted Solution

by:
matsonpp earned 500 total points
ID: 35217542
Have you looked into using SharePoint Designer? Depending on whether you are using SharePoint 2007 or SharePoint 2010, use the corresponding version of SharePoint Designer (it's free). This software allows you to do all kinds of things with SharePoint including the ability to create workflows that kick off when list items are modified.

The logic as I see it would be:
Pick List2 as the list to attach the workflow to as that list looks to be the driver of all this.
Have the workflow activate on both "add" and "update"
Step 1 conditional: When approved column = "approved" and if no items already exist in list1 with current items SIEBEL_ID column value
Step 1 action: Create list item in list1 with various properties (you will see this is very straight-forward as SharePoint designer is a very GUI based workflow builder)

Else: Update list item in List1 with SIEBEL_ID = to current list item's SIEBEL_ID set values to their current value plus the value of each field you would like to have as the increment amounts.

If you need specific step by steps, let me know, I can walk you through it.

Regards,
Matt
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

I have just recently built a new SharePoint 2007 farm on a complete Windows 2008 R2 server platform and part of my standard build procedure is to implement a warm up routine, usually in the form of a script that is scheduled every morning to launch …
If you create your solutions on SharePoint sooner or later you will come upon a request to set  permissions of the item depending on some of the item's meta-data - the author, people assigned as approvers, divisions, categories etc. The most natu…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

809 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