Forum Discussion

KellyBianchi's avatar
KellyBianchi
Qrew Assistant Captain
7 years ago

How to create a formula field that pulls the most recently updated of 2 fields

I have a field that tracks the offers made between a buyer and a seller. I was a formula to note who made the last offer. So the fields woud go: Buyer Offer: 2500 Seller Offer: 3000 Current Offer...
App builders
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
No problem. You do that with a reverse relationship.

You probably already have a summary field on the Parent Property Record of the Record ID# which has the information you want.

Just make a reverse relationship where 1 Offer has Many Properties. Yes that feels backwards so it�s called a reverse relationship. But for the reference field on the right side of the relationship, do not let it make a new field, but rather use that summary field of the maximum Record ID of the Offer.

Then you can lookup any text fields form the Offer to the Parent Property