I am looking for a way to manage inventory in the field. I want to use an ipad/iphone for taking inventory, and use a mac to generate reports.
This can be a single app or a pair of apps.
I can do some of what I want now using Google Spreadsheet and GAS (Google application script) However Google docs do NOT run scripts offline. I have no internet access where I'm taking inventory. (The nearest wifi is a thousand feet away.)
I can do this with Filemaker Pro. But that seems like bringing 16" guns to bear on a mouse sized problem. FM is uncheap.
I might be able to do it on Excel for iPad, but I'm incensed by Microsloths licensing policy for iOS apps, so I've not looked at this directly.
In a spreadsheet style application the functions I need:
- take action on edit.
- indirect lookups.
- filter as a command
In a database style application I need the ability to edit in table view, do filtering, lookups, dropdown lists filled by filter commands.