Remove comma from dmc-print layout

I have a dmc-field which filters the 'Name' field from the 'Employees' table. By inserting the dmc-field in the print layout, each "Name" field is divided by a comma.…

• Answered

Badges on TABS

@Jacques TUR and others. Using Ninext is it possible to add a badge to a TAB? In the screenshot below you can see I have a TAB to view the notes related to a particular Location.…

Button. On click - No empty fields and if there’s a dup confirm before adding record via dialog

I’m trying to make sure all the important fields are filled out when adding new record and if such record already exists to ask for confirmation before proceeding.…

Check box in list view?

Hi! I am currently trying to migrate from FileMaker to Ninox. I am still rather a beginner. In file maker I had check boxes in each row off the table in list view.…

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

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,…

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