-
Sure! You would need two rules, and each rule has a condition. For example:
If field1 = apples, set field2 = 1.
If field1 = oranges, set field2 = 2.
Does that make sense?
-
Hi Stacie,
DBXL needs to own the xml file. You can't have a submit to Sharepoint + a submit to DBXL. You'll need to submit to DBXL and let DBXL handle the Sharepoint mapping.
Based on your question on the Qdabra forum a few days ago we're investigating how to create this custom form name, but we don't have an answer quite ready ...
-
Hi Dave,
The problem is in the schema: there is still a mismatch.
In the source you have (Choice) as the repeating node, with LU_EducationLevel as a subgroup. In the destination you have LU_EducationLevel as the repeating node.
You'll want to modify the destination to have a repeating group, with a group under it, then your three nodes. ...
-
Right, substring will allow you to select a certain number of characters from a field.
Check out substring before and substring after if you have a specific character you need to look for. For example, for ernesto@qdabra you can do substring-before and get ernesto and substring after and get qdabra.
Good luck!
-
Yes, it's possible with concat and substring. See the attached sample.
-
Yes, the field names must match as well. To do this, right click on group1 and select Reference. Select a different location and InfoPath will replicate group1 in that location. See the attached screenshot for an example.
-
No problem. Thanks for clarifying the scenario.
Replace won't work because of the structure mis-match.
CopyTable won't work because these are not repeating structures.
Is it possible to re-do the data source so that the source and destination match?
-
Hi, and thanks for trying this new webpart. We are investigating these issues you've reported and we'll reply soon.
-
Hi Dave,
The command field gets cleared out after it executes.
From your description of the data structure it sounds like you are correct in trying Replace. The error message is telling us that the command cannot locate the source node. Though perhaps the real issue is that the data structures must match. From the mismatch above (source is ...
-
The file attachment is a base 64 string. Can you try a SQL data type of nvarchar(Max) and let us know if it worked? Thanks.