submiting to MOSS lists - part 2 :)

[Pedro Innecco]

Hi there. I have a question which I hope someone can help me with.

I followed the tutorial posted on the InfoPath blog about submitting to MOSS
lists and it works great!
(http://blogs.msdn.com/infopath/archive/2007/03/26/submitting-to-a-sharepoint-list.aspx)

However, what I would really like to do is to display two tables:

* Both tables would display the items included in the SharePoint list (e.g.:
the MyContacts list in the example from the blog).

* However, TABLE 1 would show only items where the Boolean column MyColumn
equals 0.

* TABLE 2 would show only items where the Boolean column MyColumn equals 1.
Plus, for each row there would be a checkbox.

* Upon submitting the form, for every item ticked in table two would update
the MyColumn column in SharePoint. Thus updating the list of TABLE 1.

Is this possible to be done, without coding? I am a little bit rusty with
InfoPath these days but I think this could be possible with the use of
filters and conditionals?

Thank you a lot in advance!

Regards,
P.

 

[Clay Fox]

You could use conditional formatting on two repeating tables bound to the
same list data.

One would show your first case boolean not = 0 Hide
and the other the second boolean not = 1 Hide.

If you update the list then it would show up in the first once the submit
and re-query took place.

No code needed.

 

[Pedro Innecco]

I'm afraid is not as easy as it looks.

I can easily do that, but the as per the tutorial I mentioned, I can't.
Simply put, the tutorial only explains how to create a repeating table that
would give you the inputs to add items on the first table. I can't find a
way to simply return ONE field (that is, the checkbox), and moreover, to
have this field within TABLE 1.

As a workaround (and a dirty demo trick), I tried to have two tables, and
use a workflow:

Table 1 conditional: boolean not = 0 hide
This table simply outputs all the items from the MOSS list that are
UNCHECKED

Table 2 conditional: boolean not = 1 hide
This table outputs all the items from the MOSS list that are CHECKED, plus
the checkbox itself for the user to check.

Problem is, once the user ticks the box on table 2, InfoPath tries to be a
wise-a** and keeps updating the tables... Very inconvenient...

 

[Clay Fox]

I think this is possible with the correct logic.

You would add another item to the list, the checkbox value.

Then you would use logic to control when the update was executed.

Difficult without seeing it.
If you want send me an email, we could look at a web meeting to troubleshoot
and discuss possibilities.
http://www.infopathdev.com/members/clayfox.aspx