General

Re: Repeating Data Form/List Display in Dashboard Problem

Hilary Stoupa — Tue, 10 Nov 2015 17:38:51 GMT

Thanks for the offer on the revisions - I've gotten a copy of this webinar packet so I can check into the other bug you mention. Feel free to email me your suggestions - you have my email address. :)

Right now you have the hyperlink for the part number directed to Material Link from the Revisions link. I'd just drag the entire Revisions data source onto the form to check the values - doing that I can see that you have a value that looks like it was meant to be a formula. I see in the rules on Material Link in the Revisions data source that you may have pasted an XPath into the Value instead of clicking fx and entering a formula.

Re: Repeating Data Form/List Display in Dashboard Problem

Majik — Tue, 10 Nov 2015 01:40:29 GMT

I updated my form, but I changed your expression a little bit, as the Part Number shouldn't need to be included as a field in the List. I adjusted this to be ParentID instead. It works! I can finally move on.

THANK YOU FOR YOUR HELP!

I would recommend that the Webinar instructions be updated, unless there is a reason why my form didn't work because it is a little different setup. I have stated before that there is an error on the first part of the instructions as well and a couple things that could be wrote a little different to eliminate some confusion. I am going to go back over it as to update my form library to not use the part number for the name of the xml. If you guys want I could make the corrections and some wording adjustments to it and send it over to you. I spent a lot of time in the graphic design/printing field, so I pay really close attention to wording and such.

Since you have my form and the templates installed on your server, could you possibly take a look at why I can't get the Part Number link to link to its form? Right now I just have the expression as a text link, I know it needs to be in the formula box, but it won't accept it there. I think that is the formula I was trying to use, I haven't looked at it in over a week.

Thanks again!

Re: Repeating Data Form/List Display in Dashboard Problem

Hilary Stoupa — Tue, 10 Nov 2015 00:54:47 GMT

Change the condition on the section that has your "child" data in it. Modify the first dropdown to "The expression" and then delete anything currently in the text box next to it - then put in:

count(../d:SharePointListItem_RW[d:PartNumber = current()/d:PartNumber and d:HideShow = 1]) = 0

I'm attaching a copy of your form with this change in place for you to try.

Re: Repeating Data Form/List Display in Dashboard Problem

Hilary Stoupa — Tue, 10 Nov 2015 00:40:14 GMT

Only the first instance of HideShow for each Part Number is being set when the button is clicked. I'm pretty sure we can work around this with a slightly more sophisticated expression for the formatting - give me a few minutes and I'll have something for you to try.

Re: Repeating Data Form/List Display in Dashboard Problem

Hilary Stoupa — Tue, 10 Nov 2015 00:10:05 GMT

Right - I don't know why this isn't working. The symptoms as you describe them are very odd, and looking at the form I don't see anything wrong. I've forwarded your most recent post to Patrick to see if he has any insight. I also emailed you via the form to see about getting your list templates so I can set this up in my enviro and see if I can repro it.

Re: Repeating Data Form/List Display in Dashboard Problem

Majik — Mon, 09 Nov 2015 23:55:13 GMT

So, I assume then that you are not sure why this is not working? Is there anyway that this issue can be show to Patrick Halstead, as he is the one who wrote this instructional?

I was thinking about signing up for one of the service plans when I was having an issue getting the data to populate the child list correctly, but with some help I was able to get that working, obviously. But, with this issue, it should work as it is. That is my conclusion, though I have limited experience (so far) with InfoPath.

Any final suggestions before I start over from page one on the first section of the webinar? ...though I can't see getting any other results from the dashboard by changing the couple things I need to change to have it match more exactly what the webinar said.

Either way, thanks for your help in this matter!

Re: Repeating Data Form/List Display in Dashboard Problem

Hilary Stoupa — Mon, 09 Nov 2015 23:41:55 GMT

The reason I asked about browser vs. filler is that I recall there being a browser bug related to hyperlinks when there are multiple instances of the same repeating group on the form. But since you have the exact same issue in filler (preview), that isn't it. :)

Re: Repeating Data Form/List Display in Dashboard Problem

Majik — Mon, 09 Nov 2015 23:31:46 GMT

Without the rule it shows all revisions of the parts, like in the screen shots above. With the rule, it only displays the first revision.

I sure wish it was only in preview, but it is the same in both views.

