IDEAS ON HOW TO BUILD THIS

0
Hello,  I am working in this app and I am trying to integrate a club dropdown that shows different club options and when the user chooses a club, it should display a club balance below the dropdown. We have a database that has the clubs along the balances but I am not sure how to implement it here. I have tried using a Microflow that would trigger every time the user choose a club and would show a number but it didn’t work. I have CLUB as an entity with different attributes and Balance is one of them. Can anyone share ideas on how I can build this?   Also the balance will update as the database changes so it will constantly change with each month or semester. I am adding pictures below.  
asked
0 answers