Button to edit another sheet's item data

Hello, I have on my application three sheets, one for Places, one for Users, and one for Ratings which specified the UIDs of both user and rated place, by the end I calculate the average rating of each place. I created two variants of the rating button, one for if the user hasn’t rated the specific place and one if he has already rated, and in which case I notify them for “rating already sent”. Now I want the button presented to users that already rated a place to change their rating by opening an editing screen for the rating row, which I can’t solve how to do. Please help!

Ideally I could choose on the list another item.

You could try switching the data source to a relation of the item I believe.

1 Like