Dynamic value formula for choice field

I have a table called “contacts”. One of the fields in that table is called “group” and that is a choice field. One of the choices is called “Guests”. I have another table called “entertainment”.…

Printing?

Seems so hard to get a print layout. Is there a way to create a form that can be used to print? I see either a list print view, or a one page per record print view.

List of attachments in the sendEmail() function

Hi I have the following problem - I am trying to send a list of attachments in the sendEmail() function. Only unfortunately the files in the email can't be loaded.…

Need transfer only the Approved.

I am using this table for the documents that will be incorporated into the main Documents table as scope changes, will not be included in the main table until the scope change is approved by the…

• Answered

Storage for small bar

Hello I need a simple initial database for a warehouse in a bar. please share if there is a finished version, no matter how perfect it is, I will finalize it. Thanks for your help

Subscription and payment ER example

Hello, I'm working on a database which required to handle subscription and payment to annual fee and events. Right now, I'm still design this senario in a ER chart. But, I've some doubts.…

Server error??

hey, we have a company server and nobody can seem to connect to Ninox today and today is a German holiday. is there anything at all that can be done???

Transfer all info on table to another table (script don't work)

let me := this; let myA := first(select 'wbs by Documents' where 'Name Document' like me.'Name Document'); if myA = null then if dialog(" Waiting Answer", " Document NOT found.…

• Answered

OpenURL opening multiple webpages.

Hello, I had a question regarding the OpenURL function. This is the code I am running and I think it should open 10 webpages, but it is only opening 1. What is wrong? for i in range(0,…

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

Is it possible to link automatically (via a function) fields in two tables that contain the same text?

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

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…