RoSoft_Steven's Profile | Ninox community

Badges

Latest Posts

Re: Dynamic choice field - showing Id instead of description in print view
☺️
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Table resequence
You have to be in administrative mode (red wrench) to make your sort settings permanent. Steven.
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Dynamic choice field - showing Id instead of description in print view
Maybe this helps: record('Mechanical Services',number('Mechanical Services')).Description Steven
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Issue to create a line in the formula field
Try to change 'Couleur de fond' to white (in your first screenshot). Hope this helps... Steven
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Reference an empty or bland field in a logical function
null, is the reference of an empty field. e.g. if name = null then .... Steven
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: I think we have a new record for spam posts
Mama Ninja bot 🥷🏿
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Default mail
The sendEmail() function is only available in Ninox Cloud. If you use an Email-field, pushing on the enveloppe on the right opens your default emailclient to send emails.…
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Sendemail - pick up field variable
Maybe use : let att := record(SystemFile,1).Attachmentfield >(In case you used a Image field to put your pdf in, if not try: first(files(record(Systemfile,1))) and in your sendEmail use ...…
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Text value from dynamic choice field
Think this works: record(sourceTable,number(DynamicChoiceField)).YourFieldName Steven
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: How can I change the font size of a Number field
Maybe a little tip, if you make a table with only one empty form view with your (hidden,using colors)html-formula field, you can use openFullscreen() to open it.…
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: How can I change the font size of a Number field
For the false status....
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: How can I change the font size of a Number field
Here's the slider: div.booleanslide-slide{background-color: #ff0045;} Steven
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: A little help for a button script
maybe this is the cause: Table1. Remove the dot after 'Table1' in your code Steven
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Round a calculation to 2 decimals
You can wrap it in a format function. format(round(field,2),"0.00") Steven
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- 1
- Get help
- Reported - view
Re: Is there a way to auto-increment a number field so that the numbers only happen within the subtable record of a parent record?
Here's an example database : https://www.dropbox.com/s/837uekjlwshx09b/AutoNum%C3%A9ration.ninox?dl=0 Steven
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: table reference error stating "Return type mismatch for then and else expressions. at line #, column ##
Try this: let me := this;let newQuote := (create Quotes);newQuote.(Customer := me);openRecord(newQuote) Steven
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: How to create a button to start a new Appointment?
let i := create Events; openRecord(i)
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Select items or record by record
You can use join() e.g.: let firstnames := join((select Tabelnaam).Voornaam, ",") You then get a "," separated string. If you want to get item by item, you first make it an array like this:…
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Learn and share
- Reported - view
Re: Dynamic single choice
You can use this : record(YourTable,number(ChoiceField)).FieldYouWantToDisplay Steven
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Formula to combine two multiple choice fields?
split(text(chosen('Multiple choice')) + if 'Multiple choice 2' then "," end + text(chosen('Multiple choice 2')), ",") Steven
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: To copy a formula field in a formula text ?
I think you want to make a text field from a formula field. Yes, it's possible. Suppose your table is called 'Noms' and you want to create a textfield 'Name' from a formula field called 'Nameformula',…
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Dynamic Multiple Choice doesn't display values in order (A-Z), but should
Did you try the 'dynamic Value': select COLORS order by Name Steven
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Bigger or equal…
Yes you are right , "si" must be "if" - "alors" must be "then" - "sinon" must be "else" - "fin" must be "end". The code must always be in Ninoxlanguage (Anglais). 😉
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Can I use two field contents as choices?
Well yes, if you're willing to use a trick, you have to have an extra table with all the possible names that could appear in your (Multiple) choice fields. Steven.
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: carriage return in alertbox
Let me tell you a secret. If you use a dialog() function instead of an alert() function, you can use html to display the text within. Steven
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view

1 32 33 34 35 36 66

Welcome to the Ninox community

RoSoft_Steven

Re: Dynamic choice field - showing Id instead of description in print view

Re: Table resequence

Re: Dynamic choice field - showing Id instead of description in print view

Re: Issue to create a line in the formula field

Re: Reference an empty or bland field in a logical function

Re: I think we have a new record for spam posts

Re: Default mail

Re: Sendemail - pick up field variable

Re: Text value from dynamic choice field

Re: How can I change the font size of a Number field

Re: How can I change the font size of a Number field

Re: How can I change the font size of a Number field

Re: A little help for a button script

Re: Round a calculation to 2 decimals

Re: Is there a way to auto-increment a number field so that the numbers only happen within the subtable record of a parent record?

Re: table reference error stating "Return type mismatch for then and else expressions. at line #, column ##

Re: How to create a button to start a new Appointment?

Re: Select items or record by record

Re: Dynamic single choice

Re: Formula to combine two multiple choice fields?

Re: To copy a formula field in a formula text ?

Re: Dynamic Multiple Choice doesn't display values in order (A-Z), but should

Re: Bigger or equal…

Re: Can I use two field contents as choices?

Re: carriage return in alertbox

Overview