Automatic updated field with date for each time I update something

Hi All, I'm totally green with ninox, but I really feel I have tried everything I have read on the forum on how to make field that automatically updates with the date of today each time I for…

Problem with unique() function

Hi all, I'm having trouble making the unique() function work. I'm simply writing unique('Project Codes'.Currency) in my formula field. If the values selected are all the same (e.g.…

Initials

How can I get every first letter in each word in a field, for example, initial a name? Let say the name, John F Kennedy, I want it JFK. Thanks.

I can't sum just one month on column, i need sum month by month expenses

First of all I am not a programmer. I need to divide my expenses by month and by year, i hav it by yer, I have tried to use formulas but it is impossible for me it is like speaking in code.…

formulas in print view

I have a series of formulas to calculate the quantities of various combinations of variables. However they are not being printed accurately on my print view.…

My actual plan is not available anymore but i can't do the uploading

My actual plan is not available anymore but i can't do the uploading

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

question

testing question

Hosed table

I needed to change a field from Choice to Dynamic Choice. So I created the new DC field and set up the correct data. Deleted the original static Choice and renamed the new DC one to the same name as…

other software

Does anyone use a cloud based RAD database other than Ninox - if so what? and how does it compare? ie like Ninox - can you have forms over the tables. Can it be multi user.…

Referenced field name shows up twice

We generated a product name in database a. Then we referenced this field in database b in a combobox. For whatever reason, the refenced name contains the product name twice.…

Select from array

I want a choice type field, constructed from some of the values in another table. Ah, use a Dynamic Choice Field and filter that I hear you say, but the trouble is that the original table has many…

Many-to-Many relation: how to create lists for printing

Hi all, topic "Many-to-Many Tables for Printing": I'm using successfully the recommended approach of following threads to model many-to-many (m:n) relationships between two tables: https://ninox.…

Verknüpfung einschränken

Hallo miteinander, ich komme beim Einschränken einer Verknüpfung nicht weiter. Kann mir jemand helfen? - es gibt eine Tabelle "Produkte" und eine Untertabelle "Kundenvarianten",…

Control which fields appear on calendar events?

How can I stop a field appearing in the title of a calendar event? The event seems to include all fields (except number fields and the date itself) and it concatenates these with a space.…

Labels in different languages

Well there it is. I now have the need to present views and forms in two different languages to a customer. This is a go or no go thing for him. I cannot see any other solution than to have to…

• Answered

Table context

Let's say I have a child table with 2 parent tables. When acessing the child table through either of the parents (as opposed to directly from the table list on the LHS) in order to e.g.…

Formula Help

Hello, I've been trying to get a forumula to work but have not yet had any success. I have a table that shows information on proposals made for the project,…

Haywire formulas while duplicating a table

Hi, I am trying to duplicate a table that contains several formula fields with references to other fields in the same table. Unfortunately in the duplicated table all formulas end up pointing to the…

Triggering importFile() without a button? to automate updating of a shareFile()

Is this possible? My goal is to use a shareFile() Link, but the document will update daily. So I am trying to import the document to an image/file field at regular intervals so that the URL is always…

Did anybody else experience some Ninox date-field weirdness over the last couple of days?

A couple of days ago I noticed that some of my code in Ninox was acting wonky. Specifically, some of my date-field comparisons were coming back as null even though the dates being compared were (or…

Avoiding duplication in a field

Dear all, I hope you're well. I have a field to which I assign a unique value for each record. If this field has XYZ as value, no other field in the database should also have XYZ.…

Printing Records of A Table

Hi, I have 8 records in my table. When I try to print, it only shows the first 6 records. What have I done wrong? How can I fix it? Thank you. Kevin