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.
Solved! Go to 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:
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.
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:
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.
Hi @Aurelien ,
Please feel free to flag such posts to be moved to "Q&A" section whenever feasible.
I didn't notice...my bad.
I do it when I notice it ! Thank you for your eye on it 😅
User | Count |
---|---|
37 | |
30 | |
29 | |
22 | |
18 |