I am making a new page for a “collection.” This is a page where the user can enter their bourbon name, price they paid, date, and market price. The part I need help figuring out is getting the market price. I’d like for the market price to pull from my “Listing” google sheet. The listing will have the prices of that particular bourbon that has sold. However, let’s say Papi 10 year may match to 5 different rows in the Listing spreadsheet. The one I want to use to populate market price is the last selling price. In addition, this market place price should be dynamic. In other words, if someone sells Papi 10 year in a month from now, the market price should change. How can I do this? Please help.
-
Create a relation from the Bourbon table to the Listing table. Sounds like you might have to use the Bourbon name itself, but if you can use something that might never be changed like a rowID, it would be a better practice.
-
Mark the relation as multiple match.
-
Create a single value column on top of that relation, return the last price from the relation.
1 Like
This worked perfectly. Thank you so much!
1 Like
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.