Dec 01, 2024 03:44 PM
We are looking to create an air table for a building contractor business.
the job would entail building an initial base and then providing on-going support as necessary.
Below is a snapshot of what we are after -
Once quotes are received they are input and it should progress through the system (relatively automatically) all the way to invoicing and archiving.
Noteworthy items would be;
Builder/client
Quoted amounts
Attachments
ETA
We would like to add attachments for;
site plans, site specific safety forms (JSA/SWMS), job take-off, notes for additional variations.
plus the potential to attach photo's if possible.
If possible we would like the ability to filter through individual clients individually
We envisage the workflow to be as below but are open to ideas.
Quote received
Quote sent
Purchase order received
Schedule
Completed jobs archive
Lost opportunity archive
Dec 01, 2024 04:09 PM
Hey @Mattp1!
I’d be happy to help out. I’ve built plenty of similar systems. Please feel free to reach out via private message, or schedule a call for Mon/Tues using this link.
I’d love to hop on a brief call to go through your specific needs.
Dec 01, 2024 04:51 PM
I am one of the top expert Airtable consultants.
If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
Dec 01, 2024 06:12 PM
Dec 01, 2024 10:00 PM
Hi Matt, I'd be happy to help with this!
We'd take a look at this together to see if we could handle it all within Airtable, and if not we'd integrate third party tools as needed, for example automating PDF creation for the quotes and sending them out, creating the invoices in **bleep** Online, or maybe even conberting those site safety forms into a digital format instead of having them as attachments
Adding photos is definitely doable, but depending on the plan you're on and how many photos are expected to be uploaded you might hit a wall pretty quickly. The Teams plan allows for 20 GB of attachments for example, and photos uploaded from our phones can be pretty big; assuming each photo is 5MB, you'd have 4000~ images or so and you'd run out of space, so we might need to consider looking into a service that allows for image compression too