InfoPath Dev

Hi All, Let me try to describe my scenario the best I can . I have a holiday request form that send information to a SharePoint list called Holiday request. When a user open the form, it gets some data from another SharePoint list with the employee information like, name and the amount of days that the employee still have in holidays. Till there, everything works fine, but I wanted to edit the employee remaining days on the other SharePoint list. Anyone know if it is possible and how to do it? Thanks in advance.

Hello Andre,

This can be done in a few different ways. The first would be to promote those columns from the form in the SharePoint library, and make sure that you have a unique key in your SharePoint list. On submit, you can have a workflow to update the values where the unique keys match. Here is a webinar that details this method: https://www.youtube.com/watch?v=zJxP9M018hM&list=PL581899A129522F53, and the webinar kit can be purchased here: http://www.qdabra.com/webstore/p/103/

Another method would be to use qRules SubmitToSharePointList command. Here is a tutorial on how to use the command: http://www.infopathdev.com/blogs/hilary/archive/2012/06/27/qrules-submittosharepointlist-walkthrough-for-v4-2-working-with-existing-data-amp-submitting-a-single-mapping.aspx

Hope that helps!
Bre

I am using 365, it is possible to use qdabra on it?

Hi - qRules is compatible with Office 365, yes. It has a free trial, so you can always test it out - the current trial expires soon (3/15) but we should have a 7.1 trial up soon, or you can email support AT Qdabra DOT com if you need more time with the trial and I'll make sure we get you one with a later expiration date. :)

Thanks for your reply. I will have a look.