InfoPath Dev

I'm afraid translate() doesn't work like that.  Translate replaces single characters with other single characters, or it can remove single characters: http://www.w3.org/TR/xpath/#function-translate You can probably rig up something with rules and tricky XPath functions, but you risk causing an infinite loop error if there are ...

Thanks, Ted. This is very helpful and I'll be looking into a couple of your suggestions. As a follow up to option 3, I'm a little confused on how to properly set up the non-repeating form in a way that I can export data into Excel in the structure that I want. Can I set up a form where I have already populated each ...

I don't believe there should be a problem with this. Can you try it and let the community know if there were any issues? Thanks!

Interesting. translate() won't work for me either. I did manage to get something similar working:concat(substring-before(field1, ";;"), ";", substring-after(field1, ";;"))

The simplest solution is to add a field to the form. The user enters the workplace name into that field, and then clicks the button to query. The button would have rules to return only the filtered data, that is, the data that matches the workplace name that was entered. This blog post might be a good learning exercise since it deals with ...

If you're pulling the data from the same source and setting the query parameter (EmployeeName) before calling the data connection, then what you are describing should work. So, to be clear, the rules should be: 1. When Dropdown1 is not blank, use the Employee Name selected in dropdown1 to query the data connection, and return the numerous ...

Glad to hear it Hamish Thanks for taking the time to let me know

you can't auto-install activeX when they open a page - it requires client browser permissions. best thing you can do is send your users the activeX in advance and ask them to install but that's kind of lame since some may not do it. you definitely should just use XTPs. XTPs will work in 2003 but to use them you need to design the form in ...

You can't programmatically set the tooltips in the view XSLTs. You might be able to add some code to the XSLT that does this but we couldn't figure out a way to do it and it's probably a deep dive with no certainty of finding the treasure. I recommend just having a calculated value somewhere in your form that displays guidance ...

Can you attach your form?