I have 2 tables
There will only be 1 row in StudentsSessionInfo for per student per month per year , but multiple rows per student per month in Payments table.
I'm having difficulty in achieving the above result, please help.
@dbaum , please help , if possible
Sometimes I use an automation like this:
In origen table put a column called Trigger. TRUE / FALSE (default value FALSE)
Then in the automation you put that it occurs when Trigger is TRUE
The automation will be modifie a value... And then next action... Go again to Trigger and put FALSE.
This Trigger you can put a formula that change when XX change... Check some formulas of last value or sth similar
User | Count |
---|---|
37 | |
30 | |
29 | |
22 | |
18 |