I’m facing a challenge with a lookup / rollup field. I will share a link to an example base I quickly threw together, feel free to check it out to better understand my challenge. Keep in mind that this is a very simplified version of my original base.
I have a lookup field which lives in a table of drivers which gives me cars used for different trips. If a driver uses a BMW X3 on 3 trips, the lookup field shows “BMW X3” 3 times. If that same driver uses a Tesla Model 3 for 5 trips, the lookup field would contain BMW X3 3 times and Tesla Model 3 5 times. So far so good.
Now, what I want to pull out is simply “Tesla Model 3”, because that was used the most times. If one driver has used two/three cars the same amount of times, I would like to pull out both/all.
I’m not sure if it matters but in my base there will never be more than those 3 cars to select from. Also, it is not possible to use more than one car for a trip.
Does anyone have any tips and tricks to overcome this?