Skip to main content
Ninox-Website
Ninox-Documentation
How to enable Javascript
Sign Up
Log in
Learn & Share
Get help
Webinars
All topics
Contact
Privacy
Overview
Profile
Sean
Sean
1710
56
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
5 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
5 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
5 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
5 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
5 yrs ago
Get help
Reported - view
Re: Change
Do you want it as 50/100 or Fifty Cents?
Sean
Sean
5 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
5 yrs ago
Get help
Reported - view
Re: Change
Also, please delete the line you added at the top of your screenshot.
Sean
Sean
5 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
5 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
5 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
5 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
5 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
5 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
5 yrs ago
Get help
Reported - view
Re: Change
Change the last line from, txtNumberWord to txtNumberWord + " usd"
Sean
Sean
5 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
5 yrs ago
Get help
Reported - view
Re: Change
After you have restored the number() functions, try let txtNumber := format(Net, “0”);
Sean
Sean
5 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
5 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
5 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
5 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
5 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
5 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
5 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
5 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
5 yrs ago
Get help
Reported - view
1
63
64
65
66
67
68
69
Ninox-Website
Ninox-Documentation
Overview
Learn & Share
Get help
Webinars
View all topics