-
Id reset
How do I reset the Id column to zero after deleting all records
-
Boolean If/then/else help needed
I created a simple Boolean if X & Y then A * B else end (sample code below). The idea is for us at our school to only enter date ranges and then have the contribution fees to run the school…
-
I've constructed a database to track revenue and expenses on a number of individual funds. The table titled funds has the general info which is stored in a child called balances and then a grand child called revenue. Each fund has an annual record. I've set up a button to begin a new year and it does start the new balance. It creates a revenue record but connect back to the balance child. Here's the code. Any thoughts?
let currentRec := this;let Nyear := last(Balances.Year) + 1;let Nbeg := last(Balances.'Temp. Restricted-Total');let Nperm := last(Balances.'Perm. Restricted-Total');let i := (create Balances);i.…
-
Get Calsulated Fields From API
Hello! I use your API to analyze data in Tableau, but when uploading data from a table, I can only get the original fields, but I can not get the data from the calculated fields.…
-
Ninox webminar in North America
I have been following Andy Marks's webinars on Nioxus.com for over a year now, and I have learned plenty about Ninox functions, scripts, etc. These one-hour webinars are available every Thursday at…
-
Why not a function who duplicate a table??
Its even more useful the dublicate database.Many times I have two or three tables who have the same fields, and I also want them to have exactly the same look.…
-
Why does hitting return or escape cause the computer to beep? It should simply register the value you've entered, or leave the field (in the latter case).
This standard in every application in the known universe. Why does Ninox feel the need to not follow this convention????? Soooooooooooo annoying.
-
Accidentally hid all columns in linked table view
Hi, I have a table reference, and when I click on the field for that table (in form view) it takes me to a blank page (with the search bar at the top but no columns),…
-
How to modify the view of the file .txt created with createTextFile ?
createTextFile(this, 'Name' + Surname, "prova.txt") This is the formula I am using right now but in the txt file I will see the information like: Mario Rossi I need to make the two information one…
-
Maybe linked databses?
I'm making progress since me previous question, and found the free trial - thank you! I see the data from my embedded tables in something like sub-databases? I'm not sure what they're called.…
-
Sample Ninox integrations with Quickbooks online
Are there any sample Ninox Cloud databases that demonstrate integration of Ninox with Quickbooks online? I am interested in syncing contact information,…
-
How to automatically fill in the field "user" data of the user who created the record
Hi, How to automatically fill in the field "user" data of the user who created the record
-
Global search with a button
Is it possible to start a global search with a button from a Form View?
-
age(some_date) function not working on Console
age(anydate) works when used on a formula field. But does not work on the console!!! I'm getting the following message: Function is not defined: age([date]) at line 2,…
-
Attachment locally or in a cloud?
I have 45 licences of Ninox and went my students used the attachment button they only store there files locally. It is normal? so when I check in the database I don't see the attachment
-
How to stop in-line editing on the Table View? Anyone knows?
How to stop in-line editing on the Table View? Anyone knows?
-
"while" vs "for" statements in Console
The following code:let total := 0;for x from 1 to 5 do total := total + 1; total;end produces the following ouput:1234 For each cicle total is returned.…
-
Getting location field by calculation
I'm trying to populate a location field with given lat/long coordinates. The table has 2 fields with the lat/long coordinates: for a in select 'table' do; a.LocationField:=location(a.name, a.lat, a.…
-
How deep can I go in a select statement
Hi all I'm a newbie transistioning from FM and trying to wrap my head around how Ninox does things. First I have the following tables: Riders Results Teams Team Membership I'm working in Team…
-
Contact Database
Hi, I have a contact database and would like to create a table that records attendance at meetings. For example, table might be called meetings, when you launch it offers to create a meeting and…
-
select do' coding issue
I would be very grateful for somebody's help with this little issue... I am trying to set a field's value (i.e. the 'Price' field) by using a set of statements from 'switch do' coding,…
-
scope of variables
Can someone please explain how/where one would setup variables for a database that are 'global' ? thanks
-
Map
hello, is it possible to display several customers on the geographic map and assign them flags (done, in progress ...)? Thank you for your answers.
-
How to autocomplete a text field?
How can i autotomplete a text field with the information already entered?, Thanks
-
Technical Question/ How to choose the lowest value from several fields in a record?
Hi there- I am new to Ninox and was wondering if anyone had any bright ideas- I basically want to just choose the lowest of three fields that are prices of the same item form different suppliers and…