RoSoft_Steven's Profile | Ninox Community

Badges

Latest Posts

Re: Insert multiple elements into case of switch
I think this (adding {} ) will work: switch 'Progress Bill' do case 1: 'End data' := null case 2: {'Total Price' := 0; 'End data' := null} case 3: 'End data' := null default: "Error" end
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Elimination of decimal numbers
You can use the round() function: round(A * B / 100,2)
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
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.
- Ninox partner
- RoSoft_Steven.1
- 3 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.
- Ninox partner
- RoSoft_Steven.1
- 3 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.
- Ninox partner
- RoSoft_Steven.1
- 3 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.
- Ninox partner
- RoSoft_Steven.1
- 3 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>")
- Ninox partner
- RoSoft_Steven.1
- 3 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.…
- Ninox partner
- RoSoft_Steven.1
- 3 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.
- Ninox partner
- RoSoft_Steven.1
- 3 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;…
- Ninox partner
- RoSoft_Steven.1
- 3 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…
- Ninox partner
- RoSoft_Steven.1
- 3 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…
- Ninox partner
- RoSoft_Steven.1
- 3 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)))
- Ninox partner
- RoSoft_Steven.1
- 3 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?
- Ninox partner
- RoSoft_Steven.1
- 3 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
- Ninox partner
- RoSoft_Steven.1
- 3 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.
- Ninox partner
- RoSoft_Steven.1
- 3 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.…
- Ninox partner
- RoSoft_Steven.1
- 3 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, " / ")
- Ninox partner
- RoSoft_Steven.1
- 3 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, " / ")
- Ninox partner
- RoSoft_Steven.1
- 3 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)
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Warning of dynamic multi choice bug
Thanks for the warning @Fred 👍
- 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)
- 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.…
- 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
- 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,…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view

1 15 16 17 18 19 65

Welcome to the Ninox community

RoSoft_Steven

Re: Insert multiple elements into case of switch

Re: Elimination of decimal numbers

Re: Font in print layout

Re: Font in print layout

Re: send e-mail problem

Re: Font in print layout

Re: Styling a portion of a formula

Re: Styling a portion of a formula

Re: Dynamic select unique : can you please help me to translate this code on NINOX for dynamic selection

Re: Strikethrough text in formula

Re: Strikethrough text in formula

Re: Strikethrough text in formula

Re: Combining two dates fields into single appointment field

Re: How to clear/null a reference combo box

Re: How to clear/null a reference combo box

Re: can I hide a table only for one user?

Re: Integrating eMail HTML code for Outlook appointment invitation

Re: Conditional formula

Re: Conditional formula

Re: Two condition nested If not working

Re: Warning of dynamic multi choice bug

Re: creating a linked record in a subtable within a script

Re: Mutually exclusive choices

Re: Calendar missing some dates

Re: Embedded Vimeo videos

Overview