How to accumulate percentages for multiple choices

Summing record

I am tring to create summing column base on another column. Let's say Column A will have numerical vaules, now Column B will have sum of previous record from Column B plus current record of Culomn A.…

can i export images?

Can I export Images?

How does barcode scan function work ?

i tried to use it with iphone and ipad app, but doesn't work. Could i use it with browser app?

Global image signature field

How can the contents of a image signature field be made global, so the same image appears across all records in a table, but is only saved once?

How does Ninox decide what columns to show when performing a global search?

How does Ninox decide which columns to show for each table and the order of the columns, when a user does a global search?

records

how to prevent duplicates records

Android app

Questions about Android app: 1) Is it possible to use barcode scanner? 2) How does one access the Find(Global Search)?

Button action to switch from one table form to another table form?

How can I create a button action that switches the user from the current form to a form in a different table? If there is not already a built in function for this,…

select and sum only if and if

1)how can i sum values in sub table that are between start date and end date in parent table? in parent table i have name , start date , end date. in sub table i have date , amount.…

Formula not working - number doesn't increase?

I have this formula working for my orders and quotes table, but when I try to adjust it for BLA's each records BLA Number is the same let myyear := format(today(), "YY");let myBLANr :…

Different data between computers on the same icloud account

I have desktop and macbook. I usually input data from the desktop but when not at home I use the laptop. This morning I noticing that some of the datas are not synchronized between them.…

Calculate records with dropdown value

Cant seem to get my if statements working. I just want to sum up the 'Total' field of my records that have the dropdown (Status) set to 'Sent'. Any help appreciated!

Has anybody already fetched invoices from Getmyinvoices or invoicefetcher and transferred them to Ninox via API???

I want the invoices to be placed in a table in a way that both the invoice data and the invoice document itself (pdf) make up the data record. Greets, Thomas Beck

How to pass field name to a function that returns field value?

function getFieldValue() do record(tableName,1).'Contact Person'end The above function returns the value of the "Contact Person" field. How can I change the function so it will return the value of…

iCal sync issue

Hi, I'm using the iPhone version of Ninox, and have an appointment field, which syncs with iCal. Appointments appear in my calendar just fine, with iCal showing the length of the appointment…

Barcode scan

I am using a bar code reader to insert a number into a field I would like to add a new record on each read. Using the Create table command My problem is that once it is created I would like to go to…

Problems with conditional display of fields in food ingredients database

I have checked the synthax over and over but can't make this work... I want to create categories and sub-categories but, in order not to crowd the input screen,…

Tenant and sub-tenant

Hello, I have a trooble for modelization a schema. In fact i have a table tenant and in this table i have record that is sub-tenant. But how can recognize the record tenant or sub-tenant?…

How can I apply a constraint on all results : (select table) [ xxxxx ] ?

I need to have a constraint but to be applied on multiple results. number(b.ID) != (select Achats)[number(Atelier.ID) = number(a.Atelier.ID)].Contact.ID I wish to exclude all contact ID that…

I need to run a formula on each field of a table...

I have a table with some ''class'' and each ''class'' contain some contact. I need to set a constraint that prevent the selection of a contact already in the actual ''class''.…

Clear History / Rebuild Index / Rebuild Thumbnails

This may be a bit of a stupid question, but I'm new to databases. I'm trying to understand exactly what happens when each of these actions are performed.…

Format Date

I have a Date field, I am trying to format that date field to display in MM/DD/YYYY. I have had many unsuccessful attempts in doing so. How do I do this?…

How to store a record id in another field?

I have a separate table named GV for storing globals session variables. It works great with one exception; it fails when I attempt to store a record id like this: record(GV,1).…

Help with formula

I'm moving from a spreadsheet to Ninox, so have to translate a lot of the formulas into Ninox. So far, with some help from Joerg, i've been able to tackle quite a few,…