Qdabra qRules

Re: SubmitToSharePointList Question

Hilary Stoupa — Wed, 06 Feb 2013 20:46:03 GMT

I use those all the time - a lot of times, I'm working on forms that are in production. So, I like to preview my changes with existing XML - that way I can make sure I'm not creating any issues. Using Go To Next Error helps me find hidden validation errors. :)

Re: SubmitToSharePointList Question

camens — Wed, 06 Feb 2013 20:19:15 GMT

That is extremely useful actually, thank you!!

Re: SubmitToSharePointList Question

Hilary Stoupa — Wed, 06 Feb 2013 18:55:46 GMT

Use keyboard shortcuts to get the error info.

Navigate to next field that has an error.	CTRL+SHIFT+O
Get error details for current field if it contains an error.	CTRL+SHIFT+I

Re: SubmitToSharePointList Question

camens — Wed, 06 Feb 2013 18:30:20 GMT

I had it working, made a few changes to the form, now all I get is the error that the form has validation errors and cannot submit. I cannot find any validation errors...

Re: SubmitToSharePointList Question

ErnestoM — Tue, 05 Feb 2013 21:18:15 GMT

Hi,

We’ve seen that SharePoint returns the date/time data like this:

2013-02-08T08:00:00

However, in order to submit the date/time data back into SharePoint, this format is NOT accepted.

The accepted formatting is:

2013-02-08 08:00:00

This means that the T is replaced with a space.

We typically add a second field (where the T is replaced with a space) and map this second field into the list.

Hope this helps!

Re: SubmitToSharePointList Question

camens — Tue, 05 Feb 2013 20:23:53 GMT

OK, I reworked it and am now getting a different error that revolves around dates. I can save to the date field in either a Date Only format or a Date and Time format. But when I grab that default date from SharePoint and try to save it back to the list unchanged I get an invalid date error. You helped me solve a similar issue when saving dates to a calendar list using the Format Date command. Is that my only option?

Re: SubmitToSharePointList Question

Hilary Stoupa — Mon, 04 Feb 2013 16:27:13 GMT

Attach your form if you'd like me to take a quick look.

Re: SubmitToSharePointList Question

camens — Mon, 04 Feb 2013 15:24:25 GMT

Yes, I have added the List ID in the command .

Re: SubmitToSharePointList Question

Mel Clemente — Mon, 04 Feb 2013 11:44:21 GMT

Hi - you would need to specify the list ID in your mapping (if you haven't).

You can do that in two ways:

Specify the xpath to the list ID field in your command, e.g. Command = SubmitToSharePointList /mapping=mapping /id=/my:myFields/my:ListID
Check the ID box in the mapping tool - under the second column that says Options (Show) - see screenshot...

Hope it helps!

SubmitToSharePointList Question

camens — Mon, 04 Feb 2013 05:32:01 GMT

I am using SubmitToSharePointList to create new items, with about 8 fields in each item. However, I also need to be able to edit these items. So when the ID of the item to edit is entered, I am using the default value properties fields to bring in the list information. I then allow the user to update the information, and I'd like to use SubmitToSharePointList to resave. Unfortunately it just doesn't seem to work correctly. I am not getting any error, and the success box is checked, but it does not save the edited information. I don't know if the default value is somehow overriding the newly edited information? The command is exactly the same as the successful command which creates the information, except that I've added the ID. Any ideas?