Skip to main content
Nintex Community Menu Bar
Question

Copy a record and have ability to modify the copied record before saving

  • November 28, 2024
  • 8 replies
  • 44 views

Forum|alt.badge.img+4

I need create a workflow to make a copy of a record and then prompt to update values before saving it to the same list. *Note there are repeating tables involved

Translate
Did this topic help you find an answer to your question?

8 replies

Forum|alt.badge.img+9
  • Nintex Employee
  • 65 replies
  • December 4, 2024

Hi ​@jamvan,

 

Provided you have Nintex Forms, I think what you’d want to do here is make a start form for the workflow.  If you select Workflow Settings>Edit Start Form you should be able to configure a Nintex Form.  If you create Workflow variables and set  the option show on start form, you can prompt a user to enter those values prior to the workflow running. You can also drag in the list properties for the item to show them on the start form as well.  Then the workflow can run using the create an item action to create the new items based on what was entered in the start form.

 

Doing it this way means that the values you’re looking to set are done prior to the item creation at the beginning of the workflow run.

Translate

Forum|alt.badge.img+4
  • Author
  • Scholar
  • 12 replies
  • December 5, 2024

So, I have a list with a form already attached to it to create purchase requisitions. The users want the ability to open a current one and make a copy of it, but before saving it; have the ability to change the values before saving the new purchase req.

With your solution am I creating a new form to attach to a new workflow?

 

Wokflow actions> 1. Create the Workflow variables and select option “show on start form” 2.Create Item 3. End Workflow ????

 

Thank you for you input Brent, it is greatly appreciated.

Translate

Forum|alt.badge.img+9
  • Nintex Employee
  • 65 replies
  • December 5, 2024

@jamvan 

Yep that would be the basics of it.  You can also add the workflow to the context menu for the item or add a link to the item with a calculated column to make it easier to access the form directly from the list.

Translate

MillaZ
Nintex Employee
Forum|alt.badge.img+21
  • Nintex Employee
  • 652 replies
  • December 9, 2024

Hi ​@jamvan Has Brent’s answer solved your question? 

Translate

Forum|alt.badge.img+4
  • Author
  • Scholar
  • 12 replies
  • December 10, 2024

I haven’t been able to get it to work just yet. I wasn’t quite sure how to set this up “You can also add the workflow to the context menu for the item or add a link to the item with a calculated column to make it easier to access the form directly from the list.”. I have signed up for the University and will start some training shortly.

Translate

Forum|alt.badge.img+4
  • Author
  • Scholar
  • 12 replies
  • December 11, 2024

I created a calculated column with this: ="<a href='https://[site-name]/Lists/[list-name]/EditForm.aspx?ID=" & [ID] & "'>Open Nintex Form</a>" however, when I go to the list it displays this:


How do I go about getting them to be able to click on the hyperlink to the form?

My plan is to have a Query List and then Create Item in the workflow. Is this correct? Thank you in advance for your help.​​​​​​​

 

Translate

  • 69 replies
  • December 12, 2024

Calculated columns can’t refer to the ID of an item. It’s a sharepoint limitation. You need to use a hyperlink column instead and use a workflow to create the link with a Build String action.

If you create the item in a workflow you can store the new Item ID in a workflow variable directly in the “Create Item” action. You can then use that workflow variable to create the link and update the hyperlink field in that same workflow.

Translate

Forum|alt.badge.img+4
  • Author
  • Scholar
  • 12 replies
  • December 12, 2024

Thanks, BobR, basically the just of this workflow is to copy a record and prompt the user to update the values before saving. Despite all the great tips here, I still have not been able to get it to work.

I was attempting to get the suggestion from Brent to use a calculated column to get the new link in the list.

 

I just need the ability for the users to copy an existing record ad hoc (when they want to) and update before saving.

Translate

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings