Automatic table cleaning after one year

in my database there is a table that collects information about discounts. But they are valid only for a year. How to make sure that all information in the table is deleted after a some time,…

• Answered

How do I copy line breaks from a multi line textbox or a rich text field into an email?

Hi all, I need to be able to sent mass mailings to all relations/clients. For this purpose I have created a form with a text field "subject" and a multi line text field "body".…

deleted database

How to recover deleted database?

Where are my formulas ?

Hi I can't no more see my formulas, only my columns ! How can I retrieve it ? Thanks

Trigger on Update not triggering

I want to automatically create some child records in 2 child tables. In the parent table, Trigger on Create successfully creates the required child records in one child table (actually it duplicates…

hide and seek

Well, not seek really. I have always thought the way that Ninox hides the parent, when accessing the child through the parent is really neat. So e.g., click on a child line to open that child in the…

Image link

I have an image field and would like to create another automatic formula field with the image field link.Anyone able to do it?

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