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)?

Adapt fórmula to new Structure.

let check := dialog(" Warning ", " ¿Confirm the Update Transmittal ? ", ["Yes", "No"]); if check = "Yes" then for loop2 in (select 'wbs by Documents')['Name Document'] do let F3 := if loop2.…

• Answered

delete records in dmcf with a button

Hello Ninox Community, As stated already in the title I would like to delete records chosen in a dynamic multiple choice field. I know that I can deselect them too,…

• Answered

Split Records

Hi Guys, I have attached a sample database called CONDOS. It has a subtable called JOB with a parent SERVICE. The Condos have multiple owners. Each owner has a percentage given in the OWNER table.…

• Answered

Clear select field

Hi ! I have a selection field named "Abonnement ou pack prépayé" which is a mandatory field and which is only displayed if another yes/no field named "Prestation vendue en forfait" has a true value.…

• Answered