InfoPath Dev

[quote user="Hilary Stoupa"]Use the addSeconds function - but I'd probably add that first, then use substring-after to get the time. See attached - save the file locally, right click & select Design. Formula is: addSeconds(now(), 43200)[/quote] is 43200 equivalent to 12 hrs? so for example the date now and time is Sept 7 11PM ...

If your field has a datatype of number, this will happen. Can I see your form?

 Thanks for the reply. I have applied the validation but as soon as I lose focus of that text field it reverts to 1 from 001. I think it might be something to do with SharePoint forcing the field to TextType?

In my work we must have multiple process owners that have to sign off on purchase requests. Some individuals like this in PDF format, while the main contingency would be willing to use InfoPath Forms. Is it possible to export out to PDF with digital signature blocks?

Hi, it is not a form in a list. It is a form created in InfoPath Designer and is generated a SharePoint contenttype and add a SharePoint formlibrary which is using this contenttype. Do you know what I mean? I dont know how they call this kind of SharePoint form.

Oh, I was using Chrome. :) I mean the text box properties on the InfoPath form - under the Display tab (right click the text box and select text box properties). I didn't realize you were using a SharePoint list form, however - it could be those behave differently.

Which textbox properties do you mean? From the SharePoint column or the InfoPath textbox? And could you please try it also in chrome? It looks like IE11 is ok, but chrome have this problem.

I just tried this - setting the properties of the textbox to multiple lines was all I needed to do to get it to work as anticipated. Feel free to attach a copy of your form if you'd like me to take a look or try it on my O365 site. You can attach a template under "Options" in a reply.

Use the addSeconds function - but I'd probably add that first, then use substring-after to get the time. See attached - save the file locally, right click & select Design. Formula is: addSeconds(now(), 43200)

So - are you running this on load? If so - change the data connection to not run on load. Then, for testing, put the query and data fields on the form, along with a button that executes the query. Also, put a calculated value on the form that shows the userName() function. Then you can test in the browser - I'd think that you'd want a form ...