Forum Discussion
OanaWhalen
6 years agoQrew Cadet
Kathryn,
Can you post a screenshot of the excel file (at least row and column headings) so we can better understand what you are trying to achieve?
------------------------------
Oana Toma
------------------------------
Can you post a screenshot of the excel file (at least row and column headings) so we can better understand what you are trying to achieve?
------------------------------
Oana Toma
------------------------------
- KathrynDailey6 years agoQrew MemberHi Oana,
This is equivalent to the excel sheet we're using with dummy data:
------------------------------
Kathryn Dailey
------------------------------- OanaWhalen6 years agoQrew CadetI'll have to think through this one a bit more, but at first glance my thought would be to embed report links for each Team (with an identical table displayed for each) on a Department form. You could play around with the columns being Month 1, Month 2, Month 3, This Quarter, This Year, Last Year, etc, many of which can be created using "during" filters on date fields, to avoid having to change your column headings every time. I imagine you would need to create these as summary fields on your Department table and pass them back down to your Team tables, but there may be a more direct way.
One other option would be to have two separate forms in your department table. You can use the single form you already created and format it to be easier to use. For an Edit form, you can create a separate identical Tab for each team that has more field labels, instructions, etc. If you didn't want all those fields living in your parent table, you could also display Grid Edit reports to enter data from the Parent form directly into your Child table, with filters applied to only display one Team at a time. When you are in View mode on that table, you could either fake in your own table (see example below) or find a clean way to display your data with fewer labels and such without the tabs. To toggle between multiple forms on a table, you can use the "Set how different roles use these forms" option that becomes visible when you have more than one form, and has an option for Everyone.
And here is an example of the simple "fake" table I've created to display data in a form.
Hopefully this gives you a start, but I will keep pondering when I have a bit more time. Let me know if any of these options seem more appealing and I can dig into that one more.
------------------------------
Oana Toma
------------------------------- KathrynDailey6 years agoQrew MemberHi Oana!
You were a genius to suggest embedded reports. Embedding each team's report onto a connected form worked perfectly for us to be able to show each team's individual fields but with all the teams stacked on top of each other.
My new task is to get summary rows within those same reports for Q1 to date and Year to date. If you have any suggestions on how to do that, your help would be extremely appreciated!
------------------------------
Kathryn Dailey
------------------------------