-
From what I can see your filter is on the name field not on the client drop down.
You would need to edit the dropdown, I believe you want some cascading drop downs. You can do a search and find lots of examples for cascading.
I am not sure if you are putting a filter on data in your main data source or the secondary but I believe you have placed ...
-
Could you give me the details on that. And is that faxing an Infopath View?
-
Hi
Could this be that although the display name is TOM is the data being recorded actually something different like TOM's ID. If so, then the filter would have to reference his ID not TOM.
Cheers
-
it's not working when I try field6 is not equal to TOM.
not sure what to do, help please
-
Hi,
is there a way (maybe code) to automatically print a form to pdf from a button?
Thanks.
-
Hi
I think this is becuase it sorts by the first record in the field list so put the username before the userID and that shoudl work fine if my understanding is correct.
cheers
-
Hi
I totally agree with Clay that SQL is the preferred databae for speed. It also beats SharePoint hands-down with reporting possibilities. Using Microsoft Query you can link Excel into the database to pull back the latest results every time it is opened. Go into Excel, Data, Import External Data, and select new database query, ...
-
Hi
I think if I understand you correctly then yes, you can.
Put a field in the repeating table linked back to your main source. Set its default value to your sum, but filter both elements by having a field for the row number of the row on the table.
I hope this helps
Cheers
-
Hi deep
To achieve the multiple filtering you would have to concatenate the multiple selects with a OR or similar to allow for the filter.
To just link the drop-down list to teh SharePoint list and filter to this one concatenated field. Not tried this myself but see if you can make it work.
I hoep this helps
Cheers
-
Hi Tom
I have achieved both of these with a workaround that is not elegant but works a treat.
1) Set a field outside the repating bit that COUNT(s) the first field on the row and set it to fail is COUNT = 0
2) Set a rule on the first field in the repeating table that set another field in the repeating table to 1 if not blank. Add another ...