Nick's Profile | Ninox Community

Badges

Latest Posts

Re: A formula for < and >
Create a formula field: --- if Amount >= 20 and Amount <= 100 then"Yes"end ---
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Search by date calendar?
Twenty years??? Crap, I'm on the edge (hopefully)...\ In our case now. As far as I know, you can't search the calendar.But the calendar takes the records from a table, right?…
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Color as background
Here you go... --- if 'Check-In' > Event.Begin thenstyled("SMONTAGGIO", "orange", "", "")elsestyled("MONTAGGIO", "red", "", "")end
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Date-period before and after
Create a Formula field with this code --- if 'Other Date' > Date then"Yes or Bigger or..."else"No or Smaller or..."end ---
- Nick
- 5 yrs ago
- Learn and share
- Reported - view
Re: Ninox Community Group
I am being held by force ...
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Auto increment a number
I am using this formula field in the Invoice Line Items table. --- let myID := number(Id);let myInvoice := Invoice;if Invoice thencnt((select 'Invoice Line Items')[Invoice = myInvoice and number(Id)…
- Nick
- 5 yrs ago
- Get help
- Reported - view
Conditional Style is coming

In the new upcoming version, in addition to the visual changes, I found the Conditional Style function for the table columns Nice!
- Nick
- 5 yrs ago
- 646
- Learn and share
Re: How can I populate a Bill To address from Job address if both the same?
Good job Bill! 👏
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: How can I populate a Bill To address from Job address if both the same?
Try it this way--- if 'Is Bill To Address the same as Job Address' = true thenTitle := 'Originating Customer Name'.Title;'First Name' := 'Originating Customer Name'.…
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Examples using SELECT
Please ignore this...
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Examples using SELECT
@jwlevy613 In the (double) accounting world all items are positive. Anyway, if I understand you correctly, to get the number as negative try something like this:…
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: How to trigger a change in date?
No, assign this code to a button in your form.
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: How to trigger a change in date?
This code will loop through the records (try it in a test db first) --- for i in select 'Table Name' dolet d := Date;i.(Date := date(year(Date), month(Date) + number(12), day(Date)))end ---
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: How to trigger a change in date?
Try this: --- let d := Date;Date := date(year(Date), month(Date) + number(12), day(Date)) ---
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: how to add auto numbering
...and remember if you duplicate a record this trigger will NOT fire :-(
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: how to add auto numbering
In order to have the GP-xxx format, the field must be Text. Then put this code in the Trigger after create (table level) --- let prefix := "GP";let count := cnt(select 'Customer Data');…
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: (Newbie) Create New Record from Button Formula Please
Attach this code to a button: let newRec:= (create YourTableNameHere); openRecord(newRec)
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Mac Version: Are dates limited by OS X Date?
macOS High Sierra 10.13.6
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: SMS/text function?
Great! Thanks.
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Recall data automatically
Hi Valter, If it's difficult for you, you can create a formula field with this code: --- format(Data, "dddd DD MMMM") ---
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Backup
Διάβασε εδώ https://ninox.com/en/manual/data-backup/data-backup
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Strange Math?
Your formula has to be: 'Total Prize Pool' * '1st Place %' / 100
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: How select records from related table not older then 3 months
Crap... and I thought you loved me! lol
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Adding Months to a date
Both codes produce the same result. I just meant that in this case you don't need the variables.
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Adding Months to a date
One simpler approach: Fields: - Date (date) - Number of Months (number) and the formula: date(year(Date), month(Date) + number('Number of Months'), day(Date))
- Nick
- 5 yrs ago
- Get help
- Reported - view

1 6 7 8 9 10 29

Welcome to the Ninox community

Nick

Re: A formula for < and >

Re: Search by date calendar?

Re: Color as background

Re: Date-period before and after

Re: Ninox Community Group

Re: Auto increment a number

Re: How can I populate a Bill To address from Job address if both the same?

Re: How can I populate a Bill To address from Job address if both the same?

Re: Examples using SELECT

Re: Examples using SELECT

Re: How to trigger a change in date?

Re: How to trigger a change in date?

Re: How to trigger a change in date?

Re: how to add auto numbering

Re: how to add auto numbering

Re: (Newbie) Create New Record from Button Formula Please

Re: Mac Version: Are dates limited by OS X Date?

Re: SMS/text function?

Re: Recall data automatically

Re: Backup

Re: Strange Math?

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

Re: Adding Months to a date

Re: Adding Months to a date

Overview