Qdabra qRules

Re: No SharePoint List Submissions

LNicholson2402 — Tue, 04 Nov 2014 16:24:55 GMT

Hi Hilary

That yould be really great I am under pressure for tomorrow my time and don't mind having the session with someone this evening / today you time.

Regards

Lee

Re: No SharePoint List Submissions

Hilary Stoupa — Tue, 04 Nov 2014 15:27:52 GMT

I've sent you an email via the forum - we can get something scheduled. :)

Re: No SharePoint List Submissions

LNicholson2402 — Tue, 04 Nov 2014 14:14:17 GMT

Hi Hilary

We have gone ahead and purchased the software. I managed to get the form to update the task however I could not get the task to update the form.

Could we please maybe have a small season regarding this as I think I have now broken something.

This also happened after I redid the update to my fully licensed version.

Thanks and Regards

Lee

Re: No SharePoint List Submissions

LNicholson2402 — Tue, 28 Oct 2014 08:30:50 GMT

Hi Hilary

Thanks very much for all you assistance I know have the updates working. I do have a question but I think I can get it to work.

If the Task item is updated I want it to update the forms repeating table. This I suppose can be done with rules on form load.

Thanks and Regards

Lee

Re: No SharePoint List Submissions

Hilary Stoupa — Fri, 24 Oct 2014 14:06:27 GMT

To update an item you need to make sure your SharePoint ID field in the form is getting set the correct ID for an existing item.

Re: No SharePoint List Submissions

LNicholson2402 — Fri, 24 Oct 2014 07:51:14 GMT

Thanks you for your assistance it is creating the tasks from the repeating tables..

The next thing that I need to add is that each item must be updated and not created from scratch each time it is submitted.

I am going to give this a shot and will let you know the outcome.

Once this has been tested and working we will purchase the software.

Re: No SharePoint List Submissions

Hilary Stoupa — Thu, 23 Oct 2014 22:22:03 GMT

So - save the attached form locally, right click and select design to open.

I modified the default value for you - I have a different formula that I like better.

Your mapping was odd - the repeating group was wrong. I manually modified it and updated it in the form. Maybe give this one a try and see how it works.

Re: No SharePoint List Submissions

LNicholson2402 — Thu, 23 Oct 2014 15:23:34 GMT

Thanks for your assistance.

Re: No SharePoint List Submissions

Hilary Stoupa — Thu, 23 Oct 2014 15:14:19 GMT

Sure, can you attach your latest template? It will be later today when I get a chance to review it.

Re: No SharePoint List Submissions

LNicholson2402 — Thu, 23 Oct 2014 15:07:25 GMT

Hi Hilary

Thanks very much for all your assistance. I have made the relevant changes and seem to still have the same error.

Could please assist as I think I may have missed something in the way I have done it.

Thanks and Regards

Lee

Re: No SharePoint List Submissions

Hilary Stoupa — Thu, 23 Oct 2014 14:32:32 GMT

Check this post:
http://www.infopathdev.com/blogs/hilary/archive/2013/01/17/qrules-submittosharepointlist-and-a-person-or-group-column-type.aspx

and this post:
http://www.infopathdev.com/forums/p/15290/86156.aspx#86156

If we are submitting to a person or group column (which is what Assigned To is in the task list) a special syntax is required.

I'd add another field to the form with a default value that uses a double eval statement to concat the account IDs in the people picker and then map that field - let me know if you need a hand with that and I can implement it in your form.

Re: No SharePoint List Submissions

LNicholson2402 — Thu, 23 Oct 2014 14:25:15 GMT

Hi Hilary

I have made the submit changes, I have also updated the Assigned to mapping to refer to the display name and not the group.

In the error bar I am getting the following error.

The operation failed because an unexpected error occurred. (Result Code: 0x80020005) .

Question I have also included information that is not part of the repeating table in the mappings. Could this be a problem.

Also I am sending the data to a Task list and not a custom list.

Thanks and Regards

Lee

Re: No SharePoint List Submissions

Hilary Stoupa — Thu, 23 Oct 2014 14:11:35 GMT

Okay - so when I type GenerateGuid in the command field and tab out, there is a GUID in your result field. That means qRules is working correctly in your form.

In your SubmitToSharePointList command, remove the /mapping parameter, you don't need it.

SubmitToSharePointList /submit=ShPListSubmit

If you put the Qdabra Rules error node on your form and click the button that executes the command, do you get an error? I think you are going to need to make some changes to submit your people picker data to your list, it appears right now you have the group mapped to Assigned To?

Re: No SharePoint List Submissions

LNicholson2402 — Thu, 23 Oct 2014 13:55:24 GMT

Hi Hilary

I have uploaded the file as requested. I added the fields but them both come up blank. I checked and they are not disabled as far as I can tell.

Regards

Lee

Re: No SharePoint List Submissions

Hilary Stoupa — Thu, 23 Oct 2014 13:32:52 GMT

Hi - I'd be happy to take a look at your template if you want to post in a reply (just add it under the Options tab). Sometimes people disable qRules by accidentally adding code to a template - could that have happened here? If you put the command node and result node from the QdabraRules data source on your form, preview, type:

GenerateGuid

In the command node and tab out, do you get a GUID in the result node? That's a good way to test that qRules is working correctly in your form.