How to get last hourmeter reading from a machine?
Have a table with columns A - timestamp B - placa (machine code) C - hourmeter D - last hourmeter
When inserting a new entry, the hourmeter can´t be smaller than the last hourmeter inserted.
So I need to get the last hourmeter, and if it’s higher than the one inserted, it will block the insertion of the new one (needs to type a new number)
tried this function at Last Hourmeter column LOOKUP(maxrow(app, timestamp), app, placa, hourmeter)
Got error message saying the result type was a number, when it expected a text.
What should I use in place?
LinkedIn
Twitter
