-
Typically in the learning / testing phase I would either make a new form and replicate this or create another view in your copy of the original to do some testing.
First I would drag your secondary data connection onto the view so you can verify exactly what is being loaded.
The data connection should have the defualt to load automatically so ...
-
In the Data Connection setup there is a Transact SQL button in the lower right when selecting the table fields. You can enter this Select Statement there.
Then you can configure your drop down to use that Data Connection.
-
Once you drag your repeating group from SharePoint on to your form you probably have a repeating table. If you go into properties and the display tab you will find conditional formating and filtering.
You just have to start playing with logic to really get a handle on it. Using coloration I find is helpful for seeing the big picture and testing ...
-
It is not hard if you have the right to tools.
Are you using SQL to capture this data? SQL can automatically create your IDs.This is always best since they are created upon save and therefore you have no worry of duplication.
Qdabra Database Accelerator Suite Version 2.1 - Developer
To create it within your form is problematic, since ...
-
Are you using the filter or conditional formating?
You can sometimes combine these but yes the logic can get hairy to implement complex filters.
I often use conditional formating and use text coloration for testing my logic then I can see all the data and also what my logic is affecting. Then switch it to hide later after I know it is working ...
-
Here is an example on how to set up a filter.
http://www.infopathdev.com/search/SearchResults.aspx?q=populate&g=6
-
I believe this is default SharePoint functionality and I do not think you can get around this.
Two options I can think of.
Take the segmented list and break it up your self using the string-before function.
Or replicate it yourself. It is a static list in SharePoint so you could enterit statically in your form or create another SP list which is ...
-
Have you checked the format in the SharePoint view? Are they both strings? Have you tried a new Document Library for a test to see if it does the same thing?
-
You would have to use more complex logic and calculate the number of Saturdays and Sundays between your two dates and then subtract that from your total. I believe with DateDiff there is a way to get day of week so you could use this to filter the results which would be counted and step through (while loop) each following date and if it was ...
-
What exactly are you trying to accomplish? Describe what the form is attempting to do and I might have some ideas that could help your design.