I have a display form which is set up to show the last submitted data sent to a Sharepoint List.
However I also am using a variable on the submission button which retains the last submitted data in the fields (so that the user does not need to keep typing the same data in each time).
The issue I'm having is that once I submit a new entry to Sharepoint, and the data is sent to Sharepoint (as well as re-populated in the form), the display form won't display the previous record. This may be because I have a NewForm triggered in the OnSuccess property of the Edit form.
What I think may be happening is that the record is filled out, the user hits submit, the item is added to the Sharepoint list, the data just sent to SP is also re-populated in the input fields, Form1.LastSubmit is triggered on the display form, however because a new form is triggered by the Edit form, the display form is wiped so one can't see the last submitted record.
How do I ensure that the last submitted record is visible in the display form? My ultimate aim is a user can fill out a form, hit submit, and three things happen: a) the record they just submitted goes to Sharepoint list as a new item b) the same record displays in the display form to show the user what has been submitted c) the form "remembers" their last inputs which can be tweaked and submitted as a new item.
Any thoughts/suggestions welcome! Thanks.
