Skip to main content

Forum

Welcome to the Ninox community

Search all topics or ask a question

Latest Posts

Re: Types of parameters for a private function
Ooops, to get the output... replaceArrayItem("Swift", 3); myArray then click run
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Types of parameters for a private function
So, I had some time to kill because the retards in Birmingham, Al closed two lanes of traffic on I-459 for road construction. They could have sent traffic through downtown this being a Sunday and all!…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Types of parameters for a private function
As long as an array is defined before the user-defined function, you can manipulate the array inside the function.
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Types of parameters for a private function
As far as I can tell the only data types you can use in a user-defined function are the following... Number, Text, Date, Time and DateTime If you try use array,…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Zip Code Populate city and state?
Nice!
- Sean
- 7 yrs ago
- Get help
- Reported - view
Re: Zip Code Populate city and state?
If you had a table with Zip Codes, you could use something like this in "Trigger after update". let myCustomer := this;City := text((select ZipCodes)[ZipCode = myCustomer.ZCode].…
- Sean
- 7 yrs ago
- Get help
- Reported - view
Re: Zip Code Populate city and state?
Where are you going to get the zip code information? https://gis.stackexchange.com/questions/53918/determining-which-us-zipcodes-map-to-more-than-one-state-or-more-than-one-city
- Sean
- 7 yrs ago
- Get help
- Reported - view
Re: Change All Table Values by Button
You can loop through the records, but I don't think you can loop through the fields. You would have to include each field in the record loop like this... for r in (select 'Show Details') r.…
- Sean
- 7 yrs ago
- Get help
- Reported - view
Re: calculate a percentage with a multiple choice formula
It works for me... Are you sure you are using a Choice field and not Multiple Choice?
- Sean
- 7 yrs ago
- Get help
- Reported - view
Re: Is there a way calculation that would count the number of words in another field in the same record?
This should do it... count(splitx(FieldName, "\s"))
- Sean
- 7 yrs ago
- Get help
- Reported - view
Re: relation n:m
I have a test database with Table1 and Table2 and Table2 is a composition table. The following code works to unlink an individual record from Table2 that is linked to Table1.…
- Sean
- 7 yrs ago
- Get help
- Reported - view
Re: calculate a percentage with a multiple choice formula
Try this in your formula field: let myOui := count((select YourTable)[text('1er essai') = "Réussi"]);let myNon := count((select YourTable)[text('1er essai') = "Loupé"]);…
- Sean
- 7 yrs ago
- Get help
- Reported - view
Re: Change
Penny won't work correctly as it is now. Here is a link to a List of Circulating Currencies: https://en.wikipedia.org/wiki/List_of_circulating_currencies
- Sean
- 7 yrs ago
- Get help
- Reported - view
Re: Change
Nick, you're welcome. There is another simple change that can expand it's usefulness if you use multiple currencies. Create a table for currencies like this:…
- Sean
- 7 yrs ago
- Get help
- Reported - view
Re: Change
This just describes the whole Euro amounts without the "and no Cents". let empty := "";let x := [empty, "One ", "Two ", "Three ", "Four ", "Five ", "Six ", "Seven ", "Eight ", "Nine ", "Ten ",…
- Sean
- 7 yrs ago
- Get help
- Reported - view
Re: Change
This is the complete formula. It checks for single and plural amounts and adds "and no cents" if there isn't any change. I'll post the same formula without the "and no cents" after this.…
- Sean
- 7 yrs ago
- Get help
- Reported - view
Re: Change
Nick, thanks for the screenshots. When I saw the system settings screenshot, I wanted to facepalm! It is a simple fix on these 2 lines: if contains(text(numAmount), ".…
- Sean
- 7 yrs ago
- Get help
- Reported - view
Re: Change
Hi Nick, I'm happy to contribute. Do the non-English versions of Ninox allow the storage of numbers using "," as the decimal separator? If so, what is the thousands, or grouping, separator?…
- Sean
- 7 yrs ago
- Get help
- Reported - view
Re: Change
Can't see the forest for the trees department... Since Ninox does not store numbers with a "," as a decimal separator, you would be converting from a number that already exists in your database,…
- Sean
- 7 yrs ago
- Get help
- Reported - view
Re: Change
Hello, Would you please post the formula you use to produce the number with comma decimal separator. I tried to do it with the format() function and it's not working.
- Sean
- 7 yrs ago
- Get help
- Reported - view
Re: Change
Also, do you use Euro or Euros for more than 1?
- Sean
- 7 yrs ago
- Get help
- Reported - view
Re: Change
Yes, the current code checks for "." as the decimal separator. What symbol do you use for the thousands separator? How many digits to the right of the decimal separator do you use?
- Sean
- 7 yrs ago
- Get help
- Reported - view
Re: Change
This code adjusts for Euros and tests for 0.00 let empty := "";let x := [empty, "One ", "Two ", "Three ", "Four ", "Five ", "Six ", "Seven ", "Eight ", "Nine ", "Ten ", "Eleven ", "Twelve ",…
- Sean
- 7 yrs ago
- Get help
- Reported - view
Re: Change
The last code post on page 4 does this (next to last post).
- Sean
- 7 yrs ago
- Get help
- Reported - view
Is there a better way to filter selected table for View Layout Element?

Is there a built in way to filter linked Id's for the View element? This is what I have right now... It works, but it is static. The filter is hard coded and I don't see any way to make it…
- Sean
- 7 yrs ago
- 2283
- Get help

1 65 66 67 68 69 70 71

Back to top

Overview

View all topics