Jump to content

Excel Data and FM Search Function


jonn89
 Share

This topic is 4400 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

Hello,

I am using filemaker pro 9 to enter marks for students, and the mark sheets are supplied as excel spread sheets. Right now I am copying the student number from the spread sheet, and pasting it into the search box, then clicking new, and keep doing that until I have entered all the student numbers, and then I click search. This works fine, but I am sure there is a way to highlight all of the student numbers from excel, and then search them all at once? As in highlighting the whole batch of student ID numbers and searching in filemaker as opposed to individually copying and pasting into the search function...

Also, once I have done this I have to type in the students' marks individually, is there also a similar function which allows all the marks from a spreadsheet to be copied and pasted into Filemaker all at once?

Sorry if this issue has been addressed previously, but I searched and found nothing as I didn't even really know what to search for. Thanks for anyone that can help.

Regards,

Jonn

Link to comment
Share on other sites

This topic is 4400 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.