1) search by creation date sounds like the way to go but, if you are using import records script step there is a way..
Create a script for the import thats does the import, finds records just imported, then uses replace field contents to set a group serial field to a serial
(you are automatically in a found set of all affected records after import)
find recently imorted (if needed)
set var = serial number
replace field contents ( serial field ; var )
2) Duplicates. This is an easy one right? Search, go to field, insert "!" into a field, bam they show up. Fine whatever...but what about a pop up after the upload that requires an individual to view these particular records that are duplicates? Pop ups, how do I do that?????
Script a find after the import that isolates the duplicates and prompts the user with Custom Dialog whether they want to view them
1. After an import, the import records = found set. So create a number field and use a script:
Set Variable [ $max ; ExecuteSQL ( " SELECT MAX ( importNo ) FROM RealEstate " ; "" ; "" ) ]
Replace Field Contents [ RealEstate::importNo ; no dialog ; by calculation: $max + 1 ]
A variation: create an Import table, with just a date (auto-enter current) and a primary key; add a foreign key to your other table, and use
Go to Layout [ Import ( Import ) ]
Set Variable [ $id ; Import::id )
Go to Layout ( RealEstate ( RealEstate ) ]
Replace Field Contents [ RealEstate::id_import ; no dialog ; by calculation: $id ]
This table would be a convenient log of your imports over time.
Optimally you would handle the entire import with a script of which the above steps would be a part.
2. You mean a custom dialog? Handle finding (constraining) duplicates also via this script, and if there are any, show a dialog.
1) I'll give this a shot. I appreciate your help!!!!
2) yea a popup is what I'm looking for. Coherentkris's response is pointing me in that direction.