EditForm to create a new record

[MichaelYe]

Hello, 

I am building an app and I wanted to add a feature where a user can edit the a field in a form and then submit it as a new record to an excel spreadsheet. However when I try to implement it I can editing the same record, I want the changes value to be recorded in a new record.
So basically,  Can I have a form that gets the data like an EditForm and then posts it as a new record like a NewForm ? 

Thanks in advance! 

[jlindstrom · Accepted solution]

no, you need to use NewForm. if you want to pass existing values, you can set the default property of the fields. For example, if you get there from selecting a record in a gallery, you could set the default value to gallery1.selected.field.Value and set the default of the form fields to that value.

[JR-BejeweledOne]

I see someone already gave you the correct answer.   I wanted to point you to some very helpful videos on the topic of forms.   If you decide to watch these start with #1 and go in order.

1. https://youtu.be/yT4gGVunU0o
2. https://youtu.be/BnzaSDYl8mA
3. https://youtu.be/if_mFIfi5PM   (This is an optional if you want to try something a little different)

Good Luck

[MichaelYe]

Works great! Thanks  a lot!