I am trying to create a base for tracking which consultants are assigned to which projects over time. We have a Projects table, a Workers table, and a Project Assignments table linking them. (It’s actually a bit more complicated than that because t...
+1 for the vertical option! I’m trying to replace spreadsheets with a bunch of checkbox columns, but it ends up getting way too wide to see. On the spreadsheet, we just rotate the column header so we can read the whole label but still fit all the c...
I think it would work to have a Participant table and a Week Entry table (whatever you want to call them)
Week Entry
FieldTypeParticipantLink to Participant tableRun DistanceNumberRun TimeDurationBike DistanceNumberBike TimeDurationTotal Run/Bike Di...
Thank you very much for your prompt reply. I am a bit disappointed that there’s not some secret setting that will magically do what I want :winking_face: but I’m very grateful for the time you saved me searching for it! I’m probably going to end ...
Thanks for your example! The structure of your Invoices and Line Items makes sense, but I’m not quite sure how to make it work from a form view with a junction table as you describe. What I’d want is something like the following. Three tables: [Pr...
