Importing Live Data from Excel
Is there a way to import a ongoing number list from excel live?
There is an excel database with a list of numbers and its updated threw out the day and I want to pull that list to FM and for that list to be live and to be in one record as a drop down list and I want people to beable to click on a batch number from that list and that number disappear from that list once someone has checked out that batch number so other people don't work on the same batch number. Hope that made since.
Again, this sounds like the perfect situation for a FileMaker database. Even if the list of numbers is static, and is re-used each day, it should be in a datbase because: 1) it gets updated throughout the day, and 2) multiple people are using it.
Otherwise, you'll end up writing a script that imports the Excel spreadsheet over and over again, not an ideal situation.
Retrieving data ...