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


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.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.