.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

Filter List Form Field

Posted By:      Posted Date: October 14, 2010    Points: 0   Category :SharePoint
 
Hello.  I've customized the Timecard Management template a bit.  The problem I've run into is that the PunchIn form lists all the projects in the Projects list without any filters.  As time goes on, the drop down box on PunchIn has gotten extremely long.  I'd rather not delete Projects and the associated data, but need to filter the drop down box for Projects with Status not equal to "Complete".  Any ideas how to help a nub with this issue?  Using SPD07.  Many thanks!


View Complete Post


More Related Resource Links

How To: Filter a link list dropdown field in a form based on Active/Inactive field in the linked li

  

I need to filter a dropdown field on a form that is linked to another list.  The linked list has a field active/inactive and I only want the active ones to show on the form.


Filter web parts in new form page of a list

  

Hi,

I've created 2 custom lists. The 2nd list has a lookup column from the 1st list. In the new form page for this 2nd list, I've added the 1st list as a web part. Now, I want to connect the 2 web parts, but it's not available. Basically, what I wanted is that when I select an item on the lookup column, the webpart containing 1st list would show that item on the same page.

I think I'll need to use Sharepoint Designer to implement something like this, but just wanted to check if anyone has done something like this using browser only.

 


Pman
http://www.pmansLab.com/

How to read a column of a sharepoint list to a text string field of infopath form?

  
My infopath form used to read these email addresses from a web service and web.config file. Now i would like to get these user email addresses from a contact list in a sharepoint server. I am trying to do this without writing any codes. Here is what i have done so far: 1. Adding a new "data connection to receive data from SharePoint library or List" where i selected Email Address column of the contact list. 2. I added a new Text Field and define a new rule with "Query using a data connection" defined above. When i try to access the newly created Text field above it always return empty as if the Query attached to it did not executed at all. What did i do wrong? Is there a better way? Thank you in advance for your help.

How to filter a List View by multiple values for one filter field?

  
Hi, I need to create a dynamically created link to a List View with a filter on one field, but with multiple values. Example: http://<server>/Lists/<list>/Allitems.aspx?FilterField1=Name&FilterValue1=John/Jack/Jonas which should give me all items where Name equals John, Jack or Jonas. Is this even possible?

Binding list to form not working with '&' character in list field data

  
Hi, I have a SharePoint list with a field called Title. I have a form based on this list with the field bound to the form as a label (for workflow to access). Here is the code for the form field. <asp:Label runat="server" id="ff2{$Pos}" text="{@Title}" __designer:bind="{ddwrt:DataBind('u',concat('ff2',$Pos),'Text','','ID',ddwrt:EscapeDelims(string(@ID)),'@Title')}" /> I have a workflow that runs through a form action button which take ff2 (title) and  does other stuff. The problem I have is with records where the value of 'title' contains the '&' character (example ab&cd). Blank is pulled in by the workflow when I get the value of ff2. I am guessing it has to do with the data binding and/or escape (special) characters coming through but I don't know how to fix it. Any help will be greatly appreciated

Get the field of form into list

  

Hi I want to modify the list column according to info path field.

I get the field name in column list and it is sure that that column is specifically used in info path form, But when i changed the value in list it is not showing the exact value in the list.

 

Please help as early as possible.


How to map the new field added to the new form to the list?

  

I have replaced sharepoint form field tag with input type text field. it does not store in the list. how it can be stored to the list

Thanks in advance


Resize a Sharepoint Field on the Custom list form

  

Hi All Gurus...

I'm just looking for a way to resize the form field input boxes for a custom list form. I don't think I'm understanding how the displaysize attribute works. It doesn't take "px" or maybe I'm looking at the wrong thing. I know this is a easy question

Pls help its urgent

SPtech07


Compare InfoPath Form Field to Document Library list in SharePoint

  

I have an infopath form that has a field that matches values in a SharePoint List. In the SharePoint List I have two fields, One is email and the other is the field I am trying to match on. When the form is submitted I want to take that field from the form and compare it to the SharePoint list and return the email that is associated with that list item. Can this be done?? I appreciate any assistance. Thank you.


Compare InfoPath form field to SharePoint List

  

I have an infopath form that has a field that matches values in a SharePoint List. In the SharePoint List I have two fields, One is email and the other is the field I am trying to match on. When the form is submitted I want to take that field from the form and compare it to the SharePoint list and return the email that is associated with that list item. Can this be done?? I appreciate any assistance. Thank you.


Compare InfoPath form field to SharePoint List

  

I have an infopath form that has a field that matches values in a SharePoint List. In the SharePoint List I have two fields, One is email and the other is the field I am trying to match on. When the form is submitted I want to take that field from the form and compare it to the SharePoint list and return the email that is associated with that list item. Can this be done?? I appreciate any assistance. Thank you.


Bind Infopath 2010 Form Control to another List Field

  

Hi, I am having Sharepoint 2010 RTM Enterprise Trial on Windows Server 2008 SP2.

I have Two Lists (List1 and List2) and List2 has a lookup field for List1 ID.

I want to bind some of the controls on infopath form of List1 to List2 fields such that when the user enters the values, these values would be saved in List2 and when the user want to edit the data of List1, the values can be retrieved from List2 on Form Load.

can it be done ?

can it be possible without having a field in List1 (direct binding to List2 field) ?

thanks.

BDC field cannot save on Custom List Form

  
Hello,

I'm having a problem with a Sharepoint Business Data Catalog, I have a List which are connected by BDC to a SQL field/table, and with standard sharepoint Forms it all works fine, I can lookup data in BDC and it saves correctly.

However, I need to create a Custom List Form for New Items on this list, and whenever I do this - the BDC works for lookup, but it doesnt save the data in the List when the item is created ?
(All normal fields save, but the BDC field is just empty on the new Item)

Anyone got any bright ideas? Cause I'm running out.

Data Form Web Part - Sharepoint Dropdown List as a field in Edit View - Possible?

  

Hi guys,

I'm building a Sharepoint page with a data form web part that uses custom SELECT and UPDATE statements with an SQL Server connection in order to retrieve and store records of information.

I'm getting along fine, records seem to update how they should etc, but I've ran into a problem with one thing: Sharepoint dropdownlists in 'Edit Template'

So the issue is this: if I replace a textbox field with a dropdown list that is populated with a separate SQL datasource, the dropdown list seems to be unable to show the current value of the field.

E.g. I have a dataview which has a field "FruitID", which I can update just fine by setting the ID value to different numbers. The SQL datasource uses the FruitID to display a list of all available Fruits, (e.g. 1 = Banana, 2 = Apple, 3 = Cherry, etc).

If i open the dataview in editmode, the default value in the dropdown is null, despite the real value of the field being "2", which should show "Apple" in the dropdown.

I can select a fruit and click save, and it will update just fine. But the initial display needs to show the correct value to start with.

Is there a custom binding I should be coding to make this work? I can't configure dropdown <items> on an individual level as they are populated from the SQL server. I can't set "SelectedI

How to send an email to Supervisor (field in the form) after New Item in a list is created?

  

I have user who creates a record and User's Supervisor, who need to get notification about new record (different Users have different Supervisors and they input them manually into field when create a new record).

(Users I've mentioned are domain users with emails assigned to them and we use Outlook that is integrated with our sharepoint)

 

1) I've tried to create a workflow in Sharepoint Designed (as described here: http://social.msdn.microsoft.com/forums/en-us/sharepointdevelopment/thread/2A525E2F-2407-42C9-AB9D-B5FB609B34B5) , but there I can choose only concrete email address (I need it to be populated from the field on the form).

I think the workflow can be configured somehow to send an email to user from a field, but I don't know how. 

 

2) I've created a new view with filters by Supervisor and configured Alerts for the view, but it is too complicated for all Supervisors to do that. (just not the best solution)

 

any ideas? 


InfoPath Calculated Field doesn't Post to SharePoint List when form is submitted

  

I have a nice InfoPath form that includes a calculated total field.  That works great.   The form is published to a SharePoint list and when users of the form Submit the form to the list the form information neatly populates to the list.   Well, all of the fields populate to the list except for the calculated total field, that one is just blank.  Naturally, I've noodled around to figure out why and therefore I'm here now asking for guidance.   What should I be focusing on to resolve this issue?

Thanks


custom field type works in view properties, but not in list view: 3 parent fields filter child list,

  

My situation:

A) odd thing is that no matter where I put a stop point in my custom field type, it is NEVER hit when the items are displayed in list view.  Event with <Field Name="CAMLRendering">TRUE</Field> which causes the list to error out, but again no stop point to help me know why.

B) the value of the column in question will be different for every user who views the list, I'm querying a secondary list based on the user's loginName, and two of the fields from the list we're in. 

C) the display is customized based on whether any records were returned and the current DateTime, so possible displays would be "", "! 12/1/2010", and "7/7/2011"

D) and the text displayed links over to a form for them to do their assignment. the link url would be a config setting url + "?[one of the fields form the list we're in]"

My questions:

1) Is it possible for fieldtype code to execute while a list view is being rendered?

2) If not, then should I chase down the path of a content query webpart?  Will it be able to filter on the current users login name?

3) If not on 1 or 2, can you think of any other way to do this beyond creating a custom application page? (need to having filtering and sorting on this page)


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend