Make Field Blank on "Duplicate"

[Puck3838]

When you "Duplicate" an existing record, is there anyway to have certain fields made blank automatically on duplication?

[GC GYM]

Firstly - I'm not an expert by any means, but I've had some excellent help on this forum. Since yours is unanswered at this point I'll do my best until you get some advice from the pros.

I guess that you want to duplicate a record so that you can keep some of the information that was in the original record, then have the user adjust the new record....

I do this by using a script...

DuplicateRecord

Clear(FieldYou WantTo Clear)

Clear(FieldYou WantTo Clear)

etc.

[Inky Phil]

You could also use the following

Duplicate record

Set Field [yourfield; ""]

Set Field [yourfield2; ""]

Set Field [yourfield3; ""]

The clear step that cg used can be used to clear all the contents of a field but can also be used to clear some of the contents of a field (depending on the cursor position).

The set field command always sets all of the field to your choice (in this case ""= null or nothing) and so is possibly preferable so as to avoid any confusion

HTH

Phil

[Puck3838]

Thanks to you both!

[Søren Dyhr]

Or Make autoenters in the fields that needs blanking... See attachment! See the differnce between the scripted and the key combo...

--sd

dupe.zip

[David Jondreau]

By checking the "Data" auto enter option and leaving it blank.

[Søren Dyhr]

Indeed if it not shall be conditional!

--sd