Newbie Questions

Re: getting multiple values when filtering list

Tuomo Ilonen2 — Fri, 26 Nov 2010 06:38:14 GMT

Ok i figured it out, tools and default values...

Re: getting multiple values when filtering list

Tuomo Ilonen2 — Fri, 26 Nov 2010 06:18:11 GMT

Hi Hilary,

About this attachment you sent long time ago. Now I need to understand it for other purposes but could you explain to me first how you have inserted 6 persons as a default to this list?

I don't seem to find any data except default values of "Sales" and "Jane" (1st row).

Apparently easy solution but I cannot figure it out

Re: getting multiple values when filtering list

Tuomo Ilonen — Tue, 27 Apr 2010 09:15:38 GMT

Hi,

Some things just have more simplier explanation than I can imagine. Never looked that option but know I do. Thanks!

Re: getting multiple values when filtering list

Qazi Anis — Tue, 27 Apr 2010 08:46:26 GMT

check attachment.

all i did was to set the size of the row in which the section were located to

Automatially set row height

Re: getting multiple values when filtering list

Tuomo Ilonen — Tue, 27 Apr 2010 08:01:45 GMT

Thanks. See attachment; there is the problem in all simplicity. Even though I hide the sections; there remains an empty space.

Re: getting multiple values when filtering list

Hilary Stoupa — Fri, 23 Apr 2010 16:25:40 GMT

When you reply, there is an Options tab. You'll find a place there to attach a file.

Re: getting multiple values when filtering list

Tuomo Ilonen — Fri, 23 Apr 2010 10:05:30 GMT

How do I insert/attach file?

Re: getting multiple values when filtering list

Hilary Stoupa — Wed, 21 Apr 2010 00:59:02 GMT

For your first issue, do you mean that when a row is hidden in a repeating table, you see a thicker border? I've had that happen, and if I recall, removing the top border from the row made it a bit prettier.

I'm afraid I don't understand the second issue you describe. Could you perhaps attach a sample template?

Re: getting multiple values when filtering list

Tuomo Ilonen — Mon, 19 Apr 2010 06:56:06 GMT

Hi Hilary, thanks for your answer, now I understood the method: binding and conditional formatting.

However I got a design/layout problem, this has occured me before and now with also this: Even though the rule "hide this control" applies; infopath doesn't completely hide the control but instead leaves it's borders visible. This results in a thin line (or space, if transparent borders) to the form. How do I get rid of those thin lines? Another problem is that even though I have a table (1x1) and hide the section that is in it (and made sure they are no space between section and table borders), still the table gives me blank row. Where can this blank row possible still come from??

Re: getting multiple values when filtering list

Hilary Stoupa — Sat, 17 Apr 2010 12:09:15 GMT

I've attached a sample that does this with conditional formatting. Right click the link in the post header, and save the template locally. Right click on the saved file and select Design to open in design mode. Preview and change the option button to watch the second table change.

Re: getting multiple values when filtering list

Tuomo Ilonen — Thu, 08 Apr 2010 07:21:02 GMT

Hi,

I'd like to put to more simple way: let's say I have sharepoint list with two columns "department" and "employee". The list would look like this:

Sales John

Sales Jane

HR Mark

Then I have repeating table (one column) in my InfoPath2003-form called "name". I also have option button which gives value "Sales". Now I would like to get first row of the repeating table to say "John" and second to say "Jane" (=all the names that belong to department "Sales"). How do I do that?

Re: getting multiple values when filtering list

Greg Collins — Fri, 19 Feb 2010 17:34:05 GMT

What exactly are you trying to do with it? Set a single field's value with multiple names? Are you using rules or code? With rules you will need to do a web search on how to use the eval() method. If code, you should be able to loop through all matching fields and build your own concatenated value.

getting multiple values when filtering list

Tuomo Ilonen — Thu, 18 Feb 2010 07:51:19 GMT

Hi,

I have simply problem but cannot figure it out. I have a sharepoint list with a columns department, email_address and number (which corresponds to department).

Now when I have two guys working in the same department the number column has the value "1" for both of them. When submitting the form I want these both guys to receive this form. But when I filter with following way (below) I can only first guy's email address. How I can get them both (and all guys that works in department "1")

@Email_address[@Number = 1]

Thanks in advance!