-
Hi Ambarrionuevo,
Are you using a default value for the calculation? If you, you can try using this formula:
substring("FailOK", 1 + 4 * not(../my:field1 = "0"), 4 * not(../my:field1 = ""))
You could also use a rule to set the value. On field1, under the Home tab, click Manage Rules, add an Action Rule ...
-
Hi Greg,
The Julian Day formula i found had a longer length, adding all these C+D+E+F-1524.5. Anyway, this is a good formula. Thank you for posting this.
-
Hi Tom,
There is a way switch pages in InfoPath and show a restriction page on form load depnding on the current user. If you are using the Active DIrectory's User Profile Service, you can use this a leverage to determine which group the current user belongs to, specifically the department. If not, then you might need to create a separate ...
-
Hi Greg,
I was attempting to find a Julian Day formula so I could create one for you, but I wanted to verify first if this would be the correct formula:
A = Y/100
B = A/4
C = 2-A+B
E = 365.25x(Y+4716)
F = 30.6001x(M+1)
JD= C+D+E+F-1524.5
Thanks,
-
Hi Sabarimd,
I have encoutered this issue yet, but would you mind trying out this solution from Microsoft InfoPath Bloggers: "Updating the content type failed" while publishing the InfoPath form
Hope this helps resolve the issue.
-
Hi Dhijit,
May I know which type control are you using for the Multiple Selection List box? After I tested adding one and change the control type, I was able to add a validation rule to the field. If this doesn;t work for you, could you send me a sample of your form so I would have a better idea of what isn;t working for you ?
Thank you,
-
Hi Dhijit,
One way of displaying a is using a Validation Rule. You may add a dialog box to show a pop up message. Or you could also use a button with hide/show logic to display any message desired. I am attaching a sample form for reference (download form > right click > open in design mode).
Hope this helps.
-
Hello,
You may want to check out qRules' SubmitToSharePointList command if you wish to avoid writing code, otherwise you'll need to use a bit of code to perform this action. There are several ways to submit data to a SharePoint list and I am most familiar with CAML. Here's a short blog you could read: Add SharePoint List ...
-
Hello,
This is a known issue with Outlook and I have not seen any solution for it yet. One workaround you can do is use an HTML email in a SharePoint workflow to adjust how the data is displayed in the email. Here's the link to our webiinar: InfoPath: Workflows that email repeating data as HTML - October 3, 2013 Webinar
Hope this ...
-
Hello,
This would require a bit of work, and I was thinking of using a repeating table for the amount of hours per week. Luckily I was able to find a great example which calculates Elapse time. Please check this blog from Microsoft: Calculating Elapsed Time…without code!
Hope this helps.