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: Font in print layout
@thomas You can't use special characters for the field names, also no spaces. More explanation about Carbone here The used font has to be installed on both computers I guess.
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
1
Get help
Reported - view
Re: Font in print layout
@thomas well, if you jump to time 11:40 in this video you'll get some explanation how dynamic print layouts work.
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
1
Get help
Reported - view
Re: send e-mail problem
@Jan Inge Iversen well, this with the sendEmail() function. Sending the email with a email field works fine.
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Get help
Reported - view
Re: Font in print layout
Since html styled text looses the styling when printed out on PDF. The only possible solution i guess, is to work with dynamic print layouts. More about the dynamic printlayouts here.
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Get help
Reported - view
Re: Styling a portion of a formula
maybe change this in your last line code: html("<div> <span style='color:red;'>[" + text(PROTOCOL) + "]</span></div>")
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Learn and share
Reported - view
Re: Styling a portion of a formula
@Alan Cooke Like @Fred said, you could use html with CSS styling to do so: html("<div> Attached files: <span style='background-color:red;color:white;'> " + Files + "</span> ➡️" + BUILDING.…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
1
Learn and share
Reported - view
Re: Dynamic select unique : can you please help me to translate this code on NINOX for dynamic selection
unique([1,1,2,3,4,4,5,6,6,7,8,8,9]); Gives as result = 1,2,3,4,5,6,7,8,9 See : https://docs.ninox.com/en/script/function-overview/functions/unique for more about the unique() function.
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Get help
Reported - view
Re: Strikethrough text in formula
@pirinisz Strange... What do you get if you put the position field in a variable? let txt := text(position); if status then html("<p style='background-color:red;color:white;text-align:center;…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Get help
Reported - view
Re: Strikethrough text in formula
@pirinisz Maybe there's something wrong in your code? On my end it works. The field containing the formula is a formula field, the field 'position' is a text field and the field 'status' is a Yes/No…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Get help
Reported - view
Re: Strikethrough text in formula
You can use CSS styling also: if status then html("<p style='background-color:red;color:white;text-align:center;text-decoration-line:line-through;'>" + position + "</p>") else html("<p…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Get help
Reported - view
Re: Combining two dates fields into single appointment field
@Holly M Try this: AppointmentField := appointment(datetime(date(Startdate), time(0, 0)), datetime(date(Enddate), time(23, 59)))
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Get help
Reported - view
Re: How to clear/null a reference combo box
@Holly M I didn't use null but the number zero: 0 Does that work?
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Get help
Reported - view
Re: How to clear/null a reference combo box
@Holly M 'Tasks to Apply' := 0 is the command to clear a reference field
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Get help
Reported - view
Re: can I hide a table only for one user?
@Javier Gómez One possible solution (trick) is, you leave the Tables on "hidden" and use a button that only displays if userIsAdmin() and jump to the disired Table with the openTable() function.
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Get help
Reported - view
Re: Integrating eMail HTML code for Outlook appointment invitation
You are talking about adding a .ICS file as attachment in your email right? By making a text-file in the .ICS format and attach this in your email can work.…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Learn and share
Reported - view
Re: Conditional formula
Something like this: join(for i in slice('Posts' [checkboxfield] order by numberfield , 0,2)do i.'Position' + " " + i.'name' end, " / ")
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
1
Get help
Reported - view
Re: Conditional formula
try this: join(for i in 'Posts' [checkboxfield] order by numberfield do i.'Position' + " " + i.'name' end, " / ")
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
1
Get help
Reported - view
Re: Two condition nested If not working
let days_delta := 'Due Date' - today(); let display_color := if days_delta <= 0 then "red" else if days_delta > 10 then "green" else "orange" end end; styled(text(days_delta), display_color)
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Get help
Reported - view
Re: Warning of dynamic multi choice bug
Thanks for the warning @Fred 👍
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
3 yrs ago
Learn and share
Reported - view
Re: creating a linked record in a subtable within a script
Try this: let me := this; let i := create subtable; i.(ParentTable := me)
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
3 yrs ago
Get help
Reported - view
Re: Mutually exclusive choices
Create a table for your Car brands (Citoën,Volvo, Saab,...) (Table with one text field) Now on your Cars form, make a link-to field and set this field to "show field as" COMBOBOX.…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
3 yrs ago
Get help
Reported - view
Re: Calendar missing some dates
Maybe the formula "show as" gives an empty result? But you still should see some empty colored line. Tested on the cloud-version v3.7.14 in Chrome
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
3 yrs ago
Get help
Reported - view
Re: Embedded Vimeo videos
@Jacques TUR The old domain - API with Ninox was www.ninoxdb.de ? Maybe the request is send trought this interface? The old interface api.ninoxdb.de/v1 continues to work,…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
3 yrs ago
Get help
Reported - view
Re: Embedded Vimeo videos
@Jacques TUR Seems like you can also use the Vimeo API player used in a <div> when you have problems to display in an iframe. html(" <script src='https://player.vimeo.com/api/player.…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
3 yrs ago
Get help
Reported - view
Re: Formula colour
You can use the styled() function in your formula field: styled(text('Choice with colors'), color('Choice with colors')) Where "Choice with colors" is your choice field.
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
3 yrs ago
2
Get help
Reported - view
1
15
16
17
18
19
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