-
Spreadsheet templates
I need to create two databases, one for product inventory control and the other for accounts payable and receivable. Would anyone help me with a model? Lucidio
-
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 choose the lowest of two fields, that are prices of the same item from different suppliers and return…
-
Mac App Crashing
I have the current version of Ninox and Mac OSX 10.15.3. Ninox has been crashing a lot lately. Without warning or any beachball spinning, it is just gone. No crash report to sent.…
-
Can I control the llok of the table accuaretely?
I am a newbie and have watched the videos from NINOXUS on YouTube. But how can I make this really and truly WYSIWYG?
-
Generate list of unique choices from linked table
Hi, I have table one with these records: table 1 a a a b b I'd like to create a field in table 2 that allows users to choose one of the options that shows up in table 1,…
-
Not sure what the question would be but it concerns a time field.
First of all, forgive me if this is simple, I am six hours into this wonderful software, I am, as they say, a newbie! I am creating a quoting database for my comapny and I want a field that,…
-
Script with summation for a given range date?
Hi guys! How can I get, inside a script, the summation for a given range date? This is my case: 1. I have a table “INCOME” with all my records for invoices. There is a “TOTAL” field 2.…
-
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.…