-
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…
-
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…
-
For large record sets, how many records does Ninox pull at a time?
For large record sets how many records does Ninox pull at a time, and what triggers the pulling of the next group of records?
-
How to modify or totally remove the global find button?
Can the table columns that appear following a global find be altered? If not, can the global find button either be totally removed or changed to only perform finds on the current table?
-
Changing the way date is displayed
Hi, Overall, I love Ninox, but I have spent an entire morning trying to solve what should be a simple problem, including reading dozens of forum posts and the manual.…
-
Why does Ninox 'remember' deleted Ids?
If i have a new table with 10 rows, Id numbers will go from 1-10. However if i delete the last three rows (8,9 and 10), then create a new row, the Id number of the new row is 11.…
-
PROBLEM WITH DATA UPLOAD
I have a DATA table that tracks about 20 indices by nation and region using numerical fields. I update it by adjusting the data in an Excel file, saving it as a comma-separated csv,…
-
Date manipulation
Hi there, I'm new to ninox and i trying to automatically calcute a date after manually entering a number of month and displaying that information in an additional field.…
-
Printing a document
When I select print it tries to send the document as a PDF file to Pages which can not read it. Therefore, I can't print is there a way around this?