Nick

Greece

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

My Posts

Latest Posts

Re: LAYOUT PROBLEM
This is only a preview, continue to print and you'll get your list.
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: How select records from related table not older then 3 months
Agassi you are welcome, have a look at these posts: https://ninox.com/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/is-it-possible-to-make-a-view-with-a-top-10-only-5cf7d38dd33ece4265d9c52c https:…
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: How select records from related table not older then 3 months
Hi, something like this? --- let p := Product;let d := today() - 180;avg((select Order where Product = p and Date >= d).Price) ---
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: Documentation.
This thing with the Ninox manual became Ancient Greek Drama (Aeschylus, Sophocles and Euripides). Its a shame!
- Nick
- 4 yrs ago
- Learn and Share
- Reported - view
Re: Documentation.
+1
- Nick
- 4 yrs ago
- Learn and Share
- Reported - view
Re: I have a field 'Renew By' which I want to change the background colour if the 'Renew By' date is after Today().
Create a formula field with this code: --- styled(text('Renew By'), if 'Renew By' <= today() then"green"else"red"end, "") ---
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: Format a Number
Read here: https://ninox.com/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/thousands-separator-5ea8fd949abcca268195c4dd
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: How do I get rid of the subscribe pop-up on the Mac App?
Your trial (evaluating) period has expired. You have to pay a subscription in order to stop the popup. If you own the Mac app, download your databases from the Ninox cloud and import them to 'My…
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: Recall data automatically
Ciao Valter, It works for me the way I described... Anyway, please re-download the example file from Dropbox. The button 'Add Customer' is now visible. Also I added a view with the code from @Luis…
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: Recall data automatically
Hi Valter, In my example, you are looking for e.g. for the customer 'DALUCA' and if there is the customer his name appears in the field below and by clicking on it you are transferred to the…
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: Thousands Separator
:-)
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: SMS/text function?
I found that if I put this sms:// as url address, opens Messages app (Mac and iPhone) and creates an empty message. Maybe some idea to add phone anumber and a message text something like this? sms:…
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: Thousands Separator
Then, maybe is your system settings? I know that Ninox doesn't have it's own control panel for Dates and follows Mac settings for desktop app and Browser settings for web app.…
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: Thousands Separator
It works for me: 1. click this format 2. Then click Number Format box again and set the Digits to 0 3. The result is
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: Recall data automatically
Hi, Look at this example: https://www.dropbox.com/s/divbsc947kvf6nu/Find%20Customer.ninox?dl=0
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: count the number of rows in a table
Yes, like this: sum('Invoice Items'.Quantity)
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: count the number of rows in a table
If understand you correctly... Let's assume you have a table Invoice and a subtable 'Invoice Items'. In the subtable 'Invoice Items' add a formula field, e.g.…
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: Email
Ηι, It is the address to which you are sending the email. --- from: userEmail(user()), "<- your email address"to: text('Customer Email'), ---
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: Set a calendar event over a few days - looking for formula
There is a "037_Calendar Tools" database in the Webinar EN 2020 team.
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: Help with "this"
Try it this way --- let t = this select DaysTime where Days = t
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: How to create balance table from income and expense tables
Well, I don't have time to test right now, but I think it's OK. Put this code in the Trigger After Update box of the Amount field (tables Income and Expenses of my example db): let d := Date;let p :…
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: How to create balance table from income and expense tables
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: How to create balance table from income and expense tables
Hi Agassi, take a look in this file https://www.dropbox.com/s/xm08vpmqb194ec7/zMoney_Test.ninox?dl=0
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: Date Formula?
Find the last day of the current month with this formula: --- let myDay := today();date(year(myDay), month(myDay) + 1, 1) - 1 --- So, in your case try this (last day of the current month + 30):…
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: Sums and Counts based on a text status
Try this: sum((select Invoices)[text('Invoice Status') = "Paid"].'Net Total')
- Nick
- 4 yrs ago
- Get help
- Reported - view

1 7 8 9 10 11 28

Welcome to the Ninox community

Nick

My Posts

Re: LAYOUT PROBLEM

Re: How select records from related table not older then 3 months

Re: How select records from related table not older then 3 months

Re: Documentation.

Re: Documentation.

Re: I have a field 'Renew By' which I want to change the background colour if the 'Renew By' date is after Today().

Re: Format a Number

Re: How do I get rid of the subscribe pop-up on the Mac App?

Re: Recall data automatically

Re: Recall data automatically

Re: Thousands Separator

Re: SMS/text function?

Re: Thousands Separator

Re: Thousands Separator

Re: Recall data automatically

Re: count the number of rows in a table

Re: count the number of rows in a table

Re: Email

Re: Set a calendar event over a few days - looking for formula

Re: Help with "this"

Re: How to create balance table from income and expense tables

Re: How to create balance table from income and expense tables

Re: How to create balance table from income and expense tables

Re: Date Formula?

Re: Sums and Counts based on a text status

Overview