-
I'll see if I can clarify what I was trying to say. Your number is being stored as a number - but when you are formatting the "Amount" field on the form, it is set to include the decimal. That formatting is something separate from the actual value. The formula you are using is only going to return the actual value. So if it were ...
-
Do you need this in a field? Or could you just use two calculated values on the form, one next to the other? Then you could format one field as a decimal (including keeping the two zeros) and other as a date....
-
SharePoint list forms cannot have code in them, which means qRules cannot be used in list forms.
You could use an InfoPath form that is not a list form w/ qRules to manage your list by leveraging the SubmitToSharePointList command.
-
No - the command won't run automatically. You could add a rule to the Qdabra Rules finishedLoading node and if that node = true, you could execute your SaveToSharePoint command - that would have the same general effect.
-
Thanks - it is odd to me that you are getting an error about checking for existing - that should only be happening if the overwrite param is included. It is even odder that you get the error and other users don't. I'd like to take a look at your form - could you either attach it under the Options tab here in a reply or email it to ...
-
What is the command you are using? The full syntax (I realize you are using SaveToSharePoint, but want to know what parameters you are using).
-
Is this form being used in the browser or the filler?
-
Wow - just found the mega thread on this: http://www.infopathdev.com/forums/t/26246.aspx?PageIndex=1
-
What is the secondary submit connection on the form that you are talking about? Yes, this is possible without code or qRules - you'll need to use CAML to submit your parent list items and to submit your child list items, but the technique should be the same. There is a pretty good thread here on using CAML for list submits, but I ...
-
See the attached sample - I put the rules on a button instead of on form load, but they could be put on form load. Save the sample locally, right click and select design, then preview. Modify the value in field1 to test variations.