How do i add up totals

Sounds like you are ready to learn dashboards. Take a look at this video and give it a try and then come back with specific questions.

https://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=&cad=rja&uact=8&ved=2ahUKEwjMrqyjuav3AhUoIkQIHUOZCZQQtwJ6BAgDEAI&url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DnUqGl84gh08&usg=AOvVaw1bS6YYAfGTLE6lDuMBcWOM

Hi Edward

So glad to hear you are still having a go with Ninox. Honestly, it's an amazing bit of kit. I transferred a portion of my FileMaker system to Ninox last week. In FileMaker it was a months' worth of development time, in Ninox I had the bulk of it working in a day!

Anyway, you need to swap the double quotes for single quotes

select 'Bamboo Sunshine'

In Ninox if your table or field is a single word it can be referenced without any quotes but if there is a space in your table or field name it needs to be surrounded by single quotes.

Regards John

I'll use my sport DB as an example. Here is a pic of the top part of one of my dashboards:

I track two different show jumping leagues in the same DB, so the first field allows me to change leagues. I can then select which team I want to see under Team and it will only show me the teams in each league. Under Season I can select the available seasons that the team has competed in. Under City, I can select a city from all Cities that the team has competed in.

I have a tab named Work Area that I store fields that I don't need to see but I need for functionality. One of those fields is called allresults. This field goes and gathers all the records from my Results table so I can then then create all the data in the pic above.

The code for allresults field is:

let t := this;
let xSeason := record(Seasons,number(t.Season));
switch mode do
case 1:
    Results[TeamID = t.Team.TeamID and Year_calc = xSeason.Year]
case 4:
    Results[TeamID = t.Team.TeamID and Location.City = t.City]
case 5:
    Results[TeamID = t.Team.TeamID and Year_calc = xSeason.Year and Location.City = t.City]
default:
    Results[TeamID = t.Team.TeamID]
end

What I am doing here is depending on what selections I choose for Team, or Season, or City, or some combo, I will gather the records from my Results table that match the requirements I need.

I don't use a select because I already have a link from all records in Results to this dashboard. I can very easily add select in front and it will gather the same data.

You could skip this step and do the above on each stat field, but then if you need to make a change you have to change every single stat field.

This method allows me to write the following formula for the field Atmp:

sum(allresults.attempted)

I could not use the allresults field and just put the 12 lines from the allresults field and then change each case to get the sum of attempted, but that is a lot of work. How do I know? Well, maybe I did it that way first. :). Imagine taking the line of stat fields above and adding 12 lines to each of them.

I hope this helps a bit.

How about we start at the beginning so we can walk you through how to setup your dashboard. Your initial post lists a lot of things you want to see. Can you pick one summary data you want to see and tell us the tables (and any relationships) and fields that are involved and we can give examples.

I've mocked up what it could look like. Take a look and let me know if you have any questions.

The table monthYear is there so you can create the Month view. I'm sure someone smarter than me has figured out a way to create a table on the fly that a view element can use. What I did was on Trigger after update on the Date field in Jobs, it goes and checks the monthYear table and if it doesn't find a match then it will create a new record.

If you end up going this router then you can always hide the table so you don't have to see it.