I’m not sure if what I’m trying to do is even possible with Airtable. But it needs to be as user friendly as possible because it will be used by employees of my company.
I’m a service based company and I’ve been using Airtable to track work for various customers.
Requirment 1 - Workorder
To be able to fill out a form with relatively simple user experience. Ability to enter a lot of data into the form with a minimal interface (ability to hide fields until they are required would be ideal). Also data in the form must link to other tables and grab data from those tables. Also the form must be able to collect signatures. All on mobile. I tried out Fulcrum on a recommendation and it has everything I need for the form side, but not the data management or report side. So if you’re familiar with Fulcrum you may know what i have in mind. Currently all data is entered directly into the table and is a clunky experience at best. It’s embarrassing trying to teach people how to use it.
Requirement 2 - Workorder Customer site copy
To be able to either email or print this form without the automatically calculated pricing so that a copy can be left on site with a customer. From a mobile device. If it is to be printed a printer will be used in our service trucks. Also this workorder needs to remain in airtable to be priced and printed in the office at a later date. I have a working example already made in page builder block. But it isn’t so accessible on mobile.
Requirement 3 - Appliance inspection sheet
To be able to fill out a checklist that pulls all of its data from multiple tables and links to the above mentioned form so that it shares the date and a common identifier so they can be referenced together at a later date. The report for this will be dynamic, so that the checkboxes on the form will depend on whether they are required in the table.
Everything is required to work on mobile.
I can elaborate on this as required.
I’m looking to know A, if it’s possible to do this and B what would be the expense of setting this up. How much extra services are required to do this. Airtable is relatively inexpensive by itself for multiple users, but using multiple services can easily push the pricing through the roof.
