Add Record - Is it Set Field or Replace Field Contents?

16/12/2014 SB: When using the Add Record Button, it Duplicates the complete Record, including the contents of the following Fields: Follow_up_Comments, Importance, KIC Received, Report Received, Assigned To, Start Followup, Case Closed, Closed By and Comments. 

16/12/2014 MS: To solve the above problem (16/12/2014 SB), we need to find a way of duplicating a Record but with only some of the information, so that the new record has the main characteristics of the old one – but it is still not identical (as in an invoicing system, where the customer details are the same but the new sale has different sales data – See: [i]). Need to find out the difference between “Set Field [ ]” or, since you want all records, “Replace Field Contents [ ]” (Source: [ii]). “Replace Field” updates the specified field for ALL records in the current found set, not just the current record. Use “Set Field” instead of Replace Field Contents (Source: [iii]).

Solution - replaced the Script to carry out the following Steps:

• Duplicate Record, 
• Populate the above Fields with the following Values: 
• Importance: Medium (the Default Value), 
• KIC Received: “Not Yet”, 
• Report Received: “Not Yet”, 
• Assigned To: “Pending”, 
• Start Followup: BLANK (Clear Data), 
• Case Closed: BLANK (Clear Data), 
• Closed By: BLANK (Clear Data)
• Comments: BLANK (Clear Data).

[i] http://filemaker.463488.n4.nabble.com/quot-replace-field-contents-quot-td500161.html

[ii] http://fmforums.com/forum/topic/61648-how-to-remove-title-case-in-text-field/ Post #6

[iii] http://forums.filemaker.com/posts/5b8b7e42d1?commentId=286112#286112