-
I'm displaying it in a text box. The format is currency and 2 decimals.
-
Hi there,
I have created and successfully published my form to SharePoint 2016 it's all working fine. However; when you hit the submit button it goes off into the shared mailbox twice (this happens most of the time but not every time) although the form is only submitting once into the form library. Any idea why this is happening and how I ...
-
Hi Hilary,
I managed to get it work now! Yay!
However, I've published the form to a SharePoint. How do I make people without InfoPath to submit the form in SharePoint?
-
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 ...
-
Hi Hilary. Thanks for replying. I attached a copy of the form to the post. Please check the rules set for the Location field, the second one is the rule for counting records in the list. I created a seconday connection VCMainV2-Read for this purpose which is pointing to the same SP list (main) due to when I tried count(Key [. = Key]) didn´t work, ...
-
Wonderful! Is the data type of the field decimal? Are you displaying the data in a text box or in a calculated value?
-
I just need to display it that way in the form.
So I guess if there's another route I can take, I'll take it.
-
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 ...
-
I found a solution to grabbing the data, based on what Hilary mentioned in her last post. It involves creating helper fields in the repeating table of the secondary data source.
In the repeating table of the secondary data source create duplicate fields for all of the columns of your data and call them M[FieldName] or whatever makes the most ...