Hi there. I’m new to app sheet and never coded anything before.
I’m trying to create an app where the user in one view defines the columns to a table (habits to track) and in another view adds entries to that table (reports on those habits every day or at various intervals).
How do I dynamically update the column headers? I created a slice that is called “active behaviors” where the status is set to “active,” but how do I pull those in as columns for the other table?
Thanks for your help!
EDIT: Now I am thinking dynamic column headers doesn’t make sense since each previous entry wouldn’t apply any more. So to clarify, I am thinking just to add new columns to a table when a user makes an entry in another table. Could I then do a lookup for the column headers?
User | Count |
---|---|
42 | |
34 | |
27 | |
23 | |
16 |