-
So I am searching for an InfoPath 2010 formula for Julian Day. That is to say the resulting value for January 1, 2015 would look something like this "001"
I am new to InfoPath and would appreciate a formula that is Copy and Paste ready.
I have created a TXT box named "Julian" in which I plan to paste the formula ...
-
I have an Excel list with about 2,500 items. I need to take that list and submit those items to a SharePoint list. Currently, I have a REST connection set up to the Excel file. It appears to crap out if I go above 500 items (using a Range specified in connection). I'm trying to push 500 items at a time to SharePoint list (upon submit). Can ...
-
Perfect! Perfect! Perfect! Thank you so much!
-
Thanks Hilary... I'll try and let you know.
-
I'm confused as to why you are using a double eval in your formula. It appears the fields in your concat statement in the double eval are not in your repeating group?
At any rate, here's a sample that has a calculated value that should always return two decimals that may help you with this. Save it locally, right click and select ...
-
-
Hello world! I am stuck on a item that I know I have down using SharePoint workflows. I would like to add a link to a list item in the email function of InfoPath 2010. Can anyone help me?
Thanks in advance.
-
I'll see if I can clarify what I was trying to say. Your number is being stored as a number - but when you are formatting the "Amount" field on the form, it is set to include the decimal. That formatting is something separate from the actual value. The formula you are using is only going to return the actual value. So if it were ...
-
In a nutshell, I'm trying to get 23.0007/07/15.
Thanks,
-
Hi Hilary,
Thanks for replying.
I've created two separate fields; one for date and the other for the sum of all 'Amount' fields in the repeatable table formatting to include the decimals. The concat works fine, but only works when there is actual cents involved, e.g. 23.52; but when there are not cents, e.g. 23.00, it drops ...