I’m fighting with a thing that I wanna do with airtable:
Table ‘customers’ holds all my customers information
Table ‘orders’ holds all orders with all the order information
Table ‘catalogues’ holds all catalogue orders (as they are vastly different from orders) with all catalogue infos.
What I want is to have a column on the customers table that shows the last catalogue ordered by it’s catalogue name. This is for example “Winter 2018” and is kept in a select field in the catalogues table for each catalogue order entry.
I already have an auto number on the catalogues table and are showing the highest ID on the customers data row but I can’t seem to map a catalogue name to that. So what I need is to lookup that catalogue name from the catalogues table.
I am already showing things like last order but it’s way simpler there as I can use the data and use a max() rollup on that. That’s not possible with the catalogue names as they’re not numbers.
Any idea on how to do that?