You’re offline. This is a read only version of the page.
634
I have 4 forms (Form1, Form 2, and Form 3) on a single screen. The values in these first 3forms populate Form 4 which is then submitted when the 'Submit' button is clicked. Now, these forms are always in edit mode regardless of whether I am creating a new record or editing one. I'm using a variable called glbFormData for this. This is set to Defaults(datasource) for a new record or has the values of a record for editing. What I am attempting to do is to build a 'copy' functionality. This is similar to editing a record but instead populating the forms with the saved record and submitting the changes as edits I want to submit the form as a new record. I haven't figured out quite yet. I've tried setting a 'copy' variable and changing the mode of the form to 'new' but that just removes all values from the fields. It seems like there should be a way to do this relatively easy. Something like
If varCopy = true then submit the form data as a new record else SubmitForm.
Make sense?
Great. Then I am all set with my formula. Much appreciated!
Yep, figured that...just wanted to post the formula for others in case they were using SharePoint as in SharePoint, it is the ID that needs to be "blanked".
It isn't a Sharepoint list. I'm using Dataverse(CDS).
So this is not a SharePoint list then you are working with!?
Your global variable already holds the record ID, there is no need for another variable to hold it duplicated.
For a SharePoint list your formula should be the following:
Share
Report
All responses (
Answers (
Patch(glbFormData, Form1.Updates, Form2.Updates, Form3.Updates, If(varCopy, {ID:Blank()}, {}))Just a quick note to anyone else trying this. Make sure you set varCopy back to false for edits.
@RandyHayes I knew there had to be a much easier way to make a copy. Banging on it to see if falls down anywhere.
Below is the code for other's reference. Replace recordID with the name of the column that holds the record's ID.
If(varCopy=true, Patch(glbFormData, Form1.Updates, Form2.Updates, Form3.Updates, {recordID:Blank()}), Patch(glbFormData, Form1.Updates, Form2.Updates, Form3.Updates))
Change the Item property of your Master Form to the following:
Patch(glbFormData, Form1.Updates, Form2.Updates, Form3.Updates, {ID:Blank()})
This will then create a duplicate record with the information from the first.
I hope this is helpful for you.
#1
WarrenBelz
146,587
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,928
Most Valuable Professional
