InfoPath Dev

I'm guessing we are cross posting a bit -- to clarify the first sample does not use qRules, but default values and a manual manifest change. The second sample uses qRules. So now you have two choices!

Well, to use qRules, you'd need take the approach outlined in this document. Basically, you'd have to insert into your main data source the number of groups you need, then you can use a counter field to loop through and set values. Since the counter will move from n to 0, the items may be in the opposite order you expect, but you can ...

That is exactly what I'm looking for!  Did you use qRules for the form loads?

How could i get qRules to do this?

I have a few forms experiencing the same issue. The only way I've found around this is to change the permissions to full on the form and create a digital certificate (which expires within a couple months). I would love to find out how to get this back to domain level instead of creating new ceftificates every couple months!

The translate function is removing the "-" from your dates, so that the dates are numbers like 20110301 or 20110809. Now the operator ">" knows what to do, since you are comparing two numbers....

I had the same problem, just follow this simple answer https://msmvps.com/blogs/sundar_narasiman/archive/2008/05/20/how-to-install-vsta-visual-studio-tools-for-applications.aspx I hope it will work for you as well.

I have found the error - theirs not mine!! The problem is in username() function. In infopath filler, it returns the username you have logged on - in Sharepoint , in upper case (always?). So, if you log on as domain/username or domain/USERNAME, infopath filler would show respectively username or USERNAME. Thanks

[quote user="Patrick Halstead"] Hi B1rds, You need to use the current() function to do this and not an absolute xpath. Search this forum for "xpath current" to find examples. [/quote]   Hi Patrick Looked into the Current() function, the problem I face is that this will only look up the current row, I want to be able ...

I think i got it working with translate, as suggested by Jimmy and a push from Hilary. in text box properties date1 i went to tab display, button conditional formatting. The first puldown menu i have te date1 field (from my database) then the second puldown i have is less than or equel to and the last puldown i have chosen Use a ...