One Location can have many Rooms and in Locations i have a list field with the data type Rooms. I would like the list of Rooms in Locations to be updated when a new Room is created. The first part of the workflow, i.e. updating the Rooms table works fine. The problem is that I can’t get the list of Rooms to be updated in Locations.
In the second part of the workflow I choose Locations first thing to change and I locate the correct Location. So far so good. In the Change part I use the statement “Rooms add Result of step 1 (Create a new Room…)'s unique ID”. This turns red and won’t go through and I can’t understand why.
If I copy the newly created Room’s unique ID and paste in into the Rooms list field manually in Locations it works just fine.
I would appeciate any ideas. 
You’re trying to add a ‘text’ to the list…
And the field you’re tying to add it to is obviously not of type Text… hence the type mismatch error.
You can only add things to a list if they are if the same type as the list field (obviously).
Thanks. Yeah I sort of got that far. I was hoping that it would be possible to circumvent that by inserting the unique Apparently not.
How do I get hold of the thing Room after “add”? I only have access to the data fields for the room that I just created, not the Room as a thing. Crap!
I don’t understand the question… what do you mean?
Just click outside the expression, and it’ll evaluate to the thing, your expression is valid
Bubble doesn’t really indicate whether an expression is valid until after you click out of the expression
Sorry for being unclear. I have worked in another no-code environment for many years, building stuff and it works slightly different when it comes to handling the database. 
What I mean is that I’m trying to use the “Rooms add” command to add a Room to the list in the Locations table. I am then trying to use “Result of step 1” since that contains all the information I need. In the drop-down I can see all individual data fields for the Room I just created. However, as you correctly pointed out these fields are not the whole thing “Room that was created in step 1” and I therefore cannot see what I should put after the add command, if it is not “Result of step 1’s unique ID”
Thanks for you assistance. However, I actually do think there is something wrong with the trying to add “Result of step 1’s unique ID” to a list in another table. My attemnt turns up as an “issue” and the issue says I am trying to add a text to a list field and that it expects me to add a thing of type Rooms instead.
You don’t need to put anything….
The correct expression is simply ‘result of step 1’ (i.e. the room you just created).
Of course! I understand now why you at first didn’t understand my question. Talk about overcomplicating things… THANK YOU!!!
Hey Adam, Do you know how to add to a current row’s thing?
I have a workflow with create a ticket and need it to add to the event that is already created and I am clicking the button inside the row.
- Create a new Ticket
- Make changes to Current row’s Thing (Tickets add Result of step 1)
Parent group’s Ticket will be the Current row’s Ticket when the parent group’s data source is set to take the Current cell’s Ticket or Parent group’s Ticket. You need to pass the data through the button’s parent groups.
The issue was that the popup was under ticket and not event and that’s why the current row’s event didn’t showed.
So i have changed it and it worked, now I need to find a way to edit or delete lol
Incredible but the solution was there. @adamhholmes @georgecollier .
ASK! how can I select more than one row to add this changes ?
in my case, I have a product (data type) that is possible to belong to a one Family (data type) or more than one Family.
With the solution I got the first item, but no neccessarily is the only one
thanks