I have a key column (USER) related with 4 different tables:
- USER on Activities 1
- USER on Activities 2
- USER on Activities 3
- USER on Activities 4
Now AppSheet has created 4 different REF_ROWS VC:
- REF_ROWS("Activities", "USER on Activities 1")
- REF_ROWS("Activities", "USER on Activities 2")
- REF_ROWS("Activities", "USER on Activities 3")
- REF_ROWS("Activities", "USER on Activities 4")
How could I join all these 4 REF_ROWS tables into a new one and then delete them?
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |