Easiest way to update a value in a cell when loading the data in a cell of another table?

[FullPrism]

Hello everyone, I hope you are very well, I was reading the forum a bit but I didn't find what I'm looking for, that's why here is my question:

I have two tables
-> CLIENTS
-> REPORTS

One of my columns in the REPORTS table is REPORT DATE, I want to automatically update the RESPONSE DATE column in my CLIENTS table, of course the RESPONSE DATE would be the same as the REPORT DATE.

It seems very simple to me but I am not achieving it.

[Aurelien · Accepted solution]

Hi @FullPrism 

You may want to use an action: "Data:execute an action on a set of rows".

I suggest you have a look to this post, as there are some similarities:

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Trigger-an-action-from-two-different-table-simu...

[Aurelien · Accepted solution]

Hi @FullPrism 

You may want to use an action: "Data:execute an action on a set of rows".

I suggest you have a look to this post, as there are some similarities:

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Trigger-an-action-from-two-different-table-simu...

[FullPrism · Accepted solution]

Hi @Aurelien 

Thank you very much for your answer, I found the answer in the thread that you suggested, even my problem was simpler.
What I did was the following:
- Create an action for the CLIENTS table -> Action 1 - ANY(SELECT(REPORTS[Date report], ([IDCLIENT]=[THISHROW_] ))) -.
- Create an action for the table REPORTS -> Action 2, with the following configuration:
==> For a record of this table : REPORTS.
==> Do this : "Data: execute an action on a set of rows".
==> Referenced Table : CLIENTS.
==> referenced Rows: to FILTER(), a filter with my requirements.
==> Referenced action: Action 1.

[Suvrutt_Gurjar]

Hi @Aurelien ,

Please feel free to flag such posts to be moved to "Q&A" section whenever feasible.

[Aurelien]

I didn't notice...my bad.

I do it when I notice it ! Thank you for your eye on it 😅