Change values on other table

AppSheet AppSheet Q&A
1

Hello guys
I need help to my problem

I have 3 table

  • First table : Tasks
    columns:
    Task id: Text UNIQUEID() (key)
    Task kind : Enum
    Task Date: DateTime
    employee id : Number @from here@
    Management : Enum
    covenant id: Number
    covenant id : Ref
    employee id : Ref

  • Second table : employees
    columns:-
    employee id : Number (key)
    employee name: text
    Management : Enum
    Related tasks: List

  • Third table : covenant
    columns:-
    covenant id: Number (key)
    covenant name: text
    covenant kind: Enum
    employee : text @to here@
    Management : Enum
    Related tasks: List

What I want is in the Covenant tabel
When executing a task in the Tasks table is transferred from an employee to an employee
I want the employee to change in the Covenant table based on what’s changed in the Tasks table.

I hope that my request is clear
and i hope you can find a solution for my problem.

Thank you

2

Any help guys?

3

Hi @salehej

You may want to get inspiration from this post:

[Set the values of some columns on another row](https://community.appsheet.com/t/set-the-values-of-some-columns-on-another-row/57496/2) Questions

Hi @LikeAFool First of all, welcome to the community ! I like your nickname, by the way 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 [image]

However, when I read that:

salehej:

I want the employee to change in the Covenant table based on what’s changed in the Tasks table

If there is a simple child/parent relationship involved you may want to use an app expression using dereference.
For more information:

1 Like