Newbie Questions

Re: Auto populate from AD, filter not working

Kazzahere — Wed, 11 Jul 2012 16:09:00 GMT

That was it!! You are a genius.

MIS revisited the data and cleaned it up as there was a number of blank spaces after the 4 digit entry code.

I really appreciate your help and the time you have given this problem.

Thank you

Re: Auto populate from AD, filter not working

Hilary Stoupa — Wed, 11 Jul 2012 15:14:58 GMT

Well, the problem is the value in the Initials field is not actually equal to the value in the ID Number field. Are there any spaces after the value in the Initials field?

Re: Auto populate from AD, filter not working

Kazzahere — Wed, 11 Jul 2012 09:07:33 GMT

Am thinking this is not good as they all display false. It has automatically pulled all the details through so Initials, Surname and Forename are there but the validation field states False. Not what I was hoping for but I think that's what you expected.

Does this help establish the problem?

Thanks

Re: Auto populate from AD, filter not working

Hilary Stoupa — Tue, 10 Jul 2012 18:43:42 GMT

Here's a copy with an expression box indicating whether the initials match the ID_Number - preview it and enter an ID_Number and see if any of the expression boxes display "true".

Re: Auto populate from AD, filter not working

Hilary Stoupa — Tue, 10 Jul 2012 18:34:21 GMT

Sorry - hadn't seen your post - I'll take a look today.

Re: Auto populate from AD, filter not working

Kazzahere — Tue, 10 Jul 2012 14:47:01 GMT

Hi Hilary

Sorry to ask again but wondered if you had reached a conclusion as to what I am doing wrong re this form. I only have a couple more days in this role and would love to complete this project before I go.

Thanks very much

Re: Auto populate from AD, filter not working

Kazzahere — Wed, 04 Jul 2012 08:30:35 GMT

I see. I didn't make the Staff ID Number a drop down as there are approximately 1500 staff so I thought that might be a bit excessive.

Is an expression box a control? Sorry, I thought I was getting the hang of this but seems I don't even know the basics.

I have attached the form as mentioned as I'm not sure what I am doing but happy to give it a try if you can provide me with steps. Whatever way is easier for you.

Thanks

Re: Auto populate from AD, filter not working

Hilary Stoupa — Tue, 03 Jul 2012 18:42:02 GMT

The controls on your form are bound to fields in your data source. If your "Staff ID Number" text box had been a dropdown instead, I wouldn't be able to tell from the screenshot if the values were the same. They sure look the same, don't they?

You could add an expression box (calcuated value) in the repeating section with the formula @Initials = ID_Number - that is, just a formula checking to see if each Initials field is equal to the ID_Number field in your main data source - We'd expect the expression box to evaluate to true on the second row there. Attach your template if you'd like me to set that up for you.

Re: Auto populate from AD, filter not working

Kazzahere — Tue, 03 Jul 2012 12:22:53 GMT

I'm not too sure what 'text box bound to the ID_Number field' meant sorry but I have added a screen shot of a couple of fields from the Link to AD data connection and the form I want the data to populate.

Really appreciate your help, thanks.

Re: Auto populate from AD, filter not working

Hilary Stoupa — Mon, 02 Jul 2012 16:24:34 GMT

And you've confirmed that there is a value in your "Link to AD" data connection in the @Initials field that exactly matches the current value in the ID_Number field? Can you attach a screen shot in under the Options tab that shows that? Put the Link to AD data fields on your form, as well as a text box bound to the ID_Number field...

Re: Auto populate from AD, filter not working

Kazzahere — Mon, 02 Jul 2012 16:07:59 GMT

I am hoping this is what you need, totally alien to me.

xdXDocument:GetDOM("Link to AD")/dfs:myFields/dfs:dataFields/d:k_qlp_AD/@Forename[../@Initials = xdXDocument:get-DOM()/my:myFields/my:ID_Number]

Re: Auto populate from AD, filter not working

Hilary Stoupa — Mon, 02 Jul 2012 15:59:28 GMT

What does the full XPath for the formula look like? In the formula editor there is a checkbox for showing the full XPath - can you paste that in a reply?

Re: Auto populate from AD, filter not working

Kazzahere — Mon, 02 Jul 2012 09:34:15 GMT

Hi Hilary

Thanks for your response.

I dragged the fields onto the form and previewed it and they all seem to be populating as expected. I have a test account that I am using and the details are showing for that.

It only seems to be a problem when I add the filter as it pulls through otherwise.

Any suggestions on what else I can try.

Thank you

Karen

Re: Auto populate from AD, filter not working

Hilary Stoupa — Fri, 29 Jun 2012 19:35:03 GMT

Hi - If you haven't already done this, perhaps drag the data fields from your secondary data connection onto your form - so you can see them all. Make sure any of the fields you are using in your filter are visible. And remember that XPath is case sensitive - usually when I have problems like this (with filters) it turns out things don't have the values I think they do... :-)

Auto populate from AD, filter not working

Kazzahere — Thu, 28 Jun 2012 11:48:03 GMT

I am trying to pull information through from AD to populate a form of staff details when the staff id number is entered.

I have created a data connection and linked to this in a fields default value. The link appears to be working as it's pulling a name through until I add a filter. I have looked at other posts on here and thought what I was adding was correct but the field stays blank. I end up with this @Forename[@Initials = IDNumber], where Forename is what I want in the field, it looks to my secondary data connection (AD) at the initials field and should equal the IDNumber field on the main data connection (the form).

I have no idea what I am doing wrong and would appreciate any help.

I have no knowledge regarding code so hoping there is a simple solution.

Thanks

Karen