Single column formula to count records from multiple tables

[wardenwood]

I am building a record-keeping app with many (20+) unique tables representing each form my users need to fill out. I need a way to count how many submissions each user has in each of these tables, ideally using a virtual column formula in an intermediary table that tracks form submissions for each of my users. Right now I have this intermediary table structured with the columns User_ID, Form_ID, Submission_Count, but I can't figure out the formula for the Submission_Count column because it doesn't seem that dynamically filling a table name in an expression is possible in AppSheet.

Does anyone have any ideas on how I could achieve this functionality without manually adding an "increment submission counter" action to every form that fires on submission?

[Marc_Dillon]

---

@wardenwood wrote:

it doesn't seem that dynamically filling a table name in an expression is possible in AppSheet.

---

It's not. Same with columns. You have to do something like this:

SWITCH( [value] ,
  "table1" , SELECT(table1[col]... ,
  "table2" , SELECT(table2[col]... ,
  etc