I just purchased the FileMaker Developer Subscription and am looking to focus my learning curve and would appreciate where I can quickly find the answers to my questions.
- I have an Excel Document with multiple worksheets that is used to track some inventory.
- I am thinking of using the pre-built Inventory Template in FileMaker to replace the Excel document to reduce development time.
- I need to allow multiple users access to the inventory data via mobile access. They need to filter, create reports, and modify the data.
1) How do I map my existing field data in Excel to the fields in the Inventory Template so I can do a quick import?
2) Can I display the Inventory Template on the Web and allow access to users outside the company?
3) Can I make reports on demand or does each report need to be prepared first with a new layout?
4) I was going to setup FileMaker Server Advanced to hold the data. If there will be about 15 users, does each user need FileMaker Pro client versions?