Open lookup list to select rows

[robyrambrosiano]

Good evening, I would like to create a seemingly simple function but I cannot find a way to implement it in Appsheet.

I have a sheet that contains the list of hotel rooms and a sheet that contains the list of guests that need to be divided into the various rooms.

In the guest table I created a column that points to the room number, setting it as "Ref".

Now I would like from the room view to have a function that would somehow allow me to click on the guest that I want to put in that room: if I am on room 1, I want the guest list to open and when I select one, the "room number" field to be populated with the number 1.

Any ideas on how to develop this feature?

[robyrambrosiano · Accepted solution]

I found a solution, which I report for everyone:
I created a new sheet to save variables.
In the source view I create an action that calls several actions in sequence: deletes the previously filled variable, creates a new row for the variable that keeps the room number saved, opens the guest list.
On the guests I created a function that retrieves the room number from the “variable” and fills in the “room” field on the guest.
I kept the same flow for guest removal as well.