We have a farm and grain processing facility. We installed an on farm truck scale a year ago and have been manually filling out scale tickets, bills of lading, and a scale log. I want to set up a system in airtable as a scale log with the following data:
Origin (Name, Address, City/State/Zip, Phone, Email)
Destination (Name, Address, City/State/Zip, Phone, Email)
Lot Number ******* (more later)
Product Target Moisture
Moisture adjusted weight (this is a formula we are already using)
From that I would need to be able to generate:
Bill of Lading
these 2 items I’m guessing will something like “Page Designer”
Most of this is straightforward, what I’m having trouble with is trying to set up a formula to automatically generate a lot code based on other data already in an entry.
Our current lot code format is: Origin Initials-Status,Product-Crop Year-Load#
PHM-COLRK-21-1 would be Load 1 of 2021 crop year Certified Organic Light Red Kidney Beans from P&H Martens
Is something like this possible?