Skip to main content

Ninox-Documentation

Nick

Nick

Greece

699
29
1

Joined: Wed Jan 01 00:00:00 UTC 2014

My Posts

Latest Posts

Re: I can't edit the number of pieces in my inventory when I add a new item
You have to furnish more info... Is this 'number of pieces' field a number field or something else? Is this field a Starting Qty Balance of the Item (Items already in your stock)? etc
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Trying to write basic mathematical formula for Inventory
Hi, the normal way to count Inventory Items is: Remaining Stock = UnitsInStock + sum(PurchaseInvoice.Supplied) - sum(SalesInvoice.Sold) Please give us more details to help you out. Nick
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Cascade Fields
I think @wynand talking about Edit Fields screen...
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Two referenced fields in one field and filtering contacts from one company
If I undertand you correcltly look here: https://ninoxdb.de/en/manual/tables/table-references-and-relations and the chapter: Constraints
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Two referenced fields in one field and filtering contacts from one company
The formula sould be: 'First Name' + " " + 'Last Name'
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Filter a View to show only Top 5
Thanks Sean, I think we'll find a workaround in the end...
- Nick
- 5 yrs ago
- Get help
- Reported - view
Filter a View to show only Top 5

I have a View to display Grouped and Summarized data from another table. It's possible to filter the View to display only the Top-5 records (based on the Summary field)?
- Nick
- 5 yrs ago
- 2replies
- 1539
- Get help
Re: Can I install Ninox on two computers?
Yes you can, just install it from the App Store.
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: How to use the "View" element
Sorry... should be: let t := today(); select Invoices where InvoiceDate = t
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: How to use the "View" element
Hi David, let's say you have a table Invoices and you you want a View for today Invoices. Now use this code: let t := t(today());select Invoices where InvoiceDate = t In the field edit screen you can…
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Can I move items from one table to another?
If you still want to move data, use this code behind a button: let reply := dialog("", "Would you like to continue moving this record to Table B", ["Yes", "No"]); if reply = "Yes" then let tempB :…
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Integrate with web page
@Alan, I think it's better to create a new thread about this subject.
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Where to write a global function
@Mconneen... what is the code to call the above function (getZScoreText) in a formula?
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Subtable - ordering system
Try this code, the View will not display the Items list until you type in 'Search Article' and tab to next field. let t := this;if 'Search Article' != null then(select '3_Article)['Article No.…
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Subtable - ordering system
@S Moore I use the above model in my Orders db. Here is the link to download "Order with Search" db: https://www.dropbox.com/s/whpk8udmwgyktj2/Order%20with%20Search.ninox?dl=0 Enjoy
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Linking tables
If I understand you correctly, you need a third table. 1 - CARETAKERS (Caretaker info) 2 - CLINICS (Clinic info) 3 - e.g. VISITS with relationships to CARETAKERS and CLINICS and other fields you need…
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Subtable - ordering system
First... LOL... So, I created a new tab (Add Item) at first following your idea but in the end I deleted it and now I have theese fields (Search, Qty, button ete) at first place at my main form.…
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: How to get several conditions like a "CASE" fonction
From the manual (for multiply if statements): if Age < 18 then "Child" else "Grown-up" end if Age < 18 then if Age < 13 then "Child" else "Teenager"else "Grown-up"end For a "Case" function look at…
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Moving fields between tabs???
Maybe Web app is different? Mac app
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Subtable - ordering system
@Mconneen LOL!!! Thanks for pointing me to the right direction! I will try your idea tomorrow.
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Moving fields between tabs???
The drag and drop to another Tab works fine here... Mac app, v 2.5.5.
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Subtable - ordering system
@Mconneen, Thanks for sharing! Im looking for a way, after you set the fields null, t.('Search Article' := null);t.(Qty := null); to automatically put the cursor to "Search Article" for typing the…
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Formula for age calculation
I had some time to kill, so I came up with this: Formula field (named Age Styled in the screenshot below) with this code: let age := year(today()) - BirthYear;if BirthYear != null and BirthYear !…
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Formula for age calculation
Your "BirthYear" field is a text field or number field?
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Formula for age calculation
Hey Pierre, works for me... Number Field: BirthYear -> e.g. 1974 Formula Field -> Age -> year(today()) - BirthYear Result = 45
- Nick
- 5 yrs ago
- Get help
- Reported - view

1 18 19 20 21 22 28

Back to top

Ninox-Documentation

Overview

View all topics