Contact Sales to request a demo
Request demo
Product
Platforms
Templates
Security
Customer Reviews
Product Updates
Solutions
Success Stories
Partners
Partners
Become Our Partner
Pricing
Support
Help Center
Webinars
Hero Webinar
Manual
Forum
Tutorial Videos
Blog
Contact us
Search
How to enable Javascript
Sign Up
Log in
Support
Forum
Home
Search the community
Home
Learn & Share
Get help
Knowledge Base
Latest Activity
Contact Us
Privacy
Home
Latest Posts
Re: Would someone please tell me what i“m doing wrong here?
Just in case anybody looks at this and is confused, i“m going to run the risk of confusing you more, since my previous post was an early version i copied and pasted while experimenting.…
Rico
Rico
1 yr ago
Get help
Reported - view
Re: Would someone please tell me what i“m doing wrong here?
It“s ok, i worked it out. I hadn”t used a let or select statement for a while, so i wasn“t clear on how to do things. I changed the formula slightly and used what appears to be the right syntax,…
Rico
Rico
1 yr ago
Get help
Reported - view
Would someone please tell me what i“m doing wrong here?
I“m using this formula: let Open := select Tracker where this(Symbol) = Symbol and this(Expires) = Expires.Total; Total + Open First problem is that i get this message: ”End expected:…
Rico
Rico
1 yr ago
2
replies
393
Get help
Re: Two questions: All View and Imports
Thanks for your answer, Dean, and the link to the article on normalization. Yes, if i only had 7 columns it would be a breeze! I have more than 80 fields.…
Rico
Rico
2 yrs ago
Get help
Reported - view
Locking' fields
I'm aware you can prevent fields from being modified by putting [field] = null in the Writeable if area. But i don't know how to do this with a delay, so that you can modify the field for, say,…
Rico
Rico
2 yrs ago
497
Get help
Two questions: All View and Imports
I'm trying to import data into a new database from an old one. I first tried to Export data from the old database, but this only seems to export the view you're currently on.…
Rico
Rico
2 yrs ago
6
replies
1,096
Get help
Re: Copying tables
Ah, ok, maybe Birger will have the answer.
Rico
Rico
2 yrs ago
Learn & Share
Reported - view
Re: Copying tables
Jen, don't look at the database, look at the top menu.
Rico
Rico
2 yrs ago
Learn & Share
Reported - view
Re: Copying tables
This is in the Table menu, Jen. Took me a little looking around to find, too. Thank you, Birger!
Rico
Rico
2 yrs ago
Learn & Share
Reported - view
Re: Circular Reference
I *think* i have the answer to this for my real formula. The issue for the formula proper wasn't a circular reference, but trying to perform divisions with a field that was sometimes empty.…
Rico
Rico
2 yrs ago
Get help
Reported - view
Re: Results in form not showing in table
I think i have the answer to this. In my beginning statement, i created a redundant or possibly invalid expression that Ninox didn't flag. Once i eliminated the redundant/invalid part of the…
Rico
Rico
2 yrs ago
Get help
Reported - view
Re: Circular Reference
To be clear, the formula Days Req depends on the results of the formula Movement Req, but Movement Req does not refer to Days Req, so i don't understand how it's a circular reference.
Rico
Rico
2 yrs ago
Get help
Reported - view
Results in form not showing in table
I have some results i can see in a certain field of my form. However when i look in the view of the table, no values appear. The results i can see in my form are from a formula field.…
Rico
Rico
2 yrs ago
1
reply
892
Get help
Re: Circular Reference
In my screenshot, my expression isn't deleted, just a field. But i've had other cases where Ninox deletes a whole expression.
Rico
Rico
2 yrs ago
Get help
Reported - view
Circular Reference
I had some formulas on a few fields that worked fine. When i tried to introduce some qualifying statement, they suddenly fell apart, giving me "Circular reference" errors.…
Rico
Rico
2 yrs ago
3
replies
1,464
Get help
Copying tables
Ninox is great when you want to copy an entire database, but, as far as i know, not so great when you want to copy and individual table to another db. I have 3 different databases:…
Rico
Rico
2 yrs ago
18
replies
4,107
Learn & Share
Re: Absolute
Thank you, Julian. I thought i tried abs, but i must've got mixed up along the way. I'll take the link you gave as the final word in future. I was aware of it,…
Rico
Rico
2 yrs ago
Get help
Reported - view
Absolute
The Ninox manual says, "absolute( x ) calculates the absolute amount of x, that is, x without a sign. Example: absolute( -10 ) = absolute( 10 ) = 10." I'm trying to use "absolute" in a formula and…
Rico
Rico
2 yrs ago
2
replies
1,172
Get help
Re: Posible bug?
Ah, i see, thank you Birger.
Rico
Rico
3 yrs ago
Learn & Share
Reported - view
Blank row prevention?
I've prevented write on some of my tables, as their content is unlikely to change in the near future, and if it does, i can disable write prevention and add the new records.…
Rico
Rico
3 yrs ago
789
Learn & Share
Posible bug?
I'm new, so i may be missing something, but i was pulling my hair out today trying to figure out why formulas that used "false" didn't produce consistent results.…
Rico
Rico
3 yrs ago
2
replies
844
Learn & Share
Re: Help with formula
Ok, Sean, thank you for your suggestions. I will look into them.
Rico
Rico
3 yrs ago
Get help
Reported - view
Re: Mixed number/date formula
That's brilliant - nothing like a straighforward solution. And i get to learn into the bargain!
Rico
Rico
3 yrs ago
Get help
Reported - view
Mixed number/date formula
I have a formula that doesn't work, i suspect because it refers to both number and date fields and isn't expressed the right way. It gives results in a time format, always 0:00.…
Rico
Rico
3 yrs ago
2
replies
1,138
Get help
Re: Help with formula
Oh, there's also one record with an Expires date but no filled date. The order concerned didn't get Filled, so i'm not sure why there's an Expires date, but there was a computer crash at the time,…
Rico
Rico
3 yrs ago
Get help
Reported - view
1
2
3
Next
Rico
Rico
51
0
0
Joined: 22 Jun 2019
Follow
Home
Learn & Share
Get help
View all topics
Tags