I have an AirTable with two Tables. I am a hobbyist trying to track a video game I play
First is a table that has:
- Trader Name
- Total Gold
Second is a table that has:
- Trade Number (auto number)
- Trader Name (this links to “Trader Name”)
- Gold Spent
For the “Total Gold” value, I want to add all the “Gold Spent” up that matches the trader, so I can see how much gold I spend on each player in my video game.
Can someone help me build a conditional statement for this. Also, if it’s not too much, how can I build things like this in the future?