Help

Lot Code Generator

Topic Labels: Formulas
648 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Peter_Martens
4 - Data Explorer
4 - Data Explorer

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!

1 Reply 1

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.