-
GetDOM is the secondary data connection. get-DOM() is the main connection. You may have been selecting the filter fields correctly, but accidentally selected the query field in the main DS instead of the data field - that's an error I've seen before. :-)
-
I'm a math dunce and didn't realize that you wanted the last decimal to round, and thought the issue was just related to displaying only two decimal points! I'll see if I can figure out a way to do this later today, I'm guessing we can use substring functions....
-
You'll need to add a repeating section or table to the form for those orders. Have you already designed this portion of the form?
-
Your instinct is right - you needed a secondary data connection to return all the records from the list so you could count them. Personally, I would probably set that data connection to NOT run when the form is opened, and instead, on the Key field, set the query field in the secondary data connection to the current key, then run the query. Then ...
-
Wonderful! Is the data type of the field decimal? Are you displaying the data in a text box or in a calculated value?
-
This is extremely difficult when you can't share your form or any screenshots. A calculated value is a control type. Are you now saying that the default value of the account manager field is Title[ID=AccountManager] and this is what you have promoted to the library? If so, there is no reason the library's promoted property would ...
-
So, my guess would be that in the form, you are setting your account manager field to the ID, and that's what promoted. And you are using a calculated field to display the name. But you'd need to actually add and promote a field in your form with a default value that will store the name, and promote that. You could use the same XPath ...
-
Any chance I can get you to attach a copy of your form under the Options tab in a reply?
-
Do you actually need to round this? Or can you just display as the nearest 100th in the form?
-
Oh! Are you talking about a promoted property? Is this actually a list form, or when you say "publishing to the list" do you mean "library"?