-
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?
-
Export selection of data
How is it possible to export a selection of data?
-
Can I change the format of the Date
Can I change the format of the Date when printing to a different format as the system default? Thank you.
-
How can I lock the data
I added a new YES/NO. When I enter the data, how to set the data to be automatically locked after pressing YES. Thank you.