Notes Field and other questions

[eyvaldivia]

Hello everyone, I know it's possible to have a notes field where current user, date and time are automatically added with a script but how can I make that field not modifiable after the user note has been entered. Also I'm importing about 100,000 records into one db and I need to get rid of one record of all records that are duplicated. It's been about 3 years since I used FMPro so I'm a little rusty. Thank you all for your help

[-Queue-]

You don't allow entry into the notes field. You make it either a calculation or scripted result of what is currently in the notes field concatenated with whatever is in a global field in which you allow data entry.

For the duplication, enter Find Mode and put an "!" into the field that determines uniqueness. Press Enter. Sort your found set by this same field. Then create a script to do the following:

Loop

Delete Record/Request [No dialog]

Omit Record

Exit Loop If [not Status(CurrentFoundCount)]

End Loop

This assumes there is a possibility of only one duplicated record per unique one. If there can be more than one, you'll need to tweak the loop somewhat and add a global to test whether the current unique determinant field equals the one from the previous record, etc.

[eyvaldivia]

thanx for the info, on the duplication works great if there was only 2 records on the dups but what If I had 3, 4, 5, or more of the same record...I'm working on it to see if I can figure it out but some help would really be appreciated. thanx

[BobWeaver]

There is an example in the scripting section of the Filemaker manual that handles this situation.