How to enable Javascript

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
- 2 yrs 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
- 2 yrs 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
- 2 yrs ago
- 2replies
- 394
- 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
- 503
- 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
- 6replies
- 1,101
- Get help
Re: Copying tables Ah, ok, maybe Birger will have the answer.
- Rico
- Rico
- 3 yrs ago
- Learn & Share
- Reported - view
Re: Copying tables Jen, don't look at the database, look at the top menu.
- Rico
- Rico
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 yrs ago
- 1reply
- 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
- 3 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
- 3 yrs ago
- 3replies
- 1,469
- 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
- 3 yrs ago
- 18replies
- 4,133
- 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
- 3 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
- 3 yrs ago
- 2replies
- 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
- 793
- 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
- 2replies
- 845
- 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
- 2replies
- 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