Re: Filtering

donstephen — Wed, 29 Jan 2014 16:44:29 GMT

Hi Raad89,

The current() value here might not be returnng values equal to the site field you are comparing it to. For a more detailed explanation on the current() function, please check this link. Also, I am attaching a sample form which shows a rule which uses the current function to populate a field, and another rule which uses an ID field for filtering values (download attachment and open in design mode). Hope this helps.

Filtering

Raad89 — Tue, 28 Jan 2014 22:31:47 GMT

Hi,

I am newly using infopath, and so far it has been a fun experience.

However, I do have a problem with filtering. FYI, I am using Infopath WebBased 2007, since the sharepoint that I am using to publish my work is 2007.

I do have a drop down called "site", and I want based on the selection for the site, relevant "Site Phone" and other contact information to appear in the following fields.

I got the the cities name from w sharepoint library. To do so, I went on the drop-down properties, and I marked "Get choices from an external data source, which is the sharepoint library. (Therefore, I've got a second connection)

Now, here where the problem is, I've ran action rules on the "site" drop-down to set value of "site phone" based on the selection of the "site".

In the attachment, you can find the formula that I have input in the value field in order to get the intended results.

With this formula, the field is autopopulating, however the data that it pulled are not correct. It basically pulled the first phone number on the list which probably belong to Canada, however, the site that I have chosen is USA.

By the way, I tried to filter from the drop down properties, but the error message that I got is that filtering is not supported in InfoPath 2007 Web Browser Forms. (I don't want to change that since I want the form to be filled witihin the sharepoint browser.

Any help will be greatly appreciated

Thank youuu!

General

Re: Filtering

Filtering