-
Get Line Items From One Table And Add Them To Another On Button Click
Hi, I have a table that contains Orders and in that table is a sub-table Pricing which has to fields - Description and Price.I have created another table named Invoices with a sub-table named Inv…
-
Variable Scope / Empty fields
Hi I am using this code in a "Save" button to avoid empty fields in a record: let MyError := 0; if Nombre = null thendialog("Attention", " ""Nombre"" puedes estar vacío", ["OK"]); let MyError :…
-
Email send/sent help needed
First question--where can I see the emails that send out of Ninox? I need to be able to reference/see/track invoices that are sent and to who. Is there a way to cc myself on the emails? Thank you,
-
Products by date
I'm struggling to make a very simple stuff, I think... Hope someone can help me.. I made a table with my products (product name, price, category) and I need to have another table with the products…
-
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.…
-
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…
-
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.…
-
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
-
"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…
Answer questions and share your knowledge