Hey all! This is my first day on Xano. Thanks for being a part of this community.
I'm trying to figure out how to do this.
So my app has a list of hospitals.
When someone clicks on a hospital, they can leave a rating.
That rating then adjusts the overall rating score of a hospital.
So each time they rate, they choose a hospital that they are reviewing.
I want Xano to:
1) When they choose a hospital in the rating process, input that hospital's ID to the database holding all the ratings.
2) Recognize when a new rating is added for each hospital, and pull that out of the ratings database into the hospital database, thus adjusting the overall rating score for the hospital in question.
I am experimenting with the Table Reference column, but don't know how to tell it to lookout for hospital names and match them.
Help appreciated.
Thanks.