InfoPath Dev

now() returns the datetime in ISO format: 2019-03-05T09:49:00 for example. You can put a calculated value on your form and set it to now() to see this. Looks like the substring you mention would return the month.

(substring(now(), 6, 2) the 6 is a start digit and the 2 is the length to be considered as a return value for the function. what is the complete format for now() function which we get some parts from it by applying (substring(now(), 6, 2) to it?

 Hi All, In Infopath 2013 I have to calculate a date from a date picker (Primarytermexpirationdate) and a text box (Nextreview). The result goes to another text box (testdatesplit) and contains the day and month from the date picker, and the year from the text field. I did this with the formula ...

And you still have too much data? How many matches do you have on your unique id? You are using a query field in your list data connection?

Hi Hilary, it pulls the data once a Unique Id has been entered (a staff number) then it searches a master list and pulls the data from there. It doesn't pull up all data on form load.

If you are searching on a unique field - is it an equivalence filter? Can you change the data connection to not run on load, then add form load rules, set the query field to the correct unique value and execute the query (or do that at the time the unique value is known, if not on form load?)

I finally got what I wanted to work. Here is what I done incase anyone else is wanting to do this: Create a data connection through the wizard choose the field you want to capture the data from and make sure to check “include data for the active form only” then click next and finish. I created a text field and made it read only Then on the ...

Hi all, I was wondering if there is a way to filter data before it reaches the form as the size of data is causing the form to crash and has become unusable. We are searching by a unique field where it pulls in 10 fields worth of data to autofill the form. We are using Sharepoint Online and i've seen in various places the data connection ...

Looks like you have it set up right - the submit connection uses your new fields. You have the fields on the form, so if you want the user to enter the cc / bcc, they can. Under submit options, you can also change the submit to use rules - then you can add rules to set the subject, set other fields, and finally email.

 Thanks. Please take a look at the new version of this form. I don't know what rules to set.