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
1634
posts
234
likes received
5
followers
Badges
Latest Posts
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
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
5 yrs ago
Get help
Reported - view
Re: Conditional Formatting Built into Formula Field
Thanks for sharing John.
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
5 yrs ago
Get help
Reported - view
Re: Can I use two field contents as choices?
With a dynamic multiple choice field?
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
5 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
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
5 yrs ago
Get help
Reported - view
Re: To colour with conditional style with the id ?
No, unless you have a backup.
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
5 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.…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
5 yrs ago
Get help
Reported - view
Re: To colour with conditional style with the id ?
Et ensuite, vous pouvez retirer le bouton.
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
5 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
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
5 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…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
5 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
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
5 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
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
5 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
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
5 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;…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
5 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
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
5 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
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
5 yrs ago
Get help
Reported - view
Re: Distributing a database
Hi, Michel I believe you are using a browser to go to your database (I use Google chrome to get the best performance) ? On the startup where you see your TEAMS (top tabs),…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
5 yrs ago
Get help
Reported - view
Re: Issue with a formula
I think it's because that name begins with a space in your text-field. Steven
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
5 yrs ago
Get help
Reported - view
Re: Progressive sum
let d := this;sum((select Months where 'Month n°' <= d.'Month n°').'Budget €') Steven
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
5 yrs ago
Get help
Reported - view
Re: Extract names from compound names
use this formula: substr(Nom, 0, index(Nom, " ")) Steven
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
5 yrs ago
Get help
Reported - view
Re: http() function isn't working
In my experience, when i use 'do as server' in my http request it works. If I don't, it blocks. e.g.: let responce := do as server http("GET","......... end Steven
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
5 yrs ago
Get help
Reported - view
Re: field name with HTML formatting
Maybe this tread is also usefull:…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
5 yrs ago
Get help
Reported - view
Re: fields printing visible or invisible
If you mean printing a table view, then you can use different table views to filter what you want to print. It's always what's displayed that would be printed.…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
5 yrs ago
Get help
Reported - view
Re: table view with both combo box (selected options and 'empty or null option) in same view
Does this expression gives the wanted result? if combobox !> 0 then "empty" Steven
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
5 yrs ago
Get help
Reported - view
Re: delete x qty of records
I would try to put the date in a variable : let d := date(22/01/2015); delete (select DEJOBS where text(Jobstatus) = "cancelled" and Orderdate <= d) Steven
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
5 yrs ago
Get help
Reported - view
Re: Representations of the Id
The left column in your screenshot doesn't show the ID number, its the line number (like excell). To show the id you need to click on a columnheader and there chose to show the ID column.…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
5 yrs ago
Get help
Reported - view
1
33
34
35
36
37
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
Private Cloud Administration
Manage workspaces
Manage collaborators
Access permissions
Backups and storage
Process monitor
Solutions
Ninox E-Invoice
View all topics