I have what I assume is a very basic question, so pardon my ignorance.
I finally set up a system where I have…
- a “master database” table of items where the current status of an item changes based on user input
- another table (I guess it would be a “child” table) where the user input is creating new rows.
I’m sure my method is not the best, but I used automation to populate the second table. So my first question is: is that what everyone else is doing? Is that the best way to get a table of “new actions” while maintaining a “master” database of all my items?
My second question is: when I use this system now, any user input on one of the new rows not causes AppSheet to find that item in my second table and change its status instead of adding another new row, which is what I wanted…How do I make this happen? Is this where “unique ID” comes in?
Again, pardon my naivete. I’m slowly learning a lot here and putting it to use.