Skip to main content
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
Setup
Databases
Automation
My account
Administration
Webinars
Overview
Profile
Sean
Sean
1762
79
0
Joined: Tue Jul 31 23:45:13 UTC 2018
Follow
Coding Dart/Flutter in my spare time
My Posts
Latest Posts
Re: Editing the content of text files
You haven't said where the text file to import is located. You might want to check out this thread...…
Sean
Sean
4 yrs ago
Get help
Reported - view
Re: Where can I find a list of the functions used in Ninox ?
Just curious, what kind of commands or functions were you expecting? If you were looking for SQL commands, I'm pretty sure Ninox is a NoSQL database even though it isn't advertised as such that I…
Sean
Sean
4 yrs ago
Get help
Reported - view
Re: Where can I find a list of the functions used in Ninox ?
https://ninox.com/en/manual/calculations/reference-of-functions-and-language
Sean
Sean
4 yrs ago
Get help
Reported - view
Re: calculate miles driven
Mark, take a look at this thread and see if it works for you... https://ninox.com/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/question-5c40c978b03a5d15e04ad2e6?…
Sean
Sean
4 yrs ago
Get help
Reported - view
Re: Half screen view
You can modify the width of the popup form by dragging the left edge of the form, but you're right about it making it difficult to design a consistent user layout.…
Sean
Sean
4 yrs ago
Get help
Reported - view
Re: Editing the content of text files
It really doesn't get much easier than copying and pasting the text into a Text (multiline) field. Like you said, you can use the createTextFile function to copy the contents of the Text (multiline)…
Sean
Sean
4 yrs ago
Get help
Reported - view
Re: Printing?
I haven't watched the whole video, but I did find a point in the video where he saves to the desktop. What pops up when he clicks on the button is his PDF app.…
Sean
Sean
4 yrs ago
Get help
Reported - view
Re: Table with lots of records does not open
Don't have a Formula field that uses select
Sean
Sean
4 yrs ago
Get help
Reported - view
Re: Printing?
Dean, I thought you might post the link. I guess I should have been more patient ;-)
Sean
Sean
4 yrs ago
Get help
Reported - view
Re: Printing?
https://www.youtube.com/watch?v=_FA5-uMV8u8 It will take about hour and twenty minutes out of your day.
Sean
Sean
4 yrs ago
Get help
Reported - view
Re: Change
Hi Olivier, In my code there is a user-defined function named numberToWord. By using a function, you can reduce repeated code, but the important thing here is you've got it working.…
Sean
Sean
4 yrs ago
Get help
Reported - view
Re: Change
Olivier, well done. The only thing I would do differently is use the user-defined function and you can deleted the "void;". Glad you got it working. :)
Sean
Sean
4 yrs ago
Get help
Reported - view
Re: Why was "void" inserted?
I think the compiler/transpiler is letting you know the code doesn't do anything. I assume this is a test of variable scope. Here's another one :) let a := 2;let b := 3;if 1 = 1 thenlet a := 1;b :…
Sean
Sean
4 yrs ago
Get help
Reported - view
Re: Unique number
I would modify the alerts to include the table names so you know which table(s) has/have a match. let myField1 := 'N° interne';if cnt(select Aspirateur where 'N° interne' = myField1) > 0…
Sean
Sean
4 yrs ago
Get help
Reported - view
Re: Unique number
If you want to check multiple tables, you can't use nested if statements and you can't use else. You need to test each table individually... let myField1 := 'N° interne';…
Sean
Sean
4 yrs ago
Get help
Reported - view
Re: Unique number
Right, but I think my definition of a failed test is different than yours. When the if statement test condition fails or returns false, none of the code inside that if statement is executed so none…
Sean
Sean
4 yrs ago
Get help
Reported - view
Re: Unique number
I don't know if this is what you entended, but if the test fails on one of the if statements none of the following if statements will execute.
Sean
Sean
4 yrs ago
Get help
Reported - view
Re: Retrievieng values from existing records
A saw is useless if you are trying to drive a screw into wood. Doesn't mean the saw is useless if you are using it for its correct purpose. It's not clear to me what you are trying to accomplish.…
Sean
Sean
4 yrs ago
Get help
Reported - view
Re: Multiple choice numerical output that results in more than 1 digit [ie 10, 11...etc] returns null.
I think what you want is the numbers() function. Note, the function is plural and not number().…
Sean
Sean
4 yrs ago
Get help
Reported - view
Re: Button Color
I guess Birger had a moment of inattentiveness.
Sean
Sean
4 yrs ago
Get help
Reported - view
Re: Button Color
It's a Formula field
Sean
Sean
4 yrs ago
Get help
Reported - view
Re: Documentation.
I wasn't going to participate in this thread because @Kim was making valid points without my help and because I'm simply tired of a topic that has been met with token appeasement and apparent apathy…
Sean
Sean
4 yrs ago
Learn and Share
Reported - view
Re: Documentation.
Best Practices? I suppose beauty is in the eye of the beholder. https://ninox.com/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/phone-number-formatting-5b1de229d392e43c7a90d130
Sean
Sean
4 yrs ago
Learn and Share
Reported - view
Re: Rich text in Formula field
xOrderdetail := xOrderdetail + "<b>ITEM #</b>" + i.Items.Number + " - " + i.Items.Description + " - " + "<b>QTY </b><br>" + i.Qty + "<br><br><b>" + i.Formula + "</b>" I forgot to clean up some of the…
Sean
Sean
4 yrs ago
Get help
Reported - view
Re: Rich text in Formula field
Build your xOrderdetail string first, then use the html() function. xOrderdetail := xOrderdetail + "<b>ITEM #</b>" + " " + i.Items.Number + " - " + i.Items.Description + " - " + "<b>QTY</b><br>" + i.…
Sean
Sean
4 yrs ago
Get help
Reported - view
1
31
32
33
34
35
71
Ninox-Website
Overview
Learn and Share
Get help
Service status
Documentation
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
Scripting
Functions
API
My account
Subscriptions
Administration
Manage workspaces
Manage collaborators
Access permissions
Usage overview
Process monitor
View all topics