Programming Language

Ninox has its own language, which is similar to Javascript and sql. When assigning values be sure to use := instead of =.

There is a "Reference of Scripting Functions" at: https://ninox.com/en/manual/calculations/reference-of-functions-and-language

An "Introduction to Programming in Ninox" video is at: https://www.youtube.com/watch?v=dMx847g2g7o

There are many learning videos available at: https://www.youtube.com/c/NinoxLearning/videos

Welcome to Ninox!

let t := (select Table1);
if 'Certain Text' = "Field1" then
   alert(sum(t.Field1))
else
   if 'Certain Text' = "Field2" then
      alert(sum(t.Field2))
   end
end

Before you do too much work, are you aware that in the default table you can click the column header of any number column and select "Sum". You can also add or remove column(s). Plus there is a "Grouped" option that provides sub-summaries by group. I use the grouped option when importing payments received. It automatically sums them by date, so it is easy to see how much money came in each day.

There are numerous learning videos here (created by a CPA):

https://www.youtube.com/c/NinoxLearning/videos