Nick's Profile | Ninox Community

Badges

Latest Posts

Re: Filtering by date is ignored on the PDF
When I want to do something like this, I'm doing the filtering in the Print Layout screen. Clicl the table then click 'Edit Columns' and finaly enter the filters in the Date field. For the "...…
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: choice based on text entered in other field
Hi, you can use something like this in the box 'Trigger After Update': if Description like "taxi" or Description like "plane" or Description like "ship" thenYourChoiceField :…
- Nick
- 6 yrs ago
- Get help
- Reported - view
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
- 6 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
- 6 yrs ago
- Get help
- Reported - view
Re: Cascade Fields
I think @wynand talking about Edit Fields screen...
- Nick
- 6 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
- 6 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
- 6 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
- 6 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
- 6 yrs ago
- 2replies
- 1545
- Get help
Re: Can I install Ninox on two computers?
Yes you can, just install it from the App Store.
- Nick
- 6 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
- 6 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
- 6 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
- 6 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
- 6 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
- 6 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
- 6 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
- 6 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
- 6 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
- 6 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
- 6 yrs ago
- Get help
- Reported - view
Re: Moving fields between tabs???
Maybe Web app is different? Mac app
- Nick
- 6 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
- 6 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
- 6 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
- 6 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
- 6 yrs ago
- Get help
- Reported - view

1 18 19 20 21 22 29

Welcome to the Ninox community

Nick

Re: Filtering by date is ignored on the PDF

Re: choice based on text entered in other field

Re: I can't edit the number of pieces in my inventory when I add a new item

Re: Trying to write basic mathematical formula for Inventory

Re: Cascade Fields

Re: Two referenced fields in one field and filtering contacts from one company

Re: Two referenced fields in one field and filtering contacts from one company

Re: Filter a View to show only Top 5

Filter a View to show only Top 5

Re: Can I install Ninox on two computers?

Re: How to use the "View" element

Re: How to use the "View" element

Re: Can I move items from one table to another?

Re: Integrate with web page

Re: Where to write a global function

Re: Subtable - ordering system

Re: Subtable - ordering system

Re: Linking tables

Re: Subtable - ordering system

Re: How to get several conditions like a "CASE" fonction

Re: Moving fields between tabs???

Re: Subtable - ordering system

Re: Moving fields between tabs???

Re: Subtable - ordering system

Re: Formula for age calculation

Overview