Set the values of some columns on another row

[LikeAFool]

Is there a way to change a value of a column from one row to another, without adding a new row to another table?
Hope that makes sense,

All the best

[Aurelien · Accepted solution]

Hi @LikeAFool

First of all, welcome to the community !
I like your nickname, by the way

LikeAFool:

Is there a way to change a value of a column from one row to another

Yes, but it’s challenging
this is a combination of two actions:

• The one that you will click on, in the “from” table
• the one that will be called by the first one, in the “to” table
  
  

[LikeAFool]

@Aurelien,
Had a feeling that it wouldn’t be easy, thank you for the help

[LikeAFool]

Tried your suggestion and it has worked!!

Thanks a lot

[Aurelien]

Good job ! I’m happy to hear it

[Ryan_Mortimer]

Excellent news that you worked it out with the help!

[Ryan_Mortimer]

This is the main function for one of my customer apps, so I hope I can help provide some insight.

Can you provide some more information about the changes and most importantly what the relationship or identifier would be between the row you are triggering the action from and the row(s) that you would like to execute the data change?

[LikeAFool]

It is a desk booking app I am creating.

When the user ‘unreserves’ their desk, I want to change the status back to ‘available’, I thought this could be done through automation…

now that you mention it, I don’t think I have made a relation between the two tables so I will give that a got thank you