-
Hello,
Thanks for the clarifications. At the repeating table, add a rule which sets the target field to the value:
preceding-sibling::my:group2/my:field1
Where field 1 is that target field and also the target value.
See attached form for reference (download xsn > right click > open in design). Check the rules on the repeating table and ...
-
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 ...
-
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 ...
-
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 ...
-
Hi kgood,
This is doable, but I'd like to find out how fields are populated? will you be using a dropdown control as basis for the values? if so then you can easily add a data connection to a list or library, set the dropdown control to filter and query the data selected, and set values on the desired fields after querying.
I hope this makes ...
-
Hi Mike,
Are you looking for something like this? (see form attached - download, right click form, open in design mode, preview form, and enter values in the repeating table). If so, then you can use a formula similar to this (for each parameter):
count(my:group1/my:group2[my:field1 = "Transmission"])
Where group2 is the ...
-
Hi bgplayer,
Have you checked out allowing management of content types? This should allow you to publish different XSNs (as many as you want) in a single SharePoint library. Hope this helps.
Regards,