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: Radio button triggering text in field
Try this: if choice = 1 then textField:= " text1"
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Install on desktop and laptop?
Yes, you can!
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Bug? When you enter text in a field then switch, using the record navigation arrows, to another record, the text is NOT saved.
Peter is right. If you don't tap outside the field and navigate to another record, the text disappears (record not saved).
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Is there a way to change the order of views?
I use numbers before View names e.g 01 Viewname, 02 Viewname etc
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Change
Sean, I think you did it! It tested correctly. Again, thanks a million! Nick
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Change
...and the Mac Settings: Nick
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Change
Hi Sean, take a look at the number settings: ...and more common for plural is Euros. Screenshots are from Mac app version of Ninox. Nick
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Change
@slowwagon For "Total to Words" I'm using -> let numAmount := 'Invoice Total'; For "Total to Words cents" I'm using -> let numAmount := Subtotal + 'Tax Amount' - 'Discount €' + Shipping;…
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Inheritance table
Go to Edit Fields, click you Relation Ship and in Show As box you can control what to display: Nick
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Formula to jump to tab
I think he means jump to different tab in the same table. Nick
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Create un subtable record from the parent table with a script button
let myID := Id;let NN := (create 'Invoice Items');NN.(Invoice := myID);let myRN := number(NN.Id);popupRecord(record('Invoice Items',myRN)) Change table and field names as reuired from your model. Nick
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Calculating at date help please
Please ignore my previous post :-( Please try this: let m := chosen(Your multiple choice);date(year(Date), month(Date) + number(m), day(Date)) Nick
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Calculating at date help please
I have something similar as Trigger after update: 'New Date' := date(year(Date) + 1, month(Date) + 6, day(Date) I hope it helps Nick
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Need a field formula that inserts a unique and sequential number?
Guys, also take a look in to "Invoices" template from Ninox. Has a field "Invoice No" and a trigger to insert the Year and a sequential number as Invoice No (e.g. 2018-005). Nick
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Need a field formula that inserts a unique and sequential number?
@k.f.kelly @timtaylor.rrfan this is easy. You have a table "Invoices" and a field "Invoice No". When you are in Edit Fields screen, paste this code to "Trigger on create" box: let before :…
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Connecting tables
You have to use a "Join" table. Read in the manual https://ninoxdb.de/en/manual/tables/table-references-and-relations the section Relationship Tables: the N:M-Relationship. Nick
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: User interface automation
John, you are right! The function printRecord(record('My Table Name', 1), "My Layout Name") produces an error. Maybe someone from the support puts this to Bugs category. Nick
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: User interface automation
Hi John, this works using the iPad (tested), printRecord(this, "My Layout Name") Nick
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: How do I use the 'button' field to connect to a different table?
let myOrder := (create ’Orders From Customers'); openRecord(myOrder) Nick
- Nick
- 6 yrs ago
- 1
- Get help
- Reported - view
Re: How to calculate a sum of a part of data lines
Hi Martin, if the Leistung is choice field and Beratung is the first choice, use formula field with this code: sum((select YourTable where Leistung = 1).Berechnung) Nick
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: User interface automation
...and for printing have you tried: printRecord(recordId, "myPrintlayoutName") e.g. printRecord(this, "Print") Nick
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: User interface automation
Hi John, for New Record creation use this code: let myD := this; let myP := (create ’Table Name'); openRecord(myP) Nick
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Can I show the aging of a product?
days(Date, today()) Nick
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: How can I set up two fields, one showing date/time record was created, one showing date/time of last modification?
Created on, Modified On and _cd, _md don't work with Mac app. I use triggers for that: Nick
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: multiple trigger "if" in sequence without "else"
Separate them with a semicolon: if a=0 then aa="ZERO"; else aa=void; end; if b=1 then bb="OK" else bb="TO-DO"; end; and so on...
- Nick
- 6 yrs ago
- Get help
- Reported - view

1 22 23 24 25 26 27 28

Back to top

Ninox-Documentation

Overview

View all topics