Hi team! I have a table A with a column called “Offer Amount”. I want to create a table B which will have a cell containing the max(tableA’s OfferAmount), that gets updated each time a new record is created in table A. Is this possible on airtable?
The background is that I want to send the current highest Offer Amount (out of all the records on table A) to a webpage on builder.io via zapier (hopefully) each time a new record is submitted to table A. The records are inserted into Airtable table A from a form on builder.io via zapier.
You should be able to do this with Linking, Look Up, and Roll Up
Field: Offer Amount
Field: Link to Table B Product
Field: Look Up Offer Amount from Table A
Field Roll Up of Offer Amount in Table B with Formula MAX(values)
Hey @Vivid-Squid, thanks a lot! However, I feel this gives me the max offer per product.
I’m looking for something like an equivalent of =MAX(Offers!A:A) in a cell in Products table. Just an aggregate with a cross table reference. Hopefully, this should get updated as new records get added in Offers table.
Is something like this possible? Sorry if I wasn’t clear earlier.