General

Re: field not populating in email submit

Hilary Stoupa — Tue, 18 Jun 2019 15:34:27 GMT

I used it for the default value for Journal Accounting Date? Sorry - I thought that was where you needed it?

Re: field not populating in email submit

TonyL — Tue, 18 Jun 2019 15:30:50 GMT

Sorry see it now, you use my field accounting date and change the formula. now it does show correctly in the email subject. Thanks you have be so very helpful!!!

Re: field not populating in email submit

Hilary Stoupa — Tue, 18 Jun 2019 15:23:22 GMT

Right, it has to have the month data connection - did you try the version of your form I posted to my last reply? It has the formula as a default and already has the data connection added.

Re: field not populating in email submit

TonyL — Tue, 18 Jun 2019 12:28:23 GMT

I put in this formula concat(Name[Number = substring(Journal Date, 6, 2)], " ", substring(Journal Date, 1, 4)) and when I try to verify it, I get this error. "xdXDocument:GetDOM("month")/Months/Month/Name/dfs:dataFields/my:SharePointListItem_RW/my:Date" does not point to a valid location path of a field or group.

Re: field not populating in email submit

Hilary Stoupa — Mon, 17 Jun 2019 17:00:15 GMT

Try this version.

Re: field not populating in email submit

TonyL — Mon, 17 Jun 2019 16:36:50 GMT

I have attached the form. Thanks.

Re: field not populating in email submit

Hilary Stoupa — Mon, 17 Jun 2019 16:23:36 GMT

In my form there is a secondary data connection to an XML file that has the Month names. If you look at the formula with the XPath showing, you'll see:

xdXDocument:GetDOM("month")/Months/Month/Name[../Number = substring(xdXDocument:get-DOM()/my:myFields/my:field1, 6, 2)]

Attach a copy of your form to a reply if you'd like help setting that up.

Re: field not populating in email submit

TonyL — Mon, 17 Jun 2019 16:02:26 GMT

so I substituted field 1 with Journal Date since that's the name of my field with where the date picker holds data. what do I use for Name[Number? what do the 6,2 and 1,4 represent in your formula? concat(Name[Number = substring(Journal Date, 6, 2)], " ", substring(Journal Date, 1, 4))

Re: field not populating in email submit

Hilary Stoupa — Mon, 17 Jun 2019 15:37:07 GMT

I'm using a substring formula to get back just the month from the date so that I can match that to the month number in my XML data source to return the name of the month. If I want to get the year from a date field, I can do that with a formula like this:

substring(field1, 1, 4)

So, if I wanted the Month name and the year, something like this works:

concat(Name[Number = substring(field1, 6, 2)], " ", substring(field1, 1, 4))

Re: field not populating in email submit

TonyL — Mon, 17 Jun 2019 13:39:32 GMT

Got the eval to work except that I want "&" instead of | | and I only need the & between the 2 not after

here is the formula I have so far without any date

concat("LEASE JE_", JobDescription, "_", RegionContractGroup, "_Portfolio(s):", eval(eval(Value[. != ""], 'concat(., " & ")'), ".."))

this is the output

LEASE JE_Monthly Journal Batch_EMEA\Equipment and Fleet_Portfolio(s):EMEA & EMEA FTPC &

Name[Number = substring(field1, 6, 2)]

having trouble with the above. I've got the "journal date" as the field name for where the date value lands when you chose a date with the picker and I have the calculated field "journal accounting date" to show the date as "MMMM YYYY"

how do I write your formula with those field names? right now your formula only shows MMMM, can I add YYY?. what do the 1,6,2 numbers represent in your formula?

Re: field not populating in email submit

Hilary Stoupa — Fri, 07 Jun 2019 17:02:16 GMT

See attached, save locally, right click and select Design, then you can preview

Re: field not populating in email submit

Hilary Stoupa — Thu, 06 Jun 2019 23:55:42 GMT

Ran out of time today on the month / year sample - I'll do that tomorrow, I promise. Were you able to try the double eval for your value field?

Re: field not populating in email submit

TonyL — Thu, 06 Jun 2019 17:16:59 GMT

ok, thanks and so very much appreciated!

Re: field not populating in email submit

Hilary Stoupa — Thu, 06 Jun 2019 17:12:05 GMT

You can use what is called a double eval formula to concatenate all of them with a divider. You can use substring formulas for the date - but you won't be able to get MMMM format, just the numbered month.... of course, that's easy enough to fix with a secondary data source that has the month names & numbers.... I'll put together a sample for you later today that demonstrates that. Here are some links: http://tinkerersjournal.blogspot.com/2013/01/codeless-double-eval.html for double eval, https://blogs.elon.edu/techgeeks/2013/08/15/infopath-extract-day-month-or-year-in-infopath-from-a-date-picker-field-or-today/ for date parts, though I would likely skip the number function on these.

Re: field not populating in email submit

TonyL — Thu, 06 Jun 2019 17:03:05 GMT

ok the filter worked, except that I just grabs the 1st choice if there are two or more they do not show. is that an easy fix?

for the accounting date . In the form I am using a date picker, but I need the date to show as MMMM YYYY, because the day of the month chosen isn't relevant and we don't want it shown on the list or the email subject. but that isn't a format that is available for share point lists which is why a created the calc field accounting date.