InfoPath Dev

"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 ...

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 ...

It is publishing to a library and I have everything set to promoted at the moment for potential workflow use

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"?

It is soooo odd. So Here is the full scenario. I have a client who has a financial tracker (don't ask why in SP - it is what it is) They have a crazy amount of lists historically that are all morphed into one that is literally 80 to 90% lookups. What I am trying to accomplish in a smart way is to streamline the lists to a few and ...

This is a normal form created from a blank form template

Hilary So I used this as my guide: https://www.premierpointsolutions.com/training/help-and-how-to-articles/get-infopath-to-display-lookup-column-value-not-id/ It works fine on the form, but that field on the LIST shows as the ID still and does not hold the calculated value name (IE Customer POC - Chris) would be ID 1 on the main list ...

Hey all, I'm trying to do some math in my form that allows me to calculate money. I'm actually calculating PayPal's fees. It's 2.99% per charge, plus $.30. I do that like this: sum(MealTotal) * 2.99 / 100 + .30 So for $21.00, it calculates to 21.9279 I need that to turn into $21.90. So I tried ...