-
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,…
-
Start daily counter from dropdown choice
Im trying to get my 'countdown' field to start counting days once I select 'Sent' from my dropdown menu. Basically once I send out an invoice I want it to start counting the days that pass,…
-
is it possible to include all item in a filter?
I have: let Cl := number(client.ID) (select Achats)[ number(Contact.ID) = Cl and other things....] if I have a contact selected in the client field, it s ok but if the field is empty, it wont work.…
-
Mixed number/date formula
I have a formula that doesn't work, i suspect because it refers to both number and date fields and isn't expressed the right way. It gives results in a time format, always 0:00.…
-
I’ve got this code from a button on a form but get error “not a data field” on the last line. Any help appreciated.
let DD := i.'Next One'; while DD <= today() do let DD := DD+28 endi.'Next One' := DD
-
How to setup a global relation?
Does Ninox support use of a global relation, with the left side of the relation being a global field or a variable, so the relation can be set by assigning a key value to the global field or variable?
-
Is is possible to get the actual day from a date?
I would like to be able to get the actual day from a date such as Monday , Tuesday. The only thing info i could find was day(date) but this returns a number. Is this possible?
-
Converting leads to customer
If I have a table called TBL_Leads with very basic prospect information (name and phone). Is it possible to create another table called TBL_Customers where I can move the fields from TBL_Leads that…
-
How to make a smaller save size with an archived database?
I needed to split tables off of an original database, so to do this I took the original database, made a backup, and then imported the archive using a different name and then deleted the tables I…
Answer questions and share your knowledge