RoSoft_Steven's Profile | Ninox Community

Badges

Latest Posts

Re: Protecting Editable Fields - Best practice
Which version do you use? If it's the cloud (thus web) it's better to use the build in user roles. Else if it's a stand alone version (Ipad,Mac), you will need a sort of login screen first with an…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Learn and share
- Reported - view
Re: Protecting Editable Fields - Best practice
Sure, Let's say we make use of a seperate table for settings with only one record called SETTINGS and a Yes/No field called EDITTABLE. Then you can put this in the "writable if" section of the…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Learn and share
- Reported - view
Re: Protecting Editable Fields - Best practice
You can make the whole table also "writable if"....
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Learn and share
- Reported - view
Re: Protecting Editable Fields - Best practice
Halio, I would go for option 3 , but I would make use of the field option 'writable if' in combination with a Yes/No field to protect those fields from input instead of using an extra equivalent…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Learn and share
- Reported - view
Re: exclude equal date
To count only unique values in that list is much easier , use this:cnt(unique((select Table1).Date)
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: exclude equal date
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: exclude equal date
Ah, misunderstood your question first, try this in a formula field: let c := 0;let dates := unique((select Table1). Date;for i from 0 to cnt(dates) doif cnt(select Table1 where Date = item(dates,…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: exclude equal date
Sorry...
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: exclude equal date
Uh Oh, Nick again....😵
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: exclude equal date
cnt(select Table1 where Date != d) Steven.
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Change the default file name when using Print PDF
Agassi, this is the syntax to achieve that: importFile(this, printAndSaveRecord(this, "My Print Layout"), "mypdf.pdf") or importFile(this, printAndSaveRecord(this, "My Print Layout"),…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Formula vs Image Field

Like this idea? Please upvote for CR 1591 Let it be possible to place multiple fields next to a formula Field (When that formule field is multiple lines in highth) like you can do with a Image Field.…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- 695
- Learn and share
Re: New Email Button creating a new record in subtable
Last line should be : popupRecord(record('New Email',i.Id)) forgot a '
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: New Email Button creating a new record in subtable
Nick again..... 🤣
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: New Email Button creating a new record in subtable
Halio, Try this: let currRec := Id;let i := (create 'New Email');i.(Emails := currRec);popupRecord(record(New Email',i.Id)) Steven.
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Rich text formatting disappears in final PDF file
Best solution i guess is to contact support@ninoxdb.de and ask to change the print engine of the cloud team you're working in. I think that might help. Steven.
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Frustrated with poor help guides- Is there a full guide to formulas anywhere?
Something like this? In a formula field: cnt(select TableName where Field = a certain value) Steven.
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: date function
Haha Nick, 😇
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: date function
Hi, In this example, the field for the year is a number field 'Year' and the two other fields are date fields 'Begin' and 'End'. You can put this code in the Trigger after update of the 'Year' field…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Impression d’une mise en page
Vous pouvez le faire en utilisant un bouton et en utilisant des conditions. Tutoriel : printRecord(recordId, layoutName) Example: if a = true then printRecord(this,…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Joining selected records from a table
@Ivan, it's best to send an email to support@ninoxdb.de with the dates you want the archive. You'll get the links then.Steven.
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Pulsante Apri tabella
Utilizzare openTable(tableName,viewName) nella formula del pulsante. Esempio: openTable( "Fattura", "Tutto") Vedere https://ninoxdb.de/en/manual/calculations/reference-of-functions-and-language per…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Reformatting text via a formula
Strange, i've tested it in the ipad and the web version, both are working. Do you use the trigger after update of the field itself? Steven
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Reformatting text via a formula
Robert, Use capitalize(Firstname) instead. Steven.
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Ability to reorder tabs on forms or insert a new tab in the middle of the tabs?
When you go in the "Edit Fields" , the left column are the fields on your form and you can drag and drop these to rearrange the order. Steven.
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Learn and share
- Reported - view

1 55 56 57 58 59 65

Welcome to the Ninox community

RoSoft_Steven

Re: Protecting Editable Fields - Best practice

Re: Protecting Editable Fields - Best practice

Re: Protecting Editable Fields - Best practice

Re: Protecting Editable Fields - Best practice

Re: exclude equal date

Re: exclude equal date

Re: exclude equal date

Re: exclude equal date

Re: exclude equal date

Re: exclude equal date

Re: Change the default file name when using Print PDF

Re: New Email Button creating a new record in subtable

Re: New Email Button creating a new record in subtable

Re: New Email Button creating a new record in subtable

Re: Rich text formatting disappears in final PDF file

Re: Frustrated with poor help guides- Is there a full guide to formulas anywhere?

Re: date function

Re: date function

Re: Impression d’une mise en page

Re: Joining selected records from a table

Re: Pulsante Apri tabella

Re: Reformatting text via a formula

Re: Reformatting text via a formula

Re: Ability to reorder tabs on forms or insert a new tab in the middle of the tabs?

Overview