-
This one is close - save the file locally and then right click and select Design to open in design mode so you can look at the default value for the time spent coaching.
I used the formula from the BrainTrove post - the thing is, in that formula you have to have Time fields and your fields are all date / time. So, I added an additional ...
-
Hello helpme,
Thank you for your post. As far as an easier way to map repeating data to multiple SharePoint lists, there is a much easier way. What version of SharePoint/InfoPath are you currently using? The method uses qRules to set up a connection to each of your lists. In order for qRules to work, you will need sandboxing enabled on your ...
-
The data from both Table A and Table B are from SharePoint lists.
-
Hello Hilary,
Thank you for your prompt response.
In the meantime I have tried two other function but getting NaN on one and on another it shows false.
both formula on below page.
http://www.formsonfire.com/infopath/calculating-time-differences-in-infopath-without-custom-code/
Thank you for letting me know as how we can ...
-
Hello Sproctor722,
Thank you for your question. In regards to a resolution you have several options.
1. You could use a filter on the repeating row in Table A that uses the "If All occurance of 'AccountNumber" from table B != AccontNumber TableA then hide.
2. You could perform a filtered query in order to only ...
-
I have a repeating table that I want to conditionally display rows
based on the results from another repeating table. For Instance in the
repeating table to be displayed I have Account Number and Sales Plant.
Based on the restricting repeating table the repeating table to be displayed should only show the two records marked ...
-
Oh, I should have been more clear - it could very well be a server configuration issue - but I have, in the past, used SharePoint web services in InfoPath with servers using claims. So, there is a way to do it - I'm just not sure what server configuration changes you may need to make.
-
Can you attach a copy of your form under the Options tab in a reply? I'll take a look at your formula.
-
I have access to the servers. I checked SharePoint logs, but didn't see any obvious error, everything looks Medium when this happens. IIS logs have lots of HTTP status codes, like 200, 207, 401, 405, 414 for the site and the web service I'm using. Can't tell which one is relevant. I know 401 is access denied, but it's there for ...
-
Hello Hilary,
Thank you for your prompt response.
I have tried the function given on
http://www.braintrove.com/id/95
and below is the formula i created as given.
translate(addSeconds(@Coaching_Out_Time, -1 * (substring(@Coaching_In_Time, 1, 2) * 3600 + substring(@Coaching_In_Time, 4, 2) * 60 + substring(@Coaching_In_Time, 7, ...