Qdabra qRules

Re: SubmitToSharePointList doesn't pull ID upon first submission

Deeayrian — Mon, 10 Sep 2012 21:01:03 GMT

Yes! You are correct. I thought I had to do that because I needed to pull an automatically incrementing generated number from the form when it submitted to the library, but apparently the number is created before it is actually submitted, so switching the order of the submits worked! Thanks so much!!

Re: SubmitToSharePointList doesn't pull ID upon first submission

Hilary Stoupa — Mon, 10 Sep 2012 18:33:14 GMT

I bet you are submitting to your SharePoint library before running the qRules command. You want the ID populated before you submit the XML to SharePoint. :-)

Re: SubmitToSharePointList doesn't pull ID upon first submission

Deeayrian — Mon, 10 Sep 2012 18:26:37 GMT

Interesting. I turned off the option to close the form upon submit, tried it again in preview mode and it worked! The list ID populated in the field. So what could be causing it not to populate when it is actually submitted? Could it be the submitting order? I published the form with the option to close the form upon submission turned off again and it did populate in the form view, but when I went to open the actual form that got submitted to the library, the List ID was not populated in the field.

Re: SubmitToSharePointList doesn't pull ID upon first submission

Hilary Stoupa — Mon, 10 Sep 2012 18:06:15 GMT

Could you temporarily change your submit options to not close the form on submit?

Re: SubmitToSharePointList doesn't pull ID upon first submission

Deeayrian — Mon, 10 Sep 2012 17:55:06 GMT

When I am in preview mode, fill out the form and submit it....it just closes the form and I don't see the List ID number populate in the field before it is closed. When I try to open the form in the library that was generated from a preview, I get the error message that the form is not fully trusted....which isn't true and it works fine with I actually publish it and submit it.

Re: SubmitToSharePointList doesn't pull ID upon first submission

Hilary Stoupa — Mon, 10 Sep 2012 16:52:41 GMT

Your form doesn't work in preview? What happens? Do you get an error message in the error node? I always test my forms in preview prior to publishing, and don't have problems with the command in preview.

Re: SubmitToSharePointList doesn't pull ID upon first submission

Deeayrian — Mon, 10 Sep 2012 16:38:12 GMT

It is happening in the browser. I am not sure I could get it to work in Preview since I am unable to actually submit it to a list in Preview mode....unless I am missing something?

Re: SubmitToSharePointList doesn't pull ID upon first submission

Hilary Stoupa — Mon, 10 Sep 2012 15:33:34 GMT

That's odd. Is this happening in the browser? Or Filler? If you try in preview (with the list id field displayed so you can see it) does it get populated?

SubmitToSharePointList doesn't pull ID upon first submission

Deeayrian — Mon, 10 Sep 2012 15:03:40 GMT

I have got everything working almost perfectly with the SubmitToSharePointList command in qRules and I love it. However, I have noticed the following is occuring. I submit the form and it creates the list items perfectly. But, it doesn't place the associated list ID number in the List ID field I created in the form. But if I open the same form and make a change to the data that gets submitted to the list, then it creates a 2nd list entry and this time it pulls the ID from the list into the List ID field on the form. After the 2nd submission to the list, it does not create duplicate list entries anymore because the list ID is associated to the form as it should be.

Is there something I can do to ensure the ID gets pulled into the form the first time it is submitted? I need to avoid any duplicate entries in the list.