Skip to main content

Forum

Welcome to the Ninox community

Search all topics or ask a question

Badges

Latest Posts

Re: Invoice n°
Hi, look at the Invoices template. There is a Trigger On Create for Invoice numbering.
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: FORMULA & ALERT
Hi Raphael, you can have as many as you need, just separate them with a semicolon (;). ... end; new trigger...
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Count If... function help
Change the "Procedure Name" with the Number of the Value List: e.g.cnt(select Procedure where Procedure = 1 and Date >= t.From and Date <= t.To)
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Find Highest Number
Formula field: max((select TableName).FieldName)
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Count If... function help
Sure! Download it from here: https://www.dropbox.com/s/vlkq4pysp5f1dqv/Procedures.ninox?dl=0 Enjoy
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Count If... function help
Something like this...
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Link to more records
Hi, read here https://ninoxdb.de/en/manual/tables/table-references-and-relations for Many to Many relationships. Look at the chapter "Relationship Tables: the N:M-Relationship"
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Count If... function help
One different approach is to create new table i.e. 'Procedures Report'. Create 2 date fields for your date range "From, To" and 5 formula fields with AFIB LOOP. PACER. TEE. DCCV.…
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: How do a reset a search.
You can right click to the left and select show everything or cmd+F again and Show everything
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: FORMULA & ALERT
Sorry, use this code as Trigger After Update at table level (and NOT Age field).
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: FORMULA & ALERT
Hi, you can use this code as Trigger After Update in your Age field: if Age < 18 then alert("Your text here") end
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Find Highest Number
From the manual: ...selecting records is useful in many situations, one common case is to calculate the next Invoice ID. 'Invoice ID' := max((select Invoices).'Invoice ID') + 1
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: How do you delete a database in the Android app?
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: How do you delete a database in the Android app?
Sean is right, tested and it works. Swiping to the right brings up a red button with a menu.
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Next Record Button (almost working)
You need to link the Invoice with the Trips table: let InvId := id; closeRecord();let a := (create Trips); a.(Invoice := InvId);popupRecord(record(Trips,number(a.Id)))
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Opening the Calendar upon opening a db
Thanks Fabio.
- Nick
- 6 yrs ago
- Get help
- Reported - view
Opening the Calendar upon opening a db

Is there a way to open the Calendar upon opening a database?
- Nick
- 6 yrs ago
- 2replies
- 1218
- Get help
Re: Payment method
From Ninox FAQ... ... modify iCloud databases on another device? Ninox databases can only be modified on the device they have been created on. Ninox has this setting to avoid conflicts.…
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: update the date automatically
Hi, put this in the "Trigger After Update" box: yourModifiedDateField := today()
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Payment method
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Id record
Try this: let b:= id let a:= create test a.test1:= b
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: print layout trouble
Maybe it's a browser issue. Are you tried another browser?
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Create weekly recurring appointments
Hi, there is a database named 37_Calendar_Tolls in Webinar EN 2019 team. It creates simple or reccuring reminders. You can register to webinar to download the database and modified to your needs.
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Multi criteria filter
Works with "or"... like "German" or like "French"
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Accounting Tutorial
You're welcome!
- Nick
- 6 yrs ago
- Get help
- Reported - view

1 20 21 22 23 24 29

Back to top

Overview

View all topics