-
I have a formula in the data for today's date. There is a drop down for 'colony' but the 'recorder' and 'observer' are not drop down. I do not want it to be a standard default, for example if I am working in the SS colony today and the WH colony tomorrow, I don't want to have to change the default everyday. I would ...
-
Hi hpmiller,
If the set value logic without filter is working, then the issue here is definitely on the filter you have been adding. Theoretically, your filter should look similar to this: field[2ndDataSourceValue = DropDownValue]. Could you also check the dropdown field's value? it may show a displayed value but the actual value is ...
-
Hi Blake,
I'm not sure how your form is set up so I am unable to provide with a formula (not sure if you are concatenating multiple fields or fields from a repeating table). If you are using multiple fields, I would suggest using a substring logic which only returns data if the field is not blank (field1 != ''). For repeating data, ...
-
Hello,
I'm glad to hear you were able to resolved the issue on your own. And yes you are correct, calculated fields cannot be promoted. A workaround you can do is turn the fields into text fields, right click on the field > select properties, and set them as read only. This way you will be able to promote the fields and prevent users ...
-
Hello Don, thanks for your great reply and YES this is exactly what I'm trying to do.
However, I just can get this to work on my form. Up-until you replying, I had found a way of doing this, just playing around with rules and filters etc, I really don't know how I managed it but somehow managed to change a filter condition to ...
-
Hi SRAEngineer,
If you are using a Library, I would suggest concatenating the fields within the InfoPath form and promote this field at the form options. You can also do the same if you are submitting data to a SharePoint list, or add a calculated column (calculation based on other columns in the list). ...
-
Hi Andy,
Thanks for the clarification. First you would need to have a data connection which queries the SharePoint list, and filter out the data based on the current user's ID. What we need here is to get the row ID in order to submit the data properly. Once you have the ID (for the specific row), you can use CAML (or other Submit to ...
-
I don't want to extract the name from the AD identity. I have the form populating the AD ID already with the GetUserProfileByName function. Once this gets pulled, I need Infopath to grab data from a SharePoint list from the row where the "UserID" column matches the name I got from AD.
Is that clear or do you need ...
-
Hi AndyMoon,
To extract the first name or last name, you will need to add filters for the values, such as:
Value[Name = "FirstName"]
Value[Name = "LastName"]
Please let me know if this helps. If not, kindly attach a sample of your form with an existing GetUserProfileByName data connection and I'll help ...
-
Sorry I missed this - Jim has answered your question where it was posted separately - http://www.infopathdev.com/forums/p/29519/101040.aspx#101040
Just wanted to update with the link in case anyone else needs to find it.