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: Ver 3.10 - new PAGES Feature
@Fred Seems like@Leonid Semik made a conversion tool to convert tables into pages. Check the German-language forum here
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
1
Learn and share
Reported - view
Re: select where statement.
Only INVENTORY needed
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Get help
Reported - view
Re: <span onclick> , Is it possible in a Formula (html) with for from to do loop ?
Here you are: let list := join(for i in select Persons do "<span onclick=""ui.popupRecord('" + raw(i.Id) + "')""; style=""color: DarkRed; cursor: pointer;"">" + i.…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
3
Get help
Reported - view
Re: <span onclick> , Is it possible in a Formula (html) with for from to do loop ?
https://forum.ninox.com/t/83yhcrc/split-function-help#m1yh4zh Is an example
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Get help
Reported - view
Re: Split Function Help
@Fred I don't think Ninox will remove this because their new template "Leave Planner" is also using this. It is a very educational template.
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
1
Get help
Reported - view
Re: Split Function Help
This code also works: let list := split(Genres, ", "); let src := join(for i in range(0, cnt(list)) do "<span onclick=""ui.openRecord('" + raw(first((select Genres)[Genre = item(list, i)]).…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
1
Get help
Reported - view
Re: Split Function Help
what about this? First generate the html code lines outside the html and then inject it with your other html code... let list := split(Genres, ", "); let genrelines := join(for i in range(0,…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Get help
Reported - view
Re: Split Function Help
Is this is not what you want? Don't you need 1 or 2 or 3 or ... clickable lines in your html output? You can adapt the code to get them all in one line i guess.…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Get help
Reported - view
Re: Split Function Help
let list := split(Genres, ", "); join(for i in range(0, cnt(list)) do "<span onclick=""ui.openRecord('" + first((select Genres)[Genre = item(list, i)]) + "')""; style=""color: #1E90FF; cursor:…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Get help
Reported - view
Re: Get the number of the chosen entry in a Dynamic Choise field
I have a formula to those 2 buttons but you'll need to adapt them to your requirements: prev button: let rec := record(Names,number(DynChoice)); let c := index((select Names) order by Name, rec);…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
1
Get help
Reported - view
Re: Sort json?
@Kruna Yes, That would be incredibly kind of @Rafael 👍
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Get help
Reported - view
Re: Printing a VIEW ? This is how it can be done:
@Fred Responce from support: The error is known and is already being worked on intensively. It should be fixed with an update within the next 2 weeks. We don't know the version number of the update…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
1
Learn and share
Reported - view
Re: Sort json?
@Rafael Wow, that dashboard looks great! Even with the sunrise and sunset and moon phase.... I love it!
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Get help
Reported - view
Re: Sort json?
Can you send a sample database?
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Get help
Reported - view
Re: Delete Files added to paper clip
@Mel Charles Weird. Did you try on my example database? In table view, the images are still there? And when you refresh ⭮ the table?
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Get help
Reported - view
Re: Printing a VIEW ? This is how it can be done:
@Fred Oh, Really? However, carbone offers its test prints unlimited in every price plan. This must probably be a bug in Ninox. I will check with Ninox support and get back to you on this.
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Learn and share
Reported - view
Re: Printing a VIEW ? This is how it can be done:
@Alan Cooke The watermark is for test-printing (with slider on in print editor)? this will not be deducted from your monthly dynamic print allowance (100 for starter and 500 for professional) Yes,…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Learn and share
Reported - view
Re: Delete Files added to paper clip
@Mel Charles Sure, here's the code: let method := "DELETE"; let teamid := DatabaseTeam; let dbid := DatabaseID; let tid := TableID; let cont := "application/json"; let bear :…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Get help
Reported - view
Re: Formula help
You can configure a formula field as a button too. (more options > On click) Or change the code to : let xMasterID := 'Master ID'; let x = first(select Master where 'Master Release Number' =…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Get help
Reported - view
Re: Delete Files added to paper clip
@Mel Charles@Rafael Script is for the current record only. Following code is for the entire table and all the attachments in the paperclip-tab. let method := "DELETE"; let teamid := DatabaseTeam;…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
1
Get help
Reported - view
Re: Delete Files added to paper clip
@Mel Charles Bearer is the type of authorization method Ninox is using. Other examples are API key, Basic Auth,OAuth 1.0, .... The Ninox API key is for your entire cloud subscription.…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Get help
Reported - view
Re: Delete Files added to paper clip
@Mel Charles I mean, if you use a script to empty the Imagefields (Imagefield := null), aren't the files not still present in the attachment (paperclip) tab? In my case they do... 🤔
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Get help
Reported - view
Re: Printing a VIEW ? This is how it can be done:
@Rafael Are you making the template with microsoft Word? You need to re-upload (with the command replace... when clicking on the template-name) the new file in the print editor to make it work.
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Learn and share
Reported - view
Re: Delete Files added to paper clip
Mel CharlesPutting a sample database here, only place a api-key in the settings table: You can make a iteration (for i in .... do) for all the records then...
Attachment
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
1
Get help
Reported - view
Re: Printing a VIEW ? This is how it can be done:
Rafael Sorry for my lack of clarity. In the print editor of the dashboard table:
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Learn and share
Reported - view
1
8
9
10
11
12
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