Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Get data from one list to another based on a condition

  Asked By: Joseph    Date: Jan 30    Category: Sharepoint    Views: 3089

I want to be able to get data from one list to another based on a condition. I
want to achieve this by using out of the box functionality.

For example if a List called product with price is there. The marketing team has
a list of products which they can market. Only those products which have the
status as approved from prod list should appear in the marketing product list.

Please let me know if this is possible out of the box or what is the way to get
this done. I dont want it to be a read only view as there will be other data
added to marketing team list for all approved products.



2 Answers Found

Answer #1    Answered By: Glenda Roth     Answered On: Jan 30

I've done things similar to this, but not out of the box  so to speak. I used
SPD to make a workflow to accomplish this.

Answer #2    Answered By: Jada Clemons     Answered On: Jan 30

Unfortunately, you have to do a bit of customization. I believe, no
out-of-the-box solution is available.

Long back Patrick T had provided a simple JavaScript-based solution for similar
requirement. You need to edit the New/Edit forms with SPD. The solution is
available at blog.u2u.info/DottextWeb/patrick/articles/466.aspx

Else, you may try custom column type enhancing the lookup columns.

Didn't find what you were looking for? Find more on Get data from one list to another based on a condition Or get search suggestion and latest updates.