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
1760
79
0
Joined: Tue Jul 31 23:45:13 UTC 2018
Follow
Coding Dart/Flutter in my spare time
My Posts
Latest Posts
Re: Change
This should take care of that problem. It also checks for 0 cents so the "and" won't be displayed in that case. let empty := "";let x := [empty, "One ", "Two ", "Three ", "Four ", "Five ", "Six ",…
Sean
Sean
6 yrs ago
Get help
Reported - view
Re: Change
You’re welcome. I agree Ninox is pretty amazing. It’s going to be interesting to see what areas they focused on when they release the next update.
Sean
Sean
6 yrs ago
Get help
Reported - view
Re: Change
For anyone who is interested in output of the mod() function here is a mockup spreadsheet:
Sean
Sean
6 yrs ago
Get help
Reported - view
Re: Change
This is the code for Cents Words: let empty := "";let x := [empty, "One ", "Two ", "Three ", "Four ", "Five ", "Six ", "Seven ", "Eight ", "Nine ", "Ten ", "Eleven ", "Twelve ", "Thirteen ",…
Sean
Sean
6 yrs ago
Get help
Reported - view
Re: Change
I just did both and I changed my field name to Net so you don't have to change anything. This is the code for Cents Fraction: let empty := "";let x := [empty, "One ", "Two ", "Three ", "Four ",…
Sean
Sean
6 yrs ago
Get help
Reported - view
Re: Change
Do you want it as 50/100 or Fifty Cents?
Sean
Sean
6 yrs ago
Get help
Reported - view
Re: Change
For some reason the user defined function is truncating the "0". If the formula is used by itself, not as a function, it works. I'll try to figure it out later tonight. Gotta go to work now.
Sean
Sean
6 yrs ago
Get help
Reported - view
Re: Change
Also, please delete the line you added at the top of your screenshot.
Sean
Sean
6 yrs ago
Get help
Reported - view
Re: Change
let numAmount := Amount; is already in the formula. All you have to do is replace "Amount" with "Net".
Sean
Sean
6 yrs ago
Get help
Reported - view
Re: Change
The large numbers definitely highlighted the shortcomings of my solution so I did some searching online. I found a very nice solution here, http://www.techiedelight.…
Sean
Sean
6 yrs ago
Get help
Reported - view
Re: Check if a field is visible
There isn’t a “Visible” property that I’m aware of. You would have to check the condition you use to show/hide the field.
Sean
Sean
6 yrs ago
Get help
Reported - view
Re: Open database to table
Yep, OnOpen would do the trick since, openTable(tableName, viewName) already exists.
Sean
Sean
6 yrs ago
Get help
Reported - view
Re: Open database to table
No. There is a request for this already, so hopefully it will be implemented in a future update.
Sean
Sean
6 yrs ago
Get help
Reported - view
Re: link two tables automatically
If I understand you correctly, this should do what you want. I put this code in "Trigger after update" on Table1. let myTable1 := Id;let myText := Text;for i in (select Table2)[Text = myText] doi.…
Sean
Sean
6 yrs ago
Get help
Reported - view
Re: Change
Change the last line from, txtNumberWord to txtNumberWord + " usd"
Sean
Sean
6 yrs ago
Get help
Reported - view
Re: Change
I have confirmed this works with a formula field. All you have to do is copy and paste. let arySingles := ["", "One", "Two", "Three", "Four", "Five", "Six", "Seven", "Eight", "Nine", "Ten", "Eleven",…
Sean
Sean
6 yrs ago
Get help
Reported - view
Re: Change
After you have restored the number() functions, try let txtNumber := format(Net, “0”);
Sean
Sean
6 yrs ago
Get help
Reported - view
Re: Change
Wait! The only place you replace “Number” is in the line, let txtNumber := format(Number, “0”); You only replace it in that one location. You are replacing the number() function and you can’t do that.
Sean
Sean
6 yrs ago
Get help
Reported - view
Re: Change
“Number” in my case is a number field. I’m not sure if you can use a formula field in this situation. Try this, add a variable above “txtNumber” that is equal to the same formula you use in your…
Sean
Sean
6 yrs ago
Get help
Reported - view
Re: Change
It is currently only able to display numbers upto 9,999. When I get time, I'll try to update for larger numbers. Add a formula field to your table, copy the code and paste it to the formula field.…
Sean
Sean
6 yrs ago
Get help
Reported - view
Re: Change
Yep, this got stuck in my head. This works for whole numbers upto 9,999. let arySingles := ["", "One", "Two", "Three", "Four", "Five", "Six", "Seven", "Eight", "Nine", "Ten", "Eleven", "Twelve",…
Sean
Sean
6 yrs ago
Get help
Reported - view
Re: Changing field type
I think you have to create a Number field and copy the values from the Text field to the Number field. You can add a Button with this formula: for f in select Table1 dof.(Number := f.…
Sean
Sean
6 yrs ago
Get help
Reported - view
Re: Recap DB
@Mconneen, I have a tendency to overthink things. If all you’re wanting to is display the json result, wouldn’t a formula field work?
Sean
Sean
6 yrs ago
Get help
Reported - view
Re: Recap DB
You might have already come up with a solution, but this is a possible solution (Not tested in this specific case). Create a table specifically for global/persistent/placeholder variables and store…
Sean
Sean
6 yrs ago
Get help
Reported - view
Re: Change
I apologize, I misunderstood your original post. That would require some custom coding. I'm sure that's possible, but it would require a time commitment that I can't make right now.…
Sean
Sean
6 yrs ago
Get help
Reported - view
1
65
66
67
68
69
70
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