Skip to main content
Forum
Privacy
Contact
How to enable Javascript
Sign Up
Log in
Welcome to the Ninox community
Search all topics or
ask a question
Learn and share
Get help
Service status
Plugins
Documentation
Setup
Databases
Automation
My account
Administration
Solutions
Webinars
Overview
Profile
RoSoft_Steven
RoSoft_Steven.1
Ninox partner
Belgium
www.rosoft.be
Follow
Joined
Sun Sep 30 17:18:00 UTC 2018
1638
posts
235
likes received
5
followers
Badges
Latest Posts
Re: Popup related record
What john says. Also, by the date of the post, there have probably been program updates and a solution may well exist. If you can give a little more information about your problem or even better with…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
5 yrs ago
Get help
Reported - view
Re: I can't get a Dynamic Choice to select from a table. It works in other circumstances.
record(Kits,number(Choice)).Price Steven
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
5 yrs ago
Get help
Reported - view
Re: Two search in a base
I sometimes experienced that if you want to check text from a formula field, using - text('Petite taille') = "x" -could be the solution. Steven
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
5 yrs ago
Get help
Reported - view
Re: Logical expression not working
text('Groundschool Kit') = "Already bought" Steven
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
5 yrs ago
Get help
Reported - view
Re: Dynamic choice field - showing Id instead of description in print view
☺️
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
5 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.
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
5 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
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
5 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
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
5 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
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
5 yrs ago
Get help
Reported - view
Re: I think we have a new record for spam posts
Mama Ninja bot 🥷🏿
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
5 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.…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
5 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 ...…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
5 yrs ago
Get help
Reported - view
Re: Text value from dynamic choice field
Think this works: record(sourceTable,number(DynamicChoiceField)).YourFieldName Steven
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
5 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.…
RoSoft_Steven
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....
RoSoft_Steven
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
RoSoft_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
RoSoft_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
RoSoft_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
RoSoft_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
RoSoft_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)
RoSoft_Steven
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:…
RoSoft_Steven
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
RoSoft_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
RoSoft_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',…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
5 yrs ago
Get help
Reported - view
1
32
33
34
35
36
66
Ninox-Website
Overview
Learn and share
Get help
Service status
Plugins
Documentation
Setup
Installed apps
Public Cloud
Private Cloud
On-Premises
Plugins
Databases
Tables
Table relationships
Fields and elements
Pages
Views
Import and export
Modules
Printing
Templates
Use cases
Automation
Performance
Scripting
Functions
API
My account
Subscriptions
Administration
Manage workspaces
Manage collaborators
Access permissions
Backups and storage
Process monitor
Solutions
Ninox E-Invoice
View all topics