Sean

1762
79
0

Joined: Tue Jul 31 23:45:13 UTC 2018

Coding Dart/Flutter in my spare time

My Posts

Latest Posts

Re: Console Window Input Panel
I don't think it is currently possible.
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Sort related records by specific field
select is required to filter and sort using script.
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: New line in text-field
Try option+return.
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: This expression returns a total of Rev-Amount from my Revenue subtable until the "where" portion is inserted. Any idea why?
Try this... sum((select Revenue where Revenue.'Credit To' = 1).'Rev-Amount') I wasn't sure if the colon was a part of the 'Credit To' field name so I didn't include it.
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Multiple Choice in nested if formula
Wynand, It will work with a switch statement. Below is a short example of all the possible choice combinations, just modify to suit your needs. switch concat(chosen(Country)) docase "Europe":…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Console vs Button on Click using Mac App.
@Mconneen, What's the performance like if you run the process with the data stored on your local computer?
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Is in Ninox a text simplification formula?
There might be a better way using Regex, but I just used the replace() function here... replace(replace(replace(replace(Text, "ľ", "l"), "ď", "d"), "š", "s"), "á", "a")
- Sean
- 4 yrs ago
- Learn and Share
- Reported - view
Re: Get error using "number(chosen(field))" inside a formula
Per the manual, https://ninoxdb.de/en/manual/calculations/reference-of-functions-and-language Type ConversionNumber Functionsnumber(value)Tries to interpret the given value as a number.…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Global script definitions
Currently, you need to go to the app store to see the version number.
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Global script definitions
It allows you to create your own functions that can be used anywhere in the same database. This is all that is available in the manual... Creating User defined functions locally with the function…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: How to modify the view of the file .txt created with createTextFile ?
Insert a "return" in the formula... createTextFile(this, Name + "" + Surname, "prova.txt")
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Issues re-ordering tables in side-bar
The same thing happened to me. I don't know which operation made it work, but I continued to add tables and I also closed all apps and power cycled my computer and then I was able to arrange the…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: How can a count the number of letters and space in a field ?
In a formula field you could use this... rpad(Name, 30, " ") + rpad(Surname, 50, " ") When you enter the space, you need to use option+space. To use rpad() with a number you would need to convert the…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: How can a count the number of letters and space in a field ?
You can enter this in "Trigger after update" of the Text field... YourField := rpad(YourField, 50, " ")
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: select not working
I'm just speculating... The select command returns an array so by using the number() function you are comparing number type to number type. If you use record(TableName, 1).…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Multiple Choice in nested if formula
If you are modifying a Field it would need to go in a Trigger or a Button
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: select not working
Try number(Id)
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: How to assign a table's identifier to a variable, i.e. not hardcode table names in functions?
I don't have a solution, but I am curious. In your dashboard would you enter the table name and record number in a single text field if that would work?
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Multiple Choice in nested if formula
I got a chance to look at what you posted on my computer instead of my phone. In the image I show what you have and below that a corrected version. I would still use a switch statement though.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: How to assign a table's identifier to a variable, i.e. not hardcode table names in functions?
This might be too close to hardcoding, but it's the only solution that I know of. Personally, I would use a Choice field, but it would also work for a Text field if you like to type everything in.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Console to test sql/nx statements
I don't work for Ninox and I can only speak from observation. I believe the output of the Console is limited to a single command line. If you want to do something more complex,…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Console to test sql/nx statements
Instead of using two separate lines make it one with a line feed between them. let A := [10, 20, 30];for j in A do"square= " + j * j + "" + "cube= " + j * j * j;end
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Multiple Choice in nested if formula
I suppose it depends on what you choose to focus on. I would still use a switch statement, especially considering the quantity of possible choices.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Multiple Choice in nested if formula
It looks like you should be using a Choice field instead of a Multiple Choice field since you are testing for only one of 8+ possible selections. You are missing an "else" after the "USA" test and…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Replacing one value in a field with another value for records that match
There are a couple of ways that I know of. You can use "Update Multiple Records", select "Assign calculated value" and use this formula... if NumberField = 1 thennumber(replace(text(NumberField), "1",…
- Sean
- 5 yrs ago
- Get help
- Reported - view

1 37 38 39 40 41 71

Welcome to the Ninox community

Sean

My Posts

Re: Console Window Input Panel

Re: Sort related records by specific field

Re: New line in text-field

Re: This expression returns a total of Rev-Amount from my Revenue subtable until the "where" portion is inserted. Any idea why?

Re: Multiple Choice in nested if formula

Re: Console vs Button on Click using Mac App.

Re: Is in Ninox a text simplification formula?

Re: Get error using "number(chosen(field))" inside a formula

Re: Global script definitions

Re: Global script definitions

Re: How to modify the view of the file .txt created with createTextFile ?

Re: Issues re-ordering tables in side-bar

Re: How can a count the number of letters and space in a field ?

Re: How can a count the number of letters and space in a field ?

Re: select not working

Re: Multiple Choice in nested if formula

Re: select not working

Re: How to assign a table's identifier to a variable, i.e. not hardcode table names in functions?

Re: Multiple Choice in nested if formula

Re: How to assign a table's identifier to a variable, i.e. not hardcode table names in functions?

Re: Console to test sql/nx statements

Re: Console to test sql/nx statements

Re: Multiple Choice in nested if formula

Re: Multiple Choice in nested if formula

Re: Replacing one value in a field with another value for records that match

Overview