-
-
-
Thanks so much that did just what I need it to do.
-
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 ...
-
SELECT FirstName + LastName AS fullname
FROM ContactI know that this is a SQL query I can run in Microsoft SQL Server Management Studio's SQL Pane, and it will return what I need. Although it returns with with alot of space between the 2.
I just need to know ...
-
No SQL, just InfoPath and SharePoint.
-
Well we have found a solution for the problem.
Well It was really weird. Here is what we have done:
1. Remove the problematic field from the promoted fields
2. Publish the form
3. Upload to the sharepoint
4. Add the problematic field again to promoted fields
5. Publish the form again
6. Upload to the sharepoint
it is working now ...
-
Right now, I'm using conditional formatting. I have no idea how to even access those "filter" options. I am loading my Sharepoint list into a repeating table and haven't been able to find any filter options yet. How would you suggest I proceed for building a bunch of filters? As you said, it will ...
-
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 ...