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
1619
posts
226
likes received
5
followers
Badges
Latest Posts
Re: Dynamic Reports - my first attempt
Hello, Carbone is very strict with placeholders: see manual here or here. Hope this helps.
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Get help
Reported - view
Re: storing system variables
Nifty, thanks 👍
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Learn and share
Reported - view
Re: attachments: Add from another table
@Alan Cooke Maybe this post can help you....
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Get help
Reported - view
Re: Display a maximum number of data
order by -number(Id) should work if the last record holds the latest date as in my example code.
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Get help
Reported - view
Re: How to pop up a dialog if a record in a table meets a criteria.
IFD Engineering Sorry for the confusion, this is the whole code (I think that should work): if cnt(select Reminders where 'Next Date' = today()) > 0 then let result := dialog("A reminder is due today.…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Get help
Reported - view
Re: Display a maximum number of data
Not sure how your tables are configured but this is something that could work: let me := this let n := slice((select 'Historique des activités 1:N' where Compte = this) order by -number(Id), 0, 5);…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Get help
Reported - view
Re: How to pop up a dialog if a record in a table meets a criteria.
Change the first 4 lines code in and see if this works: if cnt(select Reminders where 'Next Date' = today()) > 0 then
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Get help
Reported - view
Re: Rest Api filtering documentation
@Jesper Ordrup You could make a global function in Ninox where you query the data you need, for example > global function: function getorders(variable :…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Get help
Reported - view
Re: Avoid spaces in a sum function when a variable is empty/void
Or maybe a oneliner ? 😉 Article + if Color then " " + Color end + if 'More stufs' then " " + 'More stufs' end + if Kg then " " + Kg end + if Lt then " " + Lt end
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
1
Get help
Reported - view
Re: Managing a database
You could also share a view as html and place the link in a webpage or share the link in a mail... if that helps or you can create your own webpage where you fetch the shared json information in a…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Get help
Reported - view
Re: JSON: add a block based on a given condition
I would make the formula/codeblock in a text-format (where you can use the if...then) and then use the eval() function to execute the code.
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Get help
Reported - view
Re: NEW: Dynamic print layouts for public cloud
If this helps... You could also make an json without the API with a select function. For example: (select 'users benelux').{ eml: email, Firstn: Firstname, Lastn :…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Learn and share
Reported - view
Re: NEW: Dynamic print layouts for public cloud
@Jérôme Leleu Since you only need one record from your tableB, You could also put formula fields in your TableA with the last record-fields you need. Then you can use those fields in your…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Learn and share
Reported - view
Re: Database Search
@orsadoc You can also share a view as HTML (if you have cloud subscription) Or make a webpage and import the data as json with a fetch() function. (Also requires a cloud subscription).…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Get help
Reported - view
Re: All-day 'Appointments'
@andrew Did you know if you use the month view, you get the wanted result? I know, your solution is kinda cumbersome but works. There is no other solution for now I guess.…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Get help
Reported - view
Re: The New IPhone Display Mode
@Roger Ninox has recently released a universal version of the Ninox app on ipad and iphone. The old 'legacy' version will no longer be supported/updated soon. Not sure which version you have though...…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Learn and share
Reported - view
Re: Server Not Responding Rant
Fred on what pricing plan are you on? Seems that Starter doesn't do email support?
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Learn and share
Reported - view
Re: HTML/Rich Text does not work on print record
@Daniel Marine If I remember it right, you could ask Ninox support to change the print engine. Maybe ask your question directly to support@ninox.com with your login mail and the Team name.
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Get help
Reported - view
Re: Server Not Responding Rant
@Fred It must have been very frustrating. Everything okay now?
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Learn and share
Reported - view
Re: How to print a linked image from print layout?
@Sébastien Guillet If I remember it right, you could ask Ninox support to change the print engine. Maybe ask your question directly to support@ninox.com
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
1
Get help
Reported - view
Re: member access and security
@gary You need to take a manual backup of the database, then go to the manage backups and download to your computer. Then you go to the other team and upload the database again.
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Learn and share
Reported - view
Re: member access and security
The simplest way to do this is to create a new Workspace and just put the database 'Household' in there. Then invite your employee to this Workspace. He will only be able to see this database.…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Learn and share
Reported - view
Re: Matching Phone Area Codes to Region
That's weird. Can you post a sample database? Or give some screenshots of your table? You may also invite me to your team (as admin) to have a look at it if you want.
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Get help
Reported - view
Re: Multiply a number to get a status
@Sébastien Guillet you would need some kind of trigger to do that and since a formula field isn't able to trigger or change any data field, you need a static field that holds the Niveau de fidélité…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
1
Get help
Reported - view
Re: Matching Phone Area Codes to Region
Since I use formula fields, they are automatically filled. If you want to do this with static fields, you can use this in a Button or in the console to update all the static fields (here I use…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Get help
Reported - view
1
11
12
13
14
15
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