Need a script to duplicate a record but delete some fields?

[keepemup]

I am having a problem with the users duplicating a record but not changing or removing some of the information. The users are duplicating the client info(yes I know that a client should not be in multiple times but that is the way it is for now) but is not making sure that other information is changed or removed. I was thinking that I could write a duplicate script that would let me delete or clear the fields that need to be removed or can I write a script that will only duplicate the information that needs to be duplicated?

[Weetbicks]

Yes go for it

 

Restrict users access to the FileMaker level duplicate option by preventing their ability to add records to the table in question, and then ensure its all scripted via scripts with full access.

 

Your duplicate script step would be fairly simple, just duplicate record in question, and a series of "set fields" to clear out the ones you want. Another option is to Isolate the record in question in a found set containing just itself, then import it back into the same table, but only import the fields you want to retain. (I prefer option A for its easier to understand and less prone to disaster!)

 

Option C is to operate on your users, removing the part of the brain that compells them to try to break a system or bend rules, but proceed with care

[HBMarlowe]

Option C is to operate on your users, removing the part of the brain that compells them to try to break a system or bend rules, but proceed with care

 

 

Long term, this seems like the way to go. Much easier than installing proper security in every damned file!smiley-wink

[keepemup]

Yes go for it

 

Restrict users access to the FileMaker level duplicate option by preventing their ability to add records to the table in question, and then ensure its all scripted via scripts with full access.

 

Your duplicate script step would be fairly simple, just duplicate record in question, and a series of "set fields" to clear out the ones you want. Another option is to Isolate the record in question in a found set containing just itself, then import it back into the same table, but only import the fields you want to retain. (I prefer option A for its easier to understand and less prone to disaster!)

 

Option C is to operate on your users, removing the part of the brain that compells them to try to break a system or bend rules, but proceed with care

I am working on the script to clear out certain fields and I am not sure how to write it. I started with Duplicate Record/request, set field, specified the field, but I don't know what to do from there. Do I have a calculation for the field to clear and how do I write it? THanks!

[Weetbicks]

To clear a field simply set it to "" (two quote marks) in the calculation.