I have been requested to create a form that will be submitted to users at 4 am every Monday. When the user receives the form via email, they user will make updates to the form (removing employees that are no longer employed), select a submit button and the form will update a SharePoint List. Was advised not to make the changes to the database.
So far I have created the form using the database option, the data queries what I want it to. However, when I create the submit button and set rules to update the SharePoint List, the list is not updated and it is as though the data disappears (probably because list is not an option, but library is).
When I set the button to send an email, I do receive the email, but this email is supposed to be sent to the user after changes were made to the form (which happens), so they should be receiving a 'read only' form, but that is not the case. This email is not as important as first knowing if I can use an InfoPath form to update a SharePoint list.
Is it possible to update a SharePoint List with an InfoPath form querying data?