-
Ah-ha! So you have the right idea - you just need an XPath filter on the "IP" field part of your formula. In your form load rules, you tried to do this with a condition, but that won't evaluate on a per row basis. Instead, you need a filter on the eval formula itself: substring-after(eval(eval(IP[Host_Name != ""], ...
-
Hello,
Thank you so much for getting back to me so quickly. I have attached my form to this message. When I use the formula substring-after(eval(eval(IP, 'substring-after(concat(. = "", ",", .), "false")'), ".."), ",") it will populate all the IP #s and all I want to post is the the IP ...
-
Yes - you will need to use what is called a double eval formula to show all of them. If you search the forum for double eval, you should find some info, or if you attach your form under the options tab in a reply, I can help you with the formula. Here's a link that explains the concept: ...
-
I have a repeating table within my InfoPath form, I have it setup so this table when it loads auto numbers my tables rows 1-254 (for my IP Address ranges) with in this table and row there are other fields such as the field Host Name. Outside my repeating table I have a text field called HostInUse. Here is what I want to happen, when the form ...
-
My guess would be that you need to re-run the calculation logic when the end date changes and that something isn't being re-run correctly. What happens if you change the start date after changing the end date? Does your calc then work correctly?
-
You can do that with a filter - when you select the CourseName field you can click to add a filter, and then select Start Date/Time is equal to or greater than, then in the third dropdown, select the option to use a formula. You can use the now() function to get the current date time.
-
I've actually run into this before - and was not able to find a work around. If I recall correctly, I tried modifying the URL params to see if I could force the form to open - in the end, we told the end users to copy / paste the links into the browser URL bar, which was not a good solution at all. What do your URLs look like? They have the ...
-
-
I have created a Course Registration form in InfoPath 2013 from a Calendar list in SharePoint 2016. On this form, I have two cascading drop downs, Course Name and Start Date/Time.
On the Course Name dropdown I would like to see only today's and future courses.
-
This was perfect! You are amazing. I am going to be working on some InfoPath projects in these coming months so please look out for me. Thank you so much.