-
Can you attach your form in a reply under the options tab?
-
I did. I pressed "function" than insert function and took the concat function and I double clicked on the fields to add field2 and field4... :(
-
Ah, this means when you wrote your formula, you likely just typed it into the subject box in the data connection. Instead, click the fx button to open the formula editor and enter your formula there. :)
-
Oooooh, I love stuff like this. :) Can I get a copy of your form? Feel free to email to me if you can't attach to the forum. I'll take a look (but it may be tomorrow before I can get to it).
-
Here's a sample. Save the linked file locally, right click the saved file and select design to open in design mode. Then you can preview. My button has two rules - the second rule is where you'd put the submit action, I just have a close form action. Take a look and let me know if you have questions.
-
Is this rich text? or plain text? I'm curious why the character limit isn't providing the desired outcome.... validation rules can use regular expressions, so there may be a way to do it with validation.
-
So - is this form based on a database? That is - is the email field in the main data source or a secondary data source? From your screenshots, it looks like the main data source. :) It sounds from the error message like your formula is not always returning a value. You can put (temporarily) a calculated value on your form where you use the same ...
-
Good morning,
I am trying to add a concatenate (eg: concat("Bonjour ", field2, " - ", field4) ) function in an InfoPath data connection into the subject.
The thing is when I submit the form and received it by email, it does not give me the content in field 2 and 4 but it write literally field 2 and ...
-
Okay - if admin deploy isn't possible, I guess the next thing I'd do is test the template without qRules - I can remove qRules from a copy of the form, you can publish it to a new test library, and then you can see if the issue is reproduced in the form when it doesn't have code (and thus is not in the sandbox).
-
Unfortunately, my company doesn't allow publishing as an admin approved form. I will look into this as a long-term solution.