UPDATE: I got much close to what I’m looking for. I just need to be able to reference today’s date when doing a relation. I put today() in a cell, but I guess i need to wait until tomorrow to see if that will auto update or not. If not, I’ll need to figure out another way to enter today’s date in a relation lookup.
Hey, I’m still struggling with this.
I haven’t even considered a column for the user making the entry in my tables. I haven’t even set up any user account type functionality, so I don’t know how to do the first check. Also, not sure what an if/else column looks like. Seems like what was first suggested is a check if they are signed in, so that column is updated when the user signs in/out which I don’t know how to setup that kind of entry to the table.
I can easily make buttons add new entries, but I’m struggling to make it check if there was an entry for today and if yes, change the button from showing a form to updating an existing entry.
If it helps, this is what the app page looks like, which should always just go to a “edit” screen where it’s either blank for the day, or it shows what was previously entered for the day.
any help is appreciated. This even got me thinking that I need to learn about database structuring as I’m not sure how to make my table.
option B (separate the tables and use joins instead)