General

Re: 2010 Browser forms w/ conditional formatting?

shniggens — Thu, 06 Jan 2011 00:10:21 GMT

OK, now I feel like a colossal ***.

This appears to be a BROWSER ISSUE!

I have tried it on Firefox, Chrome, and Safari . . . and it works no problem.

Internet Explorer 8 (7, and XP), gives me error on page -

Webpage error details

User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.3; .NET4.0C; .NET4.0E)
Timestamp: Thu, 6 Jan 2011 00:07:40 UTC

Message: Invalid argument.
Line: 2
Char: 452421
Code: 0
URI: http://10.10.2.139/_layouts/inc/Core.js?rev=8PdoqL6fQahtzwwVSZ2lpw%3D%3D

WTH!?!?!?

Maybe I'll start a new topic

Re: 2010 Browser forms w/ conditional formatting?

Hilary Stoupa — Wed, 05 Jan 2011 23:54:04 GMT

To my knowledge there should be no issue with having multiple controls bound to the same data source with different formatting on them (again, you know what I'll say -- test in a sample form. Create a repeating group in your data source, add a bunch of controls on the form bound to that table, set them with different formatting -- in fact, you probably have a sample form from earlier in this discussion that shows this).

If it were my form, I'd probably take a somewhat nuclear approach, set postback to always on my tables, controls in tables, controls outside of tables that affect my tables, anything that I think could be causing the problem. Publish, see what happens. If things start behaving the way you anticipate, then you can gradually start changing the postback on your controls back to a more conservative approach, and check after each change.

Re: 2010 Browser forms w/ conditional formatting?

shniggens — Wed, 05 Jan 2011 23:38:54 GMT

Also, if I change the conditional formatting to just "Don't allow users to inert or delete this control", everything works. This seems to just be a problem when the conditional formatting on this repeating table is set to "Hide this control".

I'll just shut up for now. But for Pete's sake, if anyone has any ideas, or suggested workarounds, please let me know!

Thanks!

Re: 2010 Browser forms w/ conditional formatting?

shniggens — Wed, 05 Jan 2011 23:28:29 GMT

Another wierd thing . . .

I removed the conditional formatting from the tables that show the saved data from SharePoint (multiple tables bound to the the same table copied over from SharePoint), and the controls post back whether there is data there or not. Which doesn't make sense, because the controls I'm concerned with are not in those tables.

Is it OK to have multiple tables bound to the same repeating table with different formatting?

Anyone have ANY idea what the hell this might be happening!!??!?!!?!

Re: 2010 Browser forms w/ conditional formatting?

shniggens — Wed, 05 Jan 2011 20:13:50 GMT

Ok, here's an interesting development. I added the rule to delete my saved purchases table (the table that get's pulled in from SP) on form load. Now the controls post back on load. This has something to do with this other table. Basically, if there is data in the saved purchases table, the controls in the new expense table don't want to post back.

/thinking out loud.

Re: 2010 Browser forms w/ conditional formatting?

shniggens — Wed, 05 Jan 2011 19:56:31 GMT

Would it matter what position I'm inserting the row on? I'm using default (last). That still wouldn't explain why they don't postback on form load.

Re: 2010 Browser forms w/ conditional formatting?

shniggens — Wed, 05 Jan 2011 19:48:02 GMT

CopyTable does not run on form load.

I don't know that using a sample form is going to show me anything here, as there are so many variables involved in my form. I had published the "Attachment Type" form that you sent me before, and it behaved normally.

And yes, my SaveToSharePoint is mapped, because it works fine in the client.

Re: 2010 Browser forms w/ conditional formatting?

Hilary Stoupa — Wed, 05 Jan 2011 19:16:32 GMT

CopyTable doesn't run when the form opens, does it?

Yet your controls don't post back initially.

Try a sample form, see what happens -- just create a simple sample with the same controls that are causing you troubles on open in this form. Publish it and see how it behaves in the browser.

If your qRules link isn't being submitted to ShP -- is it getting populated prior to your submit to SharePoint list being run? Is it mapped?

Re: 2010 Browser forms w/ conditional formatting?

shniggens — Wed, 05 Jan 2011 19:01:30 GMT

