Couple of questions about solutions or possible workarounds for Airtable. Trying to decide if I should quit using it and move on to something else since i feel like I’m trying to shoehorn it into my needs. It does however do a few things very well so that’s why I’m really trying to make it work.
Long story short, I have a small company with a small number of employees(4) who use this airtable. It’s a contracting company with non user savvy people involved. Most of the data input will be using the mobile app.
First minor annoyance that would be really appreciated if anyone can help me solve it. I have a series of table links throughout my base.
IE
CUSTOMER -> EQUIPMENT
Also I have other links which reference the same.
WORKORDERS -> CUSTOMER
WORKORDERS -> EQUIPMENT
Can I have the link only display equipment linked to the customer for selection? As opposed to searching through a thousand appliances in the table? (Not sure if I’m explaining this right?)
Next
I have a TASKS table. If that task is billable it gets linked to a record in the workorders table. TASKS is already linked to CUSTOMERS and EQUIPMENT.
Is there a way to transfer those links to the new WORKORDERS record created?
Third
Signatures on the mobile app. I’ve looked through the community forums and see that people have asked for this for years now. Is there a working solution to this now? I needs a mechanics signature and a customers signature in the WORKORDERS record.
Fourth
Hiding fields in the editor (Expanded Record View?) based on other fields.
IE.
I have a PARTS table to automatically select some common used parts in the WORKORDERS table. If those parts aren’t available or the mechanic wants to manually put something in the parts with a custom price I’ve also added manual fields for this purpose. This makes the amount of fields to scroll through insane. I’m wondering if there’s a way to automatically hide them if they aren’t needed. So when a mechanic links something from the PARTS table the manual field disappears or vice versa.
There’s probably more I needs to ask but I’ll start with this lol.
I may not have explained what i’m trying to well, so please ask me to clarify.
