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: Process to import Company and Contact CSV
Read here about Importing Linked Data https://ninoxdb.de/en/manual/import-and-export/importing-linked-data
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: Problem with last()
OK, i think this is it... let maxId := max((select Table).number(Id));maxId
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: Problem with last()
Thanks Steven but I tried... let mylast := last((select Table).Id);mylast gives 99
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: Problem with last()
sorry last((select Table).Amount)
- Nick
- 4 yrs ago
- Get help
- Reported - view
Problem with last()

Hi to all,I have a table containing 189 records and I get the value of a field from the last record (most recent record) with the command:last ((select Table. Amount).…
- Nick
- 4 yrs ago
- 5replies
- 1632
- Get help
Re: Protecting Editable Fields - Best practice
@Steven, I missed that one... LOL
- Nick
- 5 yrs ago
- Learn & Share
- Reported - view
Re: Getting the Year & Month between two dates
@Halio, pls try this version --- let D1 := if Birthdate > TermStartDate thenTermStartDateelseBirthdateend;let D2 := if Birthdate > TermStartDate thenBirthdateelseTermStartDateend;let DD :…
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Show sub table formula result in main form
Try something like this: let t := this sum((select YouSubTable)[TableReference = t and Checkbox = true].Amount)
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Getting the Year & Month between two dates
Thanks for sharing Jen!
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Getting the Year & Month between two dates
I'm using this formula (calculates days too) --- let D1 := if TermStartDate > Birthdate thenBirthdateelseTermStartDateend;let D2 := if TermStartDate > Birthdate thenTermStartDateelseTermStartDateend;…
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Getting the Year & Month between two dates
Nioxus has a global function for this Get it here (you have to create a free account) https://www.nioxus.com/portal/post/275
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Numéro de semaine
week(Date)
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: select and sum the same date values
One idea is to create a formula and idendify the duplicates: let myDate := Date;if cnt(select Table1 where Date = myDate) > 1 then1end --- then, another formula: sum((select Table1)[Duplicate = null].…
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Button to Change Value of All Records
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Managing precision in number field, seeing non-exact values.
Same here, number field. I enter 22940,62 and get this
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Button to Change Value of All Records
@Halio, use this code for that --- let myChoice := true;for i in select YorTableName doi.('Yes / No' := myChoice)end ---
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Problems with calendar
Αn entry for November 1st shows up corectly in the Week View. However, in Month View, when you browse October this entry shows up at October 31. -- In Mac app when you browse November it's OK.…
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Button to send mail and attachment PDF
});alert("Email has been send"); 'Email Sent Date' := now()endend
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: exporting all fields
Ninox will export only the fields that are visible in a table view. So, add all required fields as columns (as @Joe described) and try to export again.
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Button to send mail and attachment PDF
or end;alert("Email has been send");'Date / Time' := now()end end
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Button to send mail and attachment PDF
oops, sorry... Change the "end" order ... end end; alert("Email has been send"); 'Date / Time' := now() end
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Button to send mail and attachment PDF
Hi Halio, if not Recipient thenalert("You have no recipient, please add one before sending this email!")elseif not Subject thenalert("Subject line is empty, please don't leave it blank.…
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Button to send mail and attachment PDF
Something like this: alert("Email has been send"); 'Date / Time' := now()
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Export from iPhone
On iPhone swipe the database to the right and you will see a menu where you can find the option: "Save Archive As..."
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: exclude equal date
Try it this way: let d := Date;cnt((select Table1 where Date = d).Id) or let d := Date;cnt((select Table1 where Date != d).Id)
- Nick
- 5 yrs ago
- Get help
- Reported - view

1 12 13 14 15 16 28

Back to top

Ninox-Documentation

Overview

View all topics