-
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 ,…
-
How to specify a default date?
I'm experimenting with a db to help schedule tasks for the coming gardening season. Many of the fields will be calculated in reference to our local "last frost date".…
- Answered
-
Multi-Choice (Dynamic) Field
Ahhh, Multi-Choice (Dynamic).... Truly a wild animal. I have a dynamic multi choice field to select multiple records in a table, staff. How do I get the Staff.…
- Answered
-
Formula fields not visible to other users
I am attempting to create a dashboard and use a lot of formula fields to display data. However, when any other team member views the form, the fields are not showing up.…
-
after updating to 3.6 from mac appstore, white window.
Downloaded the 3.6 update from the mac appstore. opened the app on a mac with Big Sur, App showes a white screen. Installed Ninox on a mac mini with Monterey, same white screen.…
-
How do I join two different conditions in one statement (and/or) thank you
How do I join two different conditions in one statement (and/or) thank you
-
Nesting 'if'
Maybe if I knew which script launguage ninox uses I'd have better luck with Google. I think I want to nest an if Following on from my previous if 'Year Code'.…
-
mise à jour du plan
Bonjour, Je n'arrive pas mettre à jour le plan dans NINOX. LE message ne s'enlève pas et je ne sais pas comment faire pour régler le problème
-
Two fields sum
I have two fields and in the third it shows me the sum of these two fields. They must be summed if one of them is not equal to zero. Can anyone tell me the formula please
-
Select using []
I have two related tables Projects and Work Reports. In the scrren shot below you can see Projects (formula) in the Projects form and below the View of the related Work Reports.…
-
Appointment function
I wonder why this Formula shows incorrect data. appointment('From Date' + 'From Time', 'To Date' + 'To Time') What am I doing wrong?
-
gantt as pdf
Hello, We are trying to use ninox for timetables on our buliding sites. Generally they should look like gantt diagrams, with milestones. Does ninox have a pan for getting gantt on layouts and export…
-
Print a 'View' page element
Hi, I need to include a selection of images from a subtable in a print layout.. I can do that, but I need to use the 'unique' function, as some of the images are repeated but I need to only show each…
-
Conditional format Combo box
I have an Invoice Table with a choice field "Status" which has three options Outstanding, Paid and Cancelled. Is there any way to change the background colour using something like:…
-
Filter a view by Id
Hi Again, We need a little help filtering a view. The view is in an appointment table and selects/views the invoice table lines. I’m trying to filter only the lines associated with the current…
-
Warning message for expiring TO DO
I would like to have a warning message when the "TO DO" are about to expire and when they are expired. So I tried to build this formula: if days(Data, today()) > 0 and 'Stato TO DO' !…
-
Payment of several unpaid invoices
Hello everyone, I have something difficult (for me at least), but I'm not afraid of you, I trust you :-) I have built a database of my finances. All good so far,…
- Answered
-
Trigger after update & Alert anomaly
Community - I developed a database in the Mac app. The database is deployed on the web. There are 2 fields in a table that have code entered into the 'Trigger after update field'.…
-
Distribute dates between two others days.
@Fred I have the fields Plan 1 to Plan 5 with the following milestones 10%,25%,70%,90% and 100% in the Plan 1 date field I have the start date 8/02/2024 and in the Plan 5 date field I have the date…
- Answered
-
About the copy problem
I tried to copy the content of "copy" to "copy here", but they are not complete copies. Where is the problem with my code? Thank you for your reply!
- 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
-
Cannot create more Forms!! - Cloud version
I have had this happen before and I finally figured out what it was but now it's happened again and I'm stuck. I am unable to create more forms. Usually when you click the + to create a Kanban or…
- Answered
-
Column Filter Date?
My table's column is grabbing dates from a subtable. How do I filter the results to show a specific date only? The results I get are for the date I want plus all of the dates of records with that…
-
Define start of fiscal year
I can use the function yearweek() to define the week number within the year, but that does not sync with my employer’s fiscal year, which begins on the first Monday of the new year.…
- Answered
Answer questions and share your knowledge