Hi everyone, I hope you can help me again.

Is there a way to duplicate a record but only parts of it? Actually only contents of 6 fields. Or is this a copy function?

Thanks,

jean

You could do it a couple of ways...

Duplicate the record using a script and following that step, clear all the other fields.

Store the fields you want to move in Globals, or a script parameter, then use Set Field to move the data into the new record after it's created.

The Insert From Last Visited step is also an option, which would not require globals or script parameters to be used.

Store the fields you want to move in Globals, or a script parameter, then use Set Field to move the data into the new record after it's created.

I prefer 1 global text field to hold all the values and then using the Evaluate function to strip out the values for my Set Field steps, example attached. Note the use of Quote(FieldName) for values that are not numbers.

The same can be done using a script parameter but then every time you want to edit the passed values you have to:

1)go into Layout Mode

2)right click the Button the parameter is attached to

3)left click Specify Button on the context menu

4)left click the Specify Button-button

5)click the edit button.

I'm tired just typing all those steps! You have to go through that each time you need to edit the script parameter. I much prefer the value in my script where I can easily get to and edit the values I want to pass, even in browse mode. Plus this makes it easier to troubleshoot the passed values because you are able to see the result in the global field.

DuplicateSomeFields.zip

I tried all of your suggestions and it all worked. I ended up using the Insert from last Visited since I only needed to duplicate 6 fields of a record.

Thanks again, everyone.

Jean