Is there any way you can access a field in a different record? As an example, I collect records to manage fuel consumption. For each file of the tank, I make a note of the date, the car mileage, the total cost of filling the tank, and the price per litre. I need to calculate the difference between the current mileage and the previous mileage – is there a way this can be done? This is simple in both a spreadsheet or using a SQL Query against a normal database, but I don’t seem to be able to find a way using AirTable. Any help appreciated?
OK, I’ve been able to get this working from the example you provided - thank you very much.
What I would say to AirTable though is they need to get a more formal method added to the product. AirTable is aimed at non-programmers and this type of complex workaround simply should not be necessary and limits what is otherwise an impressive and useful tool.