Nick's Profile | Ninox community

Badges

Latest Posts

Re: Button to send mail and attachment PDF
Something like this: alert("Email has been send"); 'Date / Time' := now()
- Nick
- 6 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
- 6 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
- 6 yrs ago
- Get help
- Reported - view
Re: New Email Button creating a new record in subtable
Steven... 😂
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: New Email Button creating a new record in subtable
https://ninoxdb.de/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/add-record-button-5db31c1f97213028dfb95755
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Return sum of values between two given dates.
Sure!
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Is Ninox compatible with Catalina ?
Same here, all OK with Catalina.
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Is there a way to enforce the required fields so a record row will not be added unless all required fields are completed?
@Sean, You did your magic again 👍👍👍 Thanks
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: monthName not working ... bug?
Yep, month() gives the correct month number while monthName() gives always a month behind and for January gives nothing
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Formula to constrain dates
Try like this (for September 2019): --- sum((select Table1 where Paid = 1 and Date >= date(2019, 9, 1) and Date <= date(2019, 9, 30)).'Sub-total') ---
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Rich text formatting disappears in final PDF file
Sometime ago I had font problems with the produced pdfs and Jorg changed my print engine. I don't know if this has to do anything with this problem, so follow Steven's advise and wright an email to…
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Rich text formatting disappears in final PDF file
Windows 10 - Adobe Reader
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Rich text formatting disappears in final PDF file
I don't have this problem anymore. I just did a test with: - Ninox app - Web version with Safari - Web version with Firefox Here is the final pdf (App & Safari) No html in the print layout,…
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: date function
^$#&*(*$&%&$*.... Next time Steven! LOL
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: date function
ooops :-)
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: date function
Something like this: --- let myYear := YourYearField;'YourFirstDate' := date(myYear, 1, 1);'YourLastDate' := date(myYear, 12, 31) ---
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Calcolo ore
Try this: number(risultato / 3600000)
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Add record Button
You 're welcome gyus!
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Add record Button
@Dean, If I understand you correctly, this creates records to both child tables and sets the Contact Name: --- let myID := Id;let name1 := Contact_Name;let c1 := (create Child_1);c1.…
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Add record Button
Hi Alex, Let's assume that you have 2 tables with common fields: DateField and TextField. The code for the button in the table Caldaie: --- let myID := Id;let dt := Date;let txt := Text;let i :…
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Is there a way to enforce the required fields so a record row will not be added unless all required fields are completed?
Idea 💡 If we found a trick to hide the 3 toolbar buttons: Delete, Duplicate and Create?
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Is there a way to enforce the required fields so a record row will not be added unless all required fields are completed?
What's the point of this? A user can close the form by hitting 'Esc' key or navigate to a different record.
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Concurrent schema modification...
Hi Karen, I'm using Firefox (maybe it's time give to MS Edge a chance?).
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Is there a way to enforce the required fields so a record row will not be added unless all required fields are completed?
Hi Tom, yes it works, if you put the code behind a button. When done with the creation or modification of a record, push the (e.g. 'Save') button and:
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Concurrent schema modification...
@Karen,of course I ignore it, and as you rightly said, almost all changes are saved.To me it happens in cloud version (and on Windows only not on macOS!!!) Anyway, I was just curious,…
- Nick
- 6 yrs ago
- Get help
- Reported - view

1 13 14 15 16 17 29

Welcome to the Ninox community

Nick

Re: Button to send mail and attachment PDF

Re: Export from iPhone

Re: exclude equal date

Re: New Email Button creating a new record in subtable

Re: New Email Button creating a new record in subtable

Re: Return sum of values between two given dates.

Re: Is Ninox compatible with Catalina ?

Re: Is there a way to enforce the required fields so a record row will not be added unless all required fields are completed?

Re: monthName not working ... bug?

Re: Formula to constrain dates

Re: Rich text formatting disappears in final PDF file

Re: Rich text formatting disappears in final PDF file

Re: Rich text formatting disappears in final PDF file

Re: date function

Re: date function

Re: date function

Re: Calcolo ore

Re: Add record Button

Re: Add record Button

Re: Add record Button

Re: Is there a way to enforce the required fields so a record row will not be added unless all required fields are completed?

Re: Is there a way to enforce the required fields so a record row will not be added unless all required fields are completed?

Re: Concurrent schema modification...

Re: Is there a way to enforce the required fields so a record row will not be added unless all required fields are completed?

Re: Concurrent schema modification...

Overview