-
What version of qRules? What is your command syntax?
-
Do you mind telling me the command you are using?
EDIT: The specific syntax, that is... sorry, I understand from your post that use are using SubmitToSharePoint list. Are you clearing the attachment field on submit? Does the attachment field allow blanks?
-
Hey, Scott -
I'm all crazy about SharePoint and OData right now.
The url is:
http://yourserver/_vti_bin/ListData.svc
If you get an error, you may need to install ADO.NET data services update: http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=2343
If you are not familiar with the URI conventions, here's where ...
-
When do you need that info? Right before you submit? If so, maybe run your query then....make sure you are just returning the column you need (sounds like you just need the ID column). Any chance you are using SharePoint 2010? If so, you could use the OData provider to return just the current max ID, so that would definitely shorten the amount of ...
-
The user guide says:
xpath: xpath to delete. It can be filtered in the case of a repeating group or field.
So, the ability to use a filtered XPath is mentioned in the guide.
Is there a reason that you can't just exclude the row when the form opens by setting the default? Have you tried:
Delete ...
-
Many of the commands do not have additional documentation outside of the user guide.
Is group19 your repeating group? The [1] filter selects the first row of a repeating group. I'd assume that without it, Delete would also delete the first instance of the repeating group since the XPath to a repeating group without a filter generally selects ...
-
A lot depends on what else you have going on in your form. But if you look under Tools / Options / Defaults (IP 2007) or Data / Defaults (IP 2010) you have the option of not including your repeating group when the form opens. Then you will not have that initial blank row.
EDIT: I should add, if you want to use the delete command, that works too. ...
-
Okay, I don't know what an Exposure database is - is it a SQL DB? Or some other server product? If it is SQL, you should be able (in general) be able to use InfoPath to make updates, yes.
-
What other rules are on this submit button? How does it differ between the other submit buttons? What qRules command are you running?
-
This may be a great use of a secondary data source that is an XML file - create your XML file with the fields you need, then you can drag those onto your form.
Another option may be an expression box (calculated value in IP 2010) - set it to the text you desire, conditionally format it for hide / display logic as needed...