I deleted everything from the form and list and reentered some information. I attached screen shots of the Form, List and the Dashboard views. All from the browser. I am working on a Surface Pro 3 right now, but get the same results when trying to view them on other machines.

Re: Repeating Data Form/List Display in Dashboard Problem

Hilary Stoupa — Mon, 09 Nov 2015 22:03:29 GMT

Oh - are your screenshots from preview? Or from the browser? Does the issue happen in both preview & the browser?

Re: Repeating Data Form/List Display in Dashboard Problem

Hilary Stoupa — Mon, 09 Nov 2015 22:01:29 GMT

So - if you go and remove the "Hide" rule on the section with the detailed data - the form will display the correct data in each section?

Re: Repeating Data Form/List Display in Dashboard Problem

Majik — Mon, 09 Nov 2015 19:28:55 GMT

Yes this is very odd. The form I attached was with the rule in place for the child data. But, yes the screenshots are that form, one with the rule and one without.

Like I had stated, this is directly from the Webinar I bought from Qdabra. In those instructions it doesn't even have the child hide rule. Like I stated, I do not have the link working for each part number to link to their form in the form library, but not sure why that would have an effect on this. I also had to add in a GetDOM formula to pull the description and supplier info correctly as it was displaying the info from the very first part number in the list. For instance, the form had "First Part" and "13" displayed for each part number, by just binding them directly to the corresponding fields in the Form Library data connection. Though, this alteration had no effect before and after I added it.

Any ideas at all?

This week as I get time(as infopath and sharepoint aren't a part of my job description), I am going to go back and completely redo the submit/CAML part of this process to ensure it is 100% correct. But, as it is pulling the info correctly before adding the Hide rule, I am pretty sure that I will have the same results afterwards. There is one thing I know I need to change, and that is the name of the forms. Currently I just have them named by the part number, like 123456.xml instead of using a detailed name with a time stamp, etc.

Thanks again for your time!

Re: Repeating Data Form/List Display in Dashboard Problem

Hilary Stoupa — Mon, 09 Nov 2015 16:25:21 GMT

How odd - everything looks right. I don't understand how the hide rule is causing this - both screenshots are the same form, just with no rule?

Re: Repeating Data Form/List Display in Dashboard Problem

Majik — Sat, 07 Nov 2015 06:02:56 GMT

Dashboard Images

Re: Repeating Data Form/List Display in Dashboard Problem

Majik — Sat, 07 Nov 2015 05:53:04 GMT

Ok, so I did get some time now to go through this. I had some problems with my 3D printer that need some attention first.

I attached the new form along with screen shots of what the form does with and without the Hide Rule for the Child Section.

I am still having an issue linking the Part Number link to the actual form, but I am going to keep trying to work on that, doesn't seem as though the Instructional formula is working for me. I currently just have some text in the link that is kinda what the link should be, so I know the way it is it definitely won't work. My main concern is just getting the child info to show up correctly and I just don't understand why it doesn't work properly with the Rule in there.

Thanks ahead of time!

...guess I can't upload multiple files, will attach the screen shots to another reply.

Re: Repeating Data Form/List Display in Dashboard Problem

Majik — Thu, 05 Nov 2015 20:43:18 GMT

Firstly, I want to say THANK YOU! I initially was stuck on the 1st part of the 2-28-13 webinar which I bought, with some help on here I was able to resolve that. Though in the 1st section of the webinar package there is one error on the UPDATE/ADD rules, which I had pointed out a while ago. I re-downloaded it yesterday to see if it was updated and it was not, though it should be. The part I was stuck on was the very end of the instructional, as the wording was not very descriptive/easy to understand. I have done a lot of print designing, work instructions and the like, so that section should be updated too. All of this in my opinion of course.

So, with Part 2(dashboard) of the webinar, I pretty much went through the instructions and used the template provided. I didn't completely do the Hyperlink section, or I should say I did, then removed some of it. Though it hasn't worked either way. There is not a rule in the instructional to add to the child section, which I thought was weird too. I then added a rule to hide it, when I did this, it would only show the 1st item of the child data and not all of the repeating data. Without the rule it does show all repeating data. I am not sure why it doesn't work properly with the rule.

I am going to start over on this tonight at work and upload the form when I get it done. Again, THANK YOU for your response.