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
Documentation
Solutions
Setup
Databases
Automation
My account
Administration
Webinars
Overview
Profile
RoSoft_Steven
RoSoft_Steven.1
Ninox partner
Belgium
www.rosoft.be
Follow
Joined
Sun Sep 30 17:18:00 UTC 2018
1611
posts
218
likes received
5
followers
Badges
Latest Posts
Re: Trouble finding a column
@frsalabert Remove the 'Lignes Commandes' in your 11th row: t.('Désignation' := d)
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
4 days ago
1
Get help
Reported - view
Re: Dynamic Reports - Data from Different tables
@Michael Riley I think this would work.... First you need to put the y formula in a first() function. Then call the y inside the x.{ let xFilter := record(Reports,1).…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
5 days ago
1
Get help
Reported - view
Re: Menus Larger
@New Sun Try: let htm := " <html> <head> <style> .nx-alert-pane { display: flex; flex-direction: row; justify-content: center; padding: 1px; background-color: Azure; } .…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
8 days ago
2
Get help
Reported - view
Re: Select and where is faster than just select
Thanks @Fred , this is valuable info!
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
3 wk ago
Learn and share
Reported - view
Re: Seelect where Calculation from 2 entries
@Alexander Prinz Try: let myreg := Registration; let sel := (select 'Flt Hrs' where Luftfahrzeuge.Registration = myreg) order by Datum) item(r, cnt(sel) - 2).TSN
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
3 wk ago
Get help
Reported - view
Re: Sending email to multiple CCs
They need to be in an array: cc:["lyndsay.xxx@email.co.uk","Paul.xxx@email.co.uk","paul.2xx@email.co.uk","Jill.xxx@email.co.uk","terry.xxx@email.co.uk"],
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
3 wk ago
1
Get help
Reported - view
Re: Group by equivalent
Once you have a json variable, you can handle this like a table with records. To create a json variable, you can use something like this: let jsonvar := (select Tablename).…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
1 mth ago
Get help
Reported - view
Re: Group by equivalent
Maybe JSON is the way to go....
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
1 mth ago
Get help
Reported - view
Re: Am I missing something?
@Fred I guess, if you uncheck all, you get an empty database when creating a backup...
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 mths ago
1
Get help
Reported - view
Re: Kanban on Ninox
@Rafael Just curious, Which language model are you using? Chatgpt, claude, ..... ?
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 mths ago
Learn and share
Reported - view
Re: Kanban on Ninox
Wow, nice work !
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 mths ago
Learn and share
Reported - view
Re: Progress Stepper in HTML.
@Rafael Nice, Like it!
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
3 mths ago
Learn and share
Reported - view
Re: parseJSON
So to finetune your json code more, if you want to use spaces instead of the underscores_ you must put your key names between single quotes, also you need to convert all the numbers to text,…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
3 mths ago
Get help
Reported - view
Re: parseJSON
@Leo Woer I have folowing code in a button, where i have the json in a formula field "FactuurJSON" and a image field "JSONimagefield" : let txt := formatJSON(FactuurJSON); JSONimagefield :…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
3 mths ago
Get help
Reported - view
Re: parseJSON
@Leo Woer If Kundeavn is a relation field to your client then you can shorten the code like this. Also to get more items using a loop, you can use the following code.…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
3 mths ago
Get help
Reported - view
Re: parseJSON
@Leo Woer can you put this in a formula field and check if you get a right JSON or any errors? let Xkunde := Kundenavn; this.{ invoices: [ { recipient: text((select Kunder where Kundenavn = Xkunde).…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
3 mths ago
1
Get help
Reported - view
Re: parseJSON
@Leo Woer The JSON is still not valid: You "product":1", is missing a comma and there is also a comma too much at the end: this is your working JSON: { "invoices":[ { "recipient": "23022", "date": "",…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
3 mths ago
Get help
Reported - view
Re: parseJSON
Well, the first line doesn't seem to be right: { "invoices":[
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
3 mths ago
Get help
Reported - view
Re: New KPI's Switch Card ( Earned Value Management )
Impressive work @Rafael !
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
3 mths ago
Learn and share
Reported - view
Re: Modularity FAQ and quick start
@Sotirios Zormpas These settings are not yet available on the public cloud. It is still in the beta stage and will be rolled out gradually. Once you get these possibilities you can find the settings…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
4 mths ago
Modules
Reported - view
Re: Modularity FAQ and quick start
@Fred Are you aware that the data is duplicated from the connected module? This does not benefit the file size... see point 8, which states that the data remains but is no longer synchronized.
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
4 mths ago
Modules
Reported - view
Re: Different views on on page
@Philip Meinertz in the "Formula" you have to use a formula to whicht table you want to use : select Table1 for example. Then you can go to the Edit columns button and there you can filter like you…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
4 mths ago
1
Get help
Reported - view
Re: New Ninox 3.17
Version 3.17 in now live. Release notes
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
4 mths ago
Learn and share
Reported - view
Re: is there a group of macos local/icloud users dedicated to functions ?
@laurentandninox No, the database contains every language, it’s only the German Forum…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
4 mths ago
Learn and share
Reported - view
Re: is there a group of macos local/icloud users dedicated to functions ?
@laurentandninox This thread might also be of interest: https://forum.ninox.de/t/p8yz57m
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
4 mths ago
Learn and share
Reported - view
1
2
3
4
5
65
Ninox-Website
Overview
Learn and share
Get help
Service status
Documentation
Solutions
Ninox E-Invoice
Setup
Installed apps
Public Cloud
Private Cloud
On-Premises
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
View all topics