-
Check field23 and MunichLastNotes - I saw they both had default values and added a filter to both defaults to exclude items where MunichStatus is blank. Where were you trying to add a filter?
-
You are so wonderful! Thank you again for all the assistance you provide!
-
I have attached the file. I tried the filter several times, but tells me I am not allowed to. There are two views on this form- Associate submits on Default view and then sees last submission on current view. Any hints you could give me would be greatly appreciated!
-
I think so - I think you can use a substring-after function: eval(eval(Person, 'concat(substring-after(pc:AccountId, "membership|"), ";")'), "..")
-
Sure, you should be able to add a filter in the rule that is setting the value - where you picked the field for the value, there should be a filter data button - you can add a filter so that the field can't be blank - attach your form if you'd like me to give you a hand (you can attach a file under the "Options" tab in a reply).
-
Oops, yes, I do see that this appears to fix the issue. Thanks for that!
Is there a simple way now to remove all the garbage from the result, so I can then using that result for an email form submit?
-
That worked perfectly. One last thing I am working out with it- If there is a field that is submitted blank- is there a way to pull the last non-blank data? So if one time an associate puts in Red for our Germany office, but another associate leaves that area blank on their submission. can I pick up the value from the non blank one?
-
Your formula is still wrong. You are not using a relative path to the AccountId node - that is why you don't get three different results. What happened if you just use "pc:AccountID" like I suggested? "eval(eval(Person, 'concat(pc:AccountId, ";")'), "..")"
-
Hi Hillary,
I got this KIND of working, but now with strange results. Here is the formula again, and the results.
People Picker Selection - "Darcy Wilson; Kevin Lambert; Peter Scott"
Formula - "eval(eval(Person, 'concat(../../my:group/pc:Person/pc:AccountId, ...
-
When you set up the data connection, you should have an option for sorting (on the dialog where you select columns). I'd sort by Modified, descending - had you already tried that?