-
Hm, I'm not sure that you will be able to do this with InfoPath's SQL abilities - they seem to be a bit limited. However, take this advice with a grain of salt as I am not even close to being a SQL expert, and can't honestly say that I know what an ''implied Inner Join'' is.
What I would do is make two seperate data connections to both tables ...
-
Hm, that looks right, but current() can get tricky sometimes. What I like to do to debug is to put the formula local-name(current()) into the node that you are trying to use this formula with and then you will know exactly what node you are dealing with and how you should reference your aCostCentre node.
-
The primary problem is that the position() function give the correct position in an expression but always returns ''1'' in a text box.
So the expression box that gives my my position value, I need to display in another view in a printed version of the form. However the expression box I recreate elsewhere always displays ''1''. Driving me crazy...
-
I'm glad you could figure it out Senor Villareal!
-
I agree with Abhishek here, this could probably be done with XPath, but it's going to take 5x the amount of time to figure it out than just using code. If code is not an option, you could, of course, concoct some crazy XSL+XPath to do this.
-
I don't understand your problem here, Taffman. You say it's working great and then you go to another view and it's different? Are you performing any actions on the node while switching views? Are you using an expression box or actually storing the numbering a node?
-
I used this formula to get rid of one of the &s, maybe you could cook up something with eval() to do it recursively?
concat(substring-before(field4, ''&''), ''and'', substring-after(field4, ''&''))
-
Sorry to insult your intelligence, Dean. :)
This is a rather interesting problem, and I think I have solved it with this formula:
concat(''0'', field1) + concat(''0'', field2)
The problem was that the node wasn't blank, it just wasn't present. So, tacking a zero to the most significant digit will allow the nodes that are not present to simply ...
-
I was originally going to say that drgkreddy's first solution had worked, but what actually happened was that when I put in the conditional formatting, it removed the ''cannot be blank'' requirement.
However, the combination of the two data validations suggestions is working perfectly. Thank you so much - this will really open up several ...
-
Bonjour,
Peut être que ma question est basique, mais pour une novice comme moi, tout message d'erreur devient vite compliqué à gérer...
En résumé, j'ai crée un formulaire sans codes, ni restrictions d'accès spécifiques.
Celui-ci fonctionne parfaitement en interne: les utilisateurs complètent le formulaire, qui est ensuite envoyé à un ...