Retain some form data after submitting.

Like (0) Share

Report

Posted on 25 Nov 2019 11:55:05 by StuartSmith

213

I have a form to record visitor details and after submitting the form I want most fields to clear, but the "Host" and "Visiting Site" fields to retain their values as this info will always be the same for the session and dont want to have to keep retyping the "Host" and "Visiting Site" details.

The only time the "Host" and "Visiting Site" fields should be cleared is when the "Restart" button is selected. How can i clear most fields, but keep "Host" & "Visiting Site" populated when the form is submitted?

Thanks in advance,

Categories:

General Questions

pa frm.png

I have the same question (0)

All responses (14)

Answers (1)

tbrewer 7 on 25 Mar 2022 at 15:25:00

Like (0)

Report

Re: Retain some form data after submitting.

Hello @mdevaney ,

Your solution above works wonderfully. I am having trouble getting a combo box to retain the last submit form info. Any tricks to that specific input type?

Was this reply helpful? Yes No
NatM 2 on 30 Jun 2020 at 15:53:53

Like (0)

Report

Re: Retain some form data after submitting.

If someone is still looking for a solution on this...
Just add the following (with brackets and everything) to the defaultselecteditems property. I was adding only to the default property, but since the field is a combobox it needs to go to the latter instead.
That should solve your problem.

[Parent.Default]

Was this reply helpful? Yes No
mdevaney 29,987 Moderator on 02 Dec 2019 at 13:42:15

Like (0)

Report

Re: Retain some form data after submitting.

@StuartSmith
I am becoming a little bit confused here. It might be time to start a new topic and rexplain the problem now that you've solved the 1st one. Sorry.

Was this reply helpful? Yes No
StuartSmith 213 on 02 Dec 2019 at 09:43:15

Like (0)

Report

Re: Retain some form data after submitting.

Hi, do you know why its adding the last submitted entry for "Host", but not "Visiting Site"? The "Visiting Site" sharepoint list type is "Choice", if that makes a difference?

Was this reply helpful? Yes No
StuartSmith 213 on 28 Nov 2019 at 15:32:42

Like (0)

Report

Re: Retain some form data after submitting.

I have also been trying to follow your example and display the CurrentVisitngSite value in a lablel, but current trying to figure out the code.

Was this reply helpful? Yes No
StuartSmith 213 on 28 Nov 2019 at 15:27:10

Like (0)

Report
Re: Retain some form data after submitting.

Hi, I managed to get the "Host" one working, i simply removed/re-entered your code. But oddly the"Visiting Site" combo box doesnt display the current value? see attached.

The code I am using is...
Set(CurrentVisitingSite,Visitor_Registration_Form.LastSubmit.Visiting_x0020_Site); or
Set(CurrentVisitingSite,Visitor_Registration_Form.LastSubmit.VisitingSite); (this is how the sharepoint list column is named)

I also removed the line
NewForm(Visitor_Registration_Form);
as this was preventing the form data from showing in the gallery.

I have also been trying to set the "DisplayMode" of the host field to "view", using the code

"If(IsBlank(CurrentHost), DataCardValue14_1.DisplayMode.View, DataCardValue14_1.DisplayMode.Edit);"

But also cant get that to work.
Thanks in advance,

Host Yes Visiting...

Was this reply helpful? Yes No
mdevaney 29,987 Moderator on 27 Nov 2019 at 16:15:46

Like (0)

Report
Re: Retain some form data after submitting.

@StuartSmith
"Thanks for taking the time to supply an alternative solution. I done as you suggested and the code was accepted (no red crosses), but upon pressing the "Submit" button, the details are not submitting it to the sharepoint list and the gallery on the form, they just stay showing on the form. Any ideas?"

I want to know why the form is not submitting. Please create a label with this code in it. Does any error appear in this label after you click submit?
Form1.Error

Was this reply helpful? Yes No
StuartSmith 213 on 27 Nov 2019 at 15:48:16

Like (0)

Report

Re: Retain some form data after submitting.

So ultimately, what I want to achieve is that no matter how many rows are added for the current session, the "Host" and "VisitingSite" details will always be the same as row 1.

Was this reply helpful? Yes No
StuartSmith 213 on 27 Nov 2019 at 15:21:52

Like (0)

Report

Re: Retain some form data after submitting.

Another option, would be to disable the "Host" and "VisitingSite" combo boxes if 1 record has already been submitted and then pre-populate the "Host" and "VisitingSite" values of any additional rows with the "Host" & "VisitingSite" values found in the first row? Don't know if that would be easier? Hope that makes sense.

Was this reply helpful? Yes No
StuartSmith 213 on 27 Nov 2019 at 15:16:57

Like (1)

Report

Re: Retain some form data after submitting.

Thanks for taking the time to supply an alternative solution. I done as you suggested and the code was accepted (no red crosses), but upon pressing the "Submit" button, the details are not submitting it to the sharepoint list and the gallery on the form, they just stay showing on the form.

Any ideas?

Was this reply helpful? Yes No