Hello,
I try to build an app for measuring mileage of cars. People need to add every month number of kilometers in app for specific car.
So i have two list , one call CarNumbers with two columns CarNumber and Driver. Driver it's a people field. In the other list (MileageCars) the drivers need to add number of km for specific car. This contains a text field call CarNumber and number column for kilometers - KmNumber. I want to automatically add the value of car number from list CarNumbers in the text field CarNumber of second list, based o the driver who open the app. All the values are unique , every car have a single driver designated. If it's complicated i can use a text field for email address of driver instead of People field.
I try using lookup function on the text field CarNumber from MileageCars but it's not working. Always bring me the first value, no filter..
LookUp('CarNumbers',driver.email=User().Email,'CarNumbers.CarNumber)
