Filling out infopath form from excel rows? RRS feed

  • Question

  • Hi all, I'm in a bit of a sticky situation.

    I have an issue with filing out a form. Right now, the data arrives in a single master excel document that is updated weekly. Then values in it are checked, modified manually, and moved to a second excel document (a completed one). What I would like, is the ability to click on the master excel document, (for instance, click on row 1, which contains employee 0111) and have the info form automatically populate with the fields available in the excel document. Then the user finishes the form, and clicks submit. This then updates the second file, and removes the value from the master excel document. Any advice would be appreciated.

    Right now, I have finished making the form, and the second file, so you can manually enter all the values in the form, (The employee 0111 for example) and put that information in the second list. But I would like to be able to automate the first part. Thanks!

    Wednesday, June 21, 2017 5:38 PM

All replies