-
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…
-
Ideas & Suggestions / The Red "You have modified the application" element should not have two buttons
The Red "You have modified the application" has two buttons for saving and reverting, however, it appears to the user as one big red button. This violates common interface standards.…
-
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…
-
Ability to save import settings for a csv file
Say for instance I have an inventory file that I wish to import every day it would be useful to be able to load an existing import configuration that you could save the first time you set it up.…
-
Two Wishes for Choice and Multiple Choice Fields
1) In form view, I wish there was "Add Value" command at the top or bottom of the list so I could quickly add to the list and sort the list. As it is now there are far too many steps for adding vales…
-
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.…
-
More options for the View layout element
When you click on a record in the View layout element, it slides a duplicate Form View in with that record selected. It would be useful to be able have the option to use openTable(tableName,…
-
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…