Hi everyone! I'm currently working on a quick project for my boss, part of which he wants to be able import records from excel to filemaker and be able assign a specific ID number for all the records that doesn't have a specified ID number. How can I do that? I can import records now form excel but unable to assign an ID number. Here's how my boss wants it:
In a layout, there is an empty field for ID number that he wants to assign to those records that will be imported and there is also a button that will trigger the script to import the file/records he wants to import from excel into FileMaker. SO when he clicks the button, the number he entered in the ID field will be assign automatically to the records.
How can I do that? Thank you for the help!