Problem with multi-line rich text fields

I'm experiencing a problem when importing data from a csv file into a rich field. The import process combines all lines in a field into one line. The same thing happens if using Update Multiple…

Best incremental Invoice formula

Looking for the best Invoice incremental script. I have been using the Trigger on Create let c:=cnt(select 'Invoices'); 'Invoice Number':= "INV-" + format (c,"0000"); New Script; New Script;…

I would like to use my Id number in the table can i?

automatic time/date triggers. how to change the value of a field automatically when it passes a certain date or time?

if Date > todat() then choice := 2; end

Selecting Multiple Records In A Reference Field

I'm willing to say...I need help. I am trying to create a database to track donations made for a post-graduation party we hold each year. The Microsoft Access file (created by someone else) no longer…

One Other Question....

Interested in getting feed back on this situation. I have Invoices that require lots of detailed information and I have invoives that require one line. The invoiced items are not linked back to a…

extracto bancario

Hola amigos No se como hacer en Ninox una tabla con los siguientes campos FECHA - CUENTA - CONCEPTO - DEBE - HABER - SALDO El saldo es mi problemas, imagino que será algo sencillo,…

Cant place image galery in right position

https://gyazo.com/1fbed0d569602ef1d9a621cb369cdfd1 I want it on the right side (and all switch boxes on left) how?

Problems with conditional style

Problems with conditional style I use the conditional style with a ruler in a column and I noticed that after a number of searches, apparently it doesn't work anymore.…

email send Button mit If Anweisungen in der email

Liebes Forum, ich möchte gerne mit einem Button automatisierte Emails versenden. Das Problem ist, dass ich bei der Anrede, if Anweisungen verwenden möchte.…

Search for a name in several fields

Hi Could someone tell me way to search for words in multiple fields (multiple columns) Example : in a database I have the same name "John Miles" which is in column 2, 4, 6, 8,…

Show records from a table for 1 week period?

I apologise if something like this has already been asked and answered. I have a table 'Appointments' in which i have a date/time field to create a new appointment.…

Help with syncing issue.

Hi, l have 3 team members with me being the owner making 4 in total. 3 out of the four are syncing to the cloud and are working correctly although one is formatting dates differently to the others at…

To import data into a table

Hi I would like to import data into a table to add some names in a column.This data is in another table.I can't import this data properly.Could someone please explain it to me?Thank you.

Help for a script to search text

Hi, I would like to search for the words "Ara" and "Penguin" in my database In the filter box at the top of the column I've tried: Like "Ara" or like "Penguin" Does not work = "Ara" or "Penguin Does…

Date field question

Hi, i wonder if it is possible to fill the year field without day/month. I am adding my musical albums in a database and i want to sort them by year. But for most of them the day/month of release is…

How delete a link between to table ?

Hello, I have two table in my DB Mangas, Series and Tomes. Tomes is linked to Series in composition. When I select a bad Serie for a Tome, how to choose another Serie instead of the one selected…

Import types of fields.

Is there a way to tell ninox which type of field is each one of the imported fields from a .CSV file. Or at least change field type after importing? Thanks in advance, Germán

Need help with this problem......Script to bring multiple record to onto one form.

I need to make an order form that brings all data together, It could be an add record to a form script in a button .I do not know how to bring multiple records of data from a table that has 12 feilds…

Is the appointment date in a Season

Hi, I have a table with seasons. To make it simple, two records (without year). startdate = '01/01 'enddate = '30/03 'season = 'High Season'price = $100 startdate = '24/12 'enddate = '27/12 'season =…

To search for names in colored characters ?

Hi Is there a way to search for names in colored characters in Ninox ? And to sort names in colored characters ? Thanks

Field type changing

Is there solution changing the field type later?

Template ?

how to make a go to statement : for example i have a an offer template , with 5 items , showing (qty , descrption , unit price nad total ) fpr each . o o want to convert the offer in to an invoice ,…

how to make sum of colomn ?

Bonsoir, Je voudrais faire la somme des chiffres d'une colonne Comment je peux faire Par exemple j'ai 70 ligne avec 48€ et je voudrais savoir le toal, come je peux faire dans la formule ?…