-
Instead of running the query when the form opens, add rules to the park field in your form. When a park is selected, set the query field for Park in your secondary data connection to the value of the main data source Park field. The run the query. That should return just the data for the selected park. For additional information on ...
-
You should be able to use validation rules for this. You could have a condition like "Is this a single destination trip" = "Yes" and Depart From is blank, show the cannot be blank warning. I've attached a simple sample - save it locally and then right click and select design to open in design mode.
-
Are you setting all of the fields? I haven't tried this - but I know if you set just the account id when trying to populate a people picker with rules, it doesn't resolve to the person... but it may also be that since this is happening via workflow, the people picker isn't resolving when the form reopens. Maybe add a helper field ...
-
The list may be returning decimal values - which would explain the error. You may need to put the field on the form again, and set it to display the value as text so you can see what the actual value is.
-
Oh good old SharePoint - it is displaying the date as date only, but it includes the time. Drag your secondary data source that has the date from SharePoint in it onto your form and be sure the date field is set to show the XML value, then preview. Then you'll be able to see the actual data and use a substring formula to get back just ...
-
-
The new data connection you added will have query fields and data fields. Add a rule to set the query field for ID in the new data connection to the ID field in your main data source. Then add a rule to run the query.
-
I am confused with step 4. how do you do this?
-
I have a calculated date field that adds 14 days to the created date. I then want to auto-populate this calculated date into a date picker on my InfoPath 2013 form...
When I view the calculated date field in the SP list - it shows in this format; 10/7/2015 (which is correct)
but when it tries to auto-populate into the date picker it shows in ...
-
wow ok thanks so much I will see if I understand and try this. Thanks sooo much