submiting to MOSS lists

submiting to MOSS lists - part 2 :)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pedro Innecco - 13 Mar 2008 18:08 GMT

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-lis
t.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.

Reply to this Message

Clay Fox - 14 Mar 2008 06:22 GMT

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.

Signature

Clay Fox / Microsoft InfoPath MVP
www.InfoPathDev.com / The InfoPath Authority / Downloads, Samples, How-To,
Experts, Forum

> Hi there. I have a question which I hope someone can help me with.
>
[quoted text clipped - 24 lines]
> Regards,
> P.

Reply to this Message

Pedro Innecco - 14 Mar 2008 12:47 GMT

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... :(

> You could use conditional formatting on two repeating tables bound to the
> same list data.
[quoted text clipped - 40 lines]
>> Regards,
>> P.

Reply to this Message

Clay Fox - 14 Mar 2008 19:26 GMT

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

Signature

Clay Fox / Microsoft InfoPath MVP
www.InfoPathDev.com / The InfoPath Authority / Downloads, Samples, How-To,
Experts, Forum

> I'm afraid is not as easy as it looks.
>
[quoted text clipped - 62 lines]
> >> Regards,
> >> P.

Reply to this Message