-
Sum service amounts from three tables based on dates
Hello. I pay my employees weekly based on how much they bring in for services, products and off-site events (three separate tables) throughout the week. I am using a date field.…
- Answered
-
Trigger on open database
if i put this script into a button on a table form it works. do as server for a in select JobDockets where 'Job Bag' <= 13980 do a.(SupplierQuote := null); a.(SupplierConfirmation := null); a.…
- Answered
-
All I want for Christmas!
Ninox Support (When you are monitoring this forum - Please pay attention to this Santa Wish List thread. This is what your user base are listing here because we need a few (err probably more that…
- Answered
-
Sum Based on Choice
Trying to add up all totals from multiple records based on a choice. Data Base is called Receipt Details. When I choose a month, for example OCT under Statement Month,…
- Answered
-
Script problem.
do as server let me := this; for i in select 'Task templates' do let new := (create Tasks); new.( void; Status := 1; 'N1 Main Table' := me; 'Assigned Date' := date(year(me.'Start date'), month(me.…
- Answered
-
Not Exit from a loop
Hi to all! i have got this loop on a formula: let images := response.result.images; let coverimageLink := ""; let foundImage := false; for i in images do if (i.type = "primary" or i.…
- Answered
-
Beginner scripting resources?
I’m trying to teach myself about scripting commands. But I’m having trouble finding full, complete answers. For example, the Switch Statement. In the Ninox Intermediate Tutorial #3, Switch Statement,…
- Answered
-
Need Formula on Chart
I have a multiple selection dynamic let uni := unique(((select Gastos) order by Categorias).text(Categorias)); for i in uni do first((select Gastos)[text(Categorias) = i]) end Copy I need the Formula…
- Answered
-
Yes/No function
Hi, I want to change my multiple choice function to several yes/no functions. All works well but one choice. I want to use a yes/no function (named OHW) to indicate that a client is no longer an…
- Answered
-
Create Record Button in a Table > Create R. to a Subtable
Hi, I thougt this would be easy, an that I have done similar before, but now I'm stuck. I Have a table "Placenames" , with a Subtable "Farms_Places", whitch have all the sub-places under the main…
- Answered
-
Formula to sort month
@Fred Hi Fred. Need to sort the graphic from Jan to Dec, the data is in the Gastos table (the gray data). I try this but don't work select Gastos order by month(this.Mes)
- Answered
-
Problem with this formula
sum((select Expenses).'Amount Spent' where Categories = "Gas") sum((select Expenses).'Amount Spent' where text(Categories) = 8) Where Categories is a Choice field.
- Answered
-
Ninox tutorials stopped working?
I'm brand new so had been looking at tutorials here (on this web site). But now, when I select a specific course to view, all I get is a. blank white screen, no window to play the video.…
- Answered
-
Really dumb .... just want to add 2 number fields together and display total in a 3rd field.
I must be an incomplete moron but I've been struggling to create a very simple database that sums two number entry fields and displays the total in another field.…
- Answered
-
Click on button in Ninox to view Gmails
Hi everyone, I'm new to Ninox so forgive me for asking this question. When I'm logged into Ninox and also my Gmail account, I'm wanting to click on a button that searches for all emails related to a…
- Answered
-
Auto-populate Music Library Fields
I am working on databasing all of my sheet music and would like to auto-populate a field on one table with information from two other tables if possible.…
- Answered
-
Get count of chosen values from different table
Hello, The formula below counts the number of records in the table Timetable where the choice field Jim has been chosen the value "norm" (it works). count(select Timetable where text(Jim) = "norm")…
- Answered
-
double click in a cell puzzle.
Can someone enlighten me please. double click to edit a cell content is not possible in all cases. Sometimes when I try the form slides in from the right on the first click.…
- Answered
-
Total of the selected option
let vRaiting := "minRt: " + text('min. Raiting') + "| maxRt: " + text('max. Raiting'); let vRtMin := 'min. Raiting'; let vRtMax := 'max. Raiting'; let myFilter := trim(this.…
- Answered
-
Updating related fields
Hi there. I am new to Ninox and am trying to build an app for my business. We do boat charters. I don't even know if this is possible. I have a tabel "Stocklist".…
- Answered
-
Warning / alert triangle on Table name
Hi - I have just noticed that a couple of Tables have small warning triangle symbols over their names / icons in Edit mode. As far as I can see, there are no functional problems.…
- Answered
-
Conditional Formatting Advice Please
The screenshot here shows I having grouping selected and a count #. For sake of clarity, I would like to emphasize the #Count so that it is more prominent for the reader when records are exported as…
- Answered
-
Search by Artist ? HTML
Is there a way to search by Artist in this table in HTML. ? The Code is let vRaiting := "minRt: " + text('min. Raiting') + "| maxRt: " + text('max. Raiting'); let vRtMin := 'min.…
- Answered
-
Creating a Script Similar to Excel NETWORKDAYS
So, I'm thinking of replacing my workdays formulas with something similar to excel's networkdays function. What I would need it to do, is combine the workdays function and then reference a Table I…
- Answered
-
Add space between emails in string
Dear all, I'm currently trying to create a mail (using mailto: ... ) to multiple email addresses within one mail. Currently all relevant mail addresses are in a string.…
- Answered
Answer questions and share your knowledge