RoSoft_Steven's Profile | Ninox Community

Badges

Latest Posts

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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 yrs ago
- Get help
- Reported - view
Re: Can I use two field contents as choices?
Strange, I tested it and this is what I get if I use a dynamic MULTIPLE choice field: Steven
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Conditional Formatting Built into Formula Field
Thanks for sharing John.
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Can I use two field contents as choices?
With a dynamic multiple choice field?
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Bigger or equal…
Are U sure there are no 'spaces' in the field: Nom? We had that already in the past...... Steven
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: To colour with conditional style with the id ?
No, unless you have a backup.
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: To colour with conditional style with the id ?
Formula fields are calculated values, they are always calculated on openig the table (thats also the reason of slowing down things) Some formulas are in need of a trigger to do some action.…
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: To colour with conditional style with the id ?
Et ensuite, vous pouvez retirer le bouton.
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: To colour with conditional style with the id ?
You can use this code in a button or in the console
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: To colour with conditional style with the id ?
The command 'for i in range(start,stop) do' is a kind of loop is and it goes over all the numbers in this range.Then each time it takes a record from your table with the current number as id and…
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: To colour with conditional style with the id ?
Sorry, it should be: for i in range(3825,4349) do delete(record('Votre nom de table',i)) end Steven
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: To colour with conditional style with the id ?
Becarefull to use this, better make a backup first before trying this out: for i in range(3825, 4349) do delete(i) end Steven
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: To colour with conditional style with the id ?
Try number(_id) Translation to french of ninox code (functions) doesn't work. Steven
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Full screen
From the manual: openFullscreen(recordId) - opens a record in full-screen mode openFullscreen(recordId, tabName) - opens a given tab of record in full-screen mode example: let i := this;…
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Formula doesn't work until I populate each field in the formula at least one time, then works for the one record. Needs to be repeated in each record?
You should use null instead of 0 like if 'Phone 3' != null then Steven
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Error in a formula ?
'Premier mot' is a formula field, you can't put data in it. Steven
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view

1 32 33 34 35 36 65

Welcome to the Ninox community

RoSoft_Steven

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

Re: Can I use two field contents as choices?

Re: Conditional Formatting Built into Formula Field

Re: Can I use two field contents as choices?

Re: Bigger or equal…

Re: To colour with conditional style with the id ?

Re: To colour with conditional style with the id ?

Re: To colour with conditional style with the id ?

Re: To colour with conditional style with the id ?

Re: To colour with conditional style with the id ?

Re: To colour with conditional style with the id ?

Re: To colour with conditional style with the id ?

Re: To colour with conditional style with the id ?

Re: Full screen

Re: Formula doesn't work until I populate each field in the formula at least one time, then works for the one record. Needs to be repeated in each record?

Re: Error in a formula ?

Overview