Formula to Count item per Week

Hi I Need a Formula to count the amount of 'Rev A' per Week Example Week 15 - 3 Week 16 - 1

• Answered

count lines of text

Formula to count the lines of text in a text field? e.g. April is the cruellest month, breeding Lilacs out of the dead land, mixing Memory and desire, stirring Dull roots with spring rain. to yield 4

• Answered

E-mail Gmail

Hi ! Is it possible to automate or send an email with a button but without going through the default Ninox system? I would like to be able to send emails from Gmail webmail because I prefer to use my…

convert formula to NINOX LANGUAGE

HOW CAN I GET THIS FUNCTION WORKING IN NINOX? I am trying to have a table that keeps the working hours for each day of the week, and a holiday table to store closed dates ,…

BULK Edit values with a button

I have the following Q: I have a table with yes/no field. So every record in that table has either yes or no. I sometimes need to reset all records to "no".…

Proper Syntax for counting any combination in a multiple choice field that includes at least one selection.

I have been trying all sorts of syntax along with using +, and, or to no avail. Here is my formula. let xStart := 'Start Date'; let xEnd := 'End Date'; count((select Chronos)['Date + Time' >= xStart…

Unable to Archive or Duplicate

When creating an archive on my ipad pro, iPadOS 16.4.1(a), ninox stalls and then shuts down. This also occurs when tying to duplicate. If I create a new,…

Sum of values of a field of a specific date

I'm looking (and can't find) a solution to calculate the grand total of a field of a given date... No problem illustrating this with a view, but that's no use to me since I need it as a value in a…

• Answered

SELECT function

Hello, which is the best way to identify records if the table as a below relation: Table A link to table B, and table B link to table C. I need to count records in table C based on a filter related…

Avoid deleting a record

Hi, I'm working on my first database, and I need your help about the record. What I want is avoiding accidental delete a record wherever I am. It means that,…

No plot null values

I need the chart to NOT plot the null values in % Acumulada Real. One year waiting fix this problem.

• Answered

Creating a Record from a Button Sending an Email

Hi, I've set up buttons to send emails, but I need to keep a record of the emails sent. How can I get this same button to create a record in a new table for storing these emails?

Force trigger after update with mass update

I have a table called "Bancos" where I import a CSV file with the bank statement. As I wasn't sure on how to, once imported all records, create a new entry on a different table "Entradas/Salidas"…

• Answered

print view

I should be opening a view in a report, can anyone help me?

Variable in a text field

Is it possible to add a variable in a text field (multiline) then, to resume this text in a field of formula and that the variables are replaced by data of other fields? For example,…

• Answered

Incorrectly calculated Week

@Fred On Choice (Dynamic ) I use the formula let l := '1N_Control Issues'; l[let t := Week; first(l[Week = t]) = this] order by Week Copy And on the View I use the formula let s :…

• Answered

Problem with if and else in a loop

Hey, i got a problem with my code: do as server for i in select Leads do if i.Status = 2 then for j in select Kunden do if i.Nachname = j.Nachname then i.…

Force a update to trigger all records.

I updated my database to better automate a few things. However, one of the updates included creating a new field with a trigger option. It uses data already in each record,…

Where is the problem ?

On line 15 had a problem. The 'Real 3' is a field Date

• Answered

Autofill charts

Hi ! I have a table named "Activités" in which I add records that are appointments with my clients. Each appointment corresponds to a service which is selected from an N:…

Printing in a grid with photos

I have a student enrollment database, with student details and photo etc... I would like to be able to print out a grid of their portraits with name , level and age.…

RTF -> .rtf File or Print output

I have formatted text in one RTF field. Question for the local geniuses: What is the easiest way to output that file and retain all formatting (HTML)?