filter data - InfoPath Dev
in

InfoPath Dev

filter data

Last post 06-03-2014 01:29 PM by kevin_carter. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next

  • 05-30-2014 05:42 PM

    filter data

    Reply Contact

    Hi everyone,

    i know i asked this before but i am trying it with sharepoint now instead of SQL

    i am new to using infopath, but trying to get my head around it.

    i have create a form the user enters data into, the form can not be completed by the creator, this means another user has to open the form to enter data into it.

    what i have done is create several listboxs is name, department and request. so when department is selected it returns only the names that work in that department and when the name is selected it returns the requests made by the user.

    this is working fine

    What i want to do is use a button to filter a sharepoint list with the results of the selections and  change to a view diplaying the results on the form.

    i have tried using rules but am strugling to return the correct results (i always return the all the record on the list)

     does anyone know if this can be done ? i prefer not to use code if possible

     

    thank you for your time

     

    Kevin

     

  • 06-01-2014 10:21 PM In reply to

    Re: filter data

    Mark as Answer
    Reply Contact
    Hi Kevin, Do you mind attaching the form so i can take a look? cheers!

  • 06-03-2014 01:29 PM In reply to

    Re: filter data

    Mark as Answer
    Reply Contact

    i have a  list in sharepoint containnig operation numbers ie op 20 , op 30

    in infopath i have created a form (search) that displays the operations in the listbox(op_num) and a button that runs a rule

    i have create a view that i want to display the reults of the query

    so on the search form the user would select an operation ie op 20 then click the button the view would change to reults form displaying only op 20 data

    the rules i have set up are

    query the the data connection.

    Action  =  set fields value

    Field = Op_num

    Value = Operation [.=Op_num]

    problem is this is returning all the values

    any ideas

    kevin

     
Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.