Skip to main content

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:


Unique ID

Date

Origin (Name, Address, City/State/Zip, Phone, Email)

Destination (Name, Address, City/State/Zip, Phone, Email)

Product

Status (Organic/Transitional/Conventional)

Lot Number ******* (more later)

Gross Weight

Tare Weight

Net Weight

Incoming Moisture

Product Target Moisture

Moisture adjusted weight (this is a formula we are already using)

Scale Operator

Notes


From that I would need to be able to generate:


Scale Ticket

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?


Thanks!


If you have all of the info in individual fields, you can concatenate them together.


{Origin Initials} & "-" & {Status} & "-" & {Product} & "-" & {Crop Year} & "-" & {Load#}

However, you do not have individual fields for everything.



  • {Origin Initials} is probably a lookup or rollup from a linked origin.

  • If {Crop Year} is the year of the {Date}, you can get the year using YEAR((Date}) , but if it is a different year, you will need a field for it.

  • {Product} is probably actually {Product Code}, which probably needs to be a lookup/rollup from a linked record.

  • {Load#} doesn’t seem to appear in your list of fields at all


So, yes, it is possible, but it might take some fiddling to get it to all work out.


Reply