I have been playing with Airtable for a while now but not high level enough to figure out scripting yet. I’m a farmer and I’m looking to make an Airtable solution for my spray applications.
I’ve got a few tables that hold the general info: ‘Blocks’, ‘Chemicals’, ‘Applicator’
I’ve got another table that is my ‘chemical manifest’. This one grabs the particulars from ‘Chemical’ and I add the particulars such as purchase date, amount etc…
The ‘JOB’ table is the workhorse. It allows me to record the ‘Blocks’ being treated with the ‘Chemical Manifest’ with which ‘Applicator’.
My limitations are:
- Sometimes I add one chemical to a job, sometimes I add ten. I don’t want to add 10 sets of fields related to each ‘Chemical Manifest’
- My application rate’s are sometimes different than the general label rate on the chemical, I can’t figure out how to change the linked field (rather import the info and then change as needed)
- On entering the Job, I would like to reduce the Amount of available chemical from the manifest then once at 0, change the status to ‘finished’
I’m loving how you can burrow down on Airtable, looking at what blocks have had Jobs etc, very cool.
Are all of these tasks possible? Are there people out there who could assist me in achieving this?
Thanks again everyone!