Skip to main content

Welcome to the Ninox community

Search all topics or ask a question

Rico

Rico

53
0
0

Joined: Sat Jun 22 14:23:18 UTC 2019

My Posts

Latest Posts

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
- 5 yrs ago
- 2replies
- 1145
- 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
- 5 yrs ago
- Get help
- Reported - view
Re: Help with formula
Security is a fomula. RST is a formula: the one i'm asking for help with. Filled and Expired are date fields. The reason some date fields are blank is because some orders don't get filled.…
- Rico
- 5 yrs ago
- Get help
- Reported - view
Re: Help with formula
I meant to say it's still valid as an illustration of what i'm after.
- Rico
- 5 yrs ago
- Get help
- Reported - view
Re: Help with formula
The screenshot that follows is an extract of the spreadsheet. I have a frozen header row, so the rows that follow are in mid-stream: that is, they reflect transactions that have gone before.…
- Rico
- 5 yrs ago
- Get help
- Reported - view
Re: Help with formula
The language reference in the manual is very informative. I'll try to go through it in the coming days...
- Rico
- 5 yrs ago
- Get help
- Reported - view
Re: Help with formula
Yes, "wonky" was just an interim description to say i was still having problems. This is the result of the formula: The slight difference i mentioned was that one row was showing $1,700,…
- Rico
- 5 yrs ago
- Get help
- Reported - view
Re: Help with formula
Ok, i found "this" in the manual. I should pick these things up after a while!
- Rico
- 5 yrs ago
- Get help
- Reported - view
Re: Help with formula
I just tried it again, and it gave a slightly different, but still wonky result. This was my version: let t := this; if Expires >= t.Filled thensum((select Tracker where Filled = t.…
- Rico
- 5 yrs ago
- Get help
- Reported - view
Re: Help with formula
An, i thought my first comment above didn't post: i didn't realise it went to a second page!
- Rico
- 5 yrs ago
- Get help
- Reported - view
Re: Help with formula
Maybe my translation of this was wrong, but i was getting the same results as before. If you would write out the exact formula using the table name and field names i gave in my last post,…
- Rico
- 5 yrs ago
- Get help
- Reported - view
Re: Help with formula
Either i've translated the formula wrong, or it's not working right: it's giving me the same results as before. If you would give the formula EXACTLY as i should input it,…
- Rico
- 5 yrs ago
- Get help
- Reported - view
Re: Why does Ninox 'remember' deleted Ids?
I've confirmed that blank rows can be added even if the table is write protected, so how can you eliminate blank rows being created? I don't even know how they're getting there.…
- Rico
- 5 yrs ago
- Get help
- Reported - view
Re: Help with formula
Hi Sean, thank you for your efforts, but i don't think this is the answer. The reason being the cumulative total won't always increase as the record Id's increase.…
- Rico
- 5 yrs ago
- Get help
- Reported - view
Re: Help with formula
Ok, i've tried to implement this formula: it doesn't give any errors, and i did get results, but not the results i was after. It's correctly summing C for the rows where A > B,…
- Rico
- 5 yrs ago
- Get help
- Reported - view
Re: Help with formula
Thank you Sean, i'll give it a try. Mcconneen, fields A and B are date fields, so i looking for the dates in A to be greater than the date in B, which i want to evaluate for each row.…
- Rico
- 5 yrs ago
- Get help
- Reported - view
Re: Why does Ninox 'remember' deleted Ids?
Thanks for the suggestion. I'll try it on a test database first to see how it goes. If it looks promising i'll try it on the real thing. I'll report my results later...
- Rico
- 5 yrs ago
- Get help
- Reported - view
Help with formula

I'm moving from a spreadsheet to Ninox, so have to translate a lot of the formulas into Ninox. So far, with some help from Joerg, i've been able to tackle quite a few,…
- Rico
- 5 yrs ago
- 27replies
- 5132
- Get help
Re: Why does Ninox 'remember' deleted Ids?
The reason i raised this is because i've inadvertently created blank rows in various tables. I'm not keen on deleting them, because it will create an out-of-sequence Id,…
- Rico
- 5 yrs ago
- Get help
- Reported - view
Re: Why does Ninox 'remember' deleted Ids?
Alright, thank you for the explanation.
- Rico
- 5 yrs ago
- Get help
- Reported - view
Re: Why does Ninox 'remember' deleted Ids?
It also puts Id numbers out of sync with the row numbers on the far left, so you could be looking at row 132, but Id number 154.
- Rico
- 5 yrs ago
- Get help
- Reported - view
Why does Ninox 'remember' deleted Ids?

If i have a new table with 10 rows, Id numbers will go from 1-10. However if i delete the last three rows (8,9 and 10), then create a new row, the Id number of the new row is 11.…
- Rico
- 5 yrs ago
- 8replies
- 1774
- Get help
Re: How can I lock the data
Ok, thank you.
- Rico
- 5 yrs ago
- Get help
- Reported - view
Re: How can I lock the data
Sorry, i see that's the table, ok. What do i put in that field?
- Rico
- 5 yrs ago
- Get help
- Reported - view
Re: How can I lock the data
Are you saying: 1) you can't lock date table-wide - you have to do it field by field 2) if i have to go field by field, what do i enter in the Writeable If field, given my fields are not Yes/No?
- Rico
- 5 yrs ago
- Get help
- Reported - view

1 2 3

Back to top

Overview

View all topics