Well, the other tables are all the same schema as my SP list, and they are only to display data. The problem controls are not there.

The attachment option button is bound to "attachmentType" attribute under "Attachment" (another thing to note is that the qRulesLink is not being submitted to SP, either, but I was going to save that for later).

Do I need to have all the attachment controls set to postback always?

The other control to set the status is completely independent of everything else, and does not exist anywhere else in the form.

It's strange that this only occurs when CopyTable finds an existing entry for this job. If CopyTable get's error "Cannot find row specified" (which means it doesn't exist, right?), then this does not happen.

Also, they don't post back initially when the form is opened.

I'm reaching for that fork again.

Re: 2010 Browser forms w/ conditional formatting?

Hilary Stoupa — Wed, 05 Jan 2011 18:42:01 GMT

Since your issue seems to be one of postbacks, it is expected it would work in client as anticipated....

So, not to belabor the basics, but you have mentioned before you have various tables connected to the same data showing on your form, and that they have conditional formatting on them... any chance you have these controls on your form more than once and they aren't all set to postback always?

Re: 2010 Browser forms w/ conditional formatting?

shniggens — Wed, 05 Jan 2011 18:37:27 GMT

This behavior only exists in the browser. The client works as it should.

Re: 2010 Browser forms w/ conditional formatting?

Hilary Stoupa — Wed, 05 Jan 2011 18:29:38 GMT

I find this confusing as well, simply because the data is separate from controls in InfoPath. Thus, there is no reason that deleting, adding, updating data would change something like how a control works (barring, of course, conditional formatting, etc).

Re: 2010 Browser forms w/ conditional formatting?

shniggens — Wed, 05 Jan 2011 18:26:49 GMT

Another interesting thing -

The postbacks don't work when the form is initially opened either. Not until a job is picked ( a job without previous data, of course ). Hmmmmm. . . .

Re: 2010 Browser forms w/ conditional formatting?

shniggens — Wed, 05 Jan 2011 18:13:20 GMT

I've done some testing, and have found .

one rule that prevents the postbacks . . .

I have static fields at the top of my form for name, job number, etc. I have a repeating table (insert/delete disabled) for users to enter expense information. They click a save button after each entry to save this info to SharePoint (and sets it to Saved status). I have another repeating table to pull data back from Sharepoint, and display conditionally on status.

My "Job Picker" drop down list has 7 rules applied to it -

-Delete expense table (qrules) - deletes the expense table whenever a job is selected.

- Insert blank row (qrules) - inserts a new, blank row of the expense table

- Propogate fields - propogates other fields, such as job location, start and end dates, etc.

- Delete Saved Purchases (qrules) - deletes the repeating table bound to the SharePoint list (showing saved or other expenses depending on status)

- Set Query Fields - Sets the SharePoint query fields to filter on Employee and Job Number

- Query List - Queries the Expense List on SharePoint.

- Copy Table (qrules) - copies the SharePoint Table into my main data source.

In the Expense Table (user input), I have an option button to display either picture control or file attachment depending on what user picks. This needs to ALWAYS post back. I also have a checkbox to allow user to set a status to "Pending", and a rule will set that status when a user clicks save.

Now, when a user picks a job that has no previous data saved for that job, the postbacks work fine. If the user picks a job that HAS previously saved data, the postbacks STOP working. If I disable the last rule (CopyTable), the postbacks work no matter what job is picked.

Why the heck would this happen? Why is this table being affected by CopyTable, which is bound to a completely different table?

Re: 2010 Browser forms w/ conditional formatting?

shniggens — Wed, 05 Jan 2011 04:25:45 GMT

So here's another wierd thing that I can't get sorted out.

I have a repeating table to record the employee's expenses (with the add/delete rows disabled). Once they click a "Save" button, the expense is set to a particular status, saved to SharePoint list, copied back into the main data source to the appropriate table (conditionally formatted to sort by status). This all works.

After an expense is saved, I have qrules delete the user input expense table, and insert a new, blank row. That works fine, too.

In the user input table there is a option button that sets the attachment field to either a picture or file control. This works (posts back) only the FIRST time data is entered. After the main table (user input/expense) is deleted and re-inserted, these controls don't post back to the server anymore.