Fuel Usage Log - Calculation and passing or copy the value to new record

Topic Labels: Formulas
464 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer


I have created a fuel log form using Jotform and airtable base to record the fuel usage which should match the meter reading at the physical fuel tank. There are 2 types of fuel; Diesel and Gasoline. Both are require to record the following details:

  • Diesel Tank = This field shows the remaining fuel in the tank. Physically the fuel tank can holds 500 gallons.
  • Diesel Start = This field shows the beginning of fuel reading. The start reading should begin with fuel tank 500 gallons = 0.
  • Diesel End = This field require the employee to enter the ending of fuel reading after she/him done pumping the fuel into a vehicle/equipment.
  • Diesel Total Gallons = This field shows the total gallons that’s has been pumped. (I already got the solution for this field).

My problem in sample use case is — the first employee record the fuel log as following:

  • Diesel Tank = 500 (Auto calculate/ formula)
  • Diesel Start = 0 (Auto calculate/ formula)
  • Diesel End = 30.9
  • Diesel Total Gallons = 30.9 (Auto calculate/ formula)

Then the second or next employee, the fuel log record should be:

  • Diesel Tank = 469.1 (Auto calculate/ formula)
  • Diesel Start = 30.9 (Auto calculate/ formula)
  • Diesel End = 56.3
  • Diesel Total Gallons = 25.4 (Auto calculate/ formula)

And it’s continue until the Diesel/Gasoline Tank = 0, then it’s restart again at 500.

What will be the formula for Diesel Tank and Diesel Start? Thank you so much in advanced for the help.

0 Replies 0