I am moving an application from Fieldbook to Airtable, FB has lovely formulas that allow the user to look thru a link to a table and perform any formula on that table, similar to rollups but with more functionality. Recreating my systems in airtable, i am stuck on one i can’t work out.
i have a table of entries called 'table2 and want to find ‘price’ in the last entry. In fieldbook it’s simple:
I am not finding any equivalent in Airtable. there are various other data points in the row on table2, including a sequential integer field called ‘ownership Number’ where the ‘last’ would also be the ‘max’ however i am unable to get a formula to work in a rollup that says
'lookup ‘price’ on ‘table 2’ for the row with the max ‘ownership number’