Skip to main content

Welcome to the Ninox community

Search all topics or ask a question

Sean

Sean

1760
79
0

Joined: Tue Jul 31 23:45:13 UTC 2018

Coding Dart/Flutter in my spare time

My Posts

Latest Posts

Re: How to store a record id in another field?
Westy, I store Id's in a Number field and it looks like you have to assign the Id to a variable to copy it to another record. let tId := number(this.Id); record(GV, 1).(t := tId)
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Help with formula
Another thing is I don't understand your emphasis on the Date fields. You can sort, group and filter those fields if you want. Also, RST could be a data field that gets filled when Security updates.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Help with formula
I think you are going to need, or at the very least, it will be easier if you add a Transaction Id field because you have multiple records where Filled has the same date.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Mixed number/date formula
One way would be to use the days() function instead of subtracting one date from another.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Help with formula
This is my crossword puzzle so I don't mind doing it. A long delay a shipper really messed up my schedule so it will be much later today, CDT, before I can look at it.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: I’ve got this code from a button on a form but get error “not a data field” on the last line. Any help appreciated.
Lawrie, if you are just trying to access the current record use something like this... let DD := this.'Next One'; while DD <= today() do let DD := DD+28 endthis.'Next One' := DD
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: I’ve got this code from a button on a form but get error “not a data field” on the last line. Any help appreciated.
let i:= select Transactions is going to return an array of Id's for the Transactions table because Id is the default if you don't specfy another field like... let i := (select Transactions).…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Help with formula
Well, I have to admit I'm getting a little frustrated with this one. I think the latest screenshot should have been presented in the beginning with an explanation for which columns are data,…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: I’ve got this code from a button on a form but get error “not a data field” on the last line. Any help appreciated.
Is "i" a table reference?
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Help with formula
Can you make a screenshot of your spreadsheet that includes Filled, Expires and Security. It doesn't have to be your live data, I just want to see a working example of what you have in your…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Help with formula
"this" is a handle to the current record. I'm afraid "wonky" isn't a very helpful description of what you are getting relative to what you want to get. Maybe a screenshot of your spreadsheet if the…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Help with formula
Hi Rico, you're welcome. The formula should still work with a minor change. let t := this;if A > t.B thensum((select YourTable where B = t.B and A > t.B and A <= t.A).…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Help with formula
I figured out it works, but you have to either click the Refresh icon at the upper left corner of the table or add code to the "Trigger after update". You could put this code in one of the field…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Help with formula
I just found an error with that solution... I'll have to work on this tomorrow.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Help with formula
This solution assumes the cumulative total will increase as the record Id's increase. If that doesn't work we'll have to try something else. This also will leave the value blank if A is not greater…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Help with formula
Try this... let tB := this.B;sum((select YourTable where B = tB and A > tB).C)
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: More options for the View layout element
I'm like a dog with a bone! Another option would be to allow editing in the View element itself. Let's say in your main table you have a filtered field and you have records that don't match the…
- Sean
- 5 yrs ago
- Learn and Share
- Reported - view
Re: More options for the View layout element
Another option would be to stay on the same Form view that the View layout element is on. We can currently use popupRecord(record(tableName, recordId)) to slide in a custom Form view.…
- Sean
- 5 yrs ago
- Learn and Share
- Reported - view
More options for the View layout element

When you click on a record in the View layout element, it slides a duplicate Form View in with that record selected. It would be useful to be able have the option to use openTable(tableName,…
- Sean
- 5 yrs ago
- 4replies
- 1592
- Learn and Share
Re: Formula not working - number doesn't increase?
Have you tested your select statement in a formula field to make sure it’s returning a result? Also, I’m not sure why you are using the combination of text() and number() functions in your…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Is it possible to make a view with a top 10 only?
Umm, I've never seen code where 2 for-loops were combined with "and". Also, you can't sort by proxy and I'm pretty sure you can't filter by proxy either.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Is it possible to make a view with a top 10 only?
For what it's worth, I'm pretty sure item(A, i) is returning a string so what you are doing is concatenating items from the array to B which is a string.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Is it possible to make a view with a top 10 only?
Well, you've mentioned a couple of issues not just one. 1) You want to copy array values to your table rank field. 2) You want to sort by a combination of your rank fields. Correct?
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Is it possible to make a view with a top 10 only?
@plafontaine44, Can I safely assume your post about idxRemove() is regarding your most recent post in this thread? If so, I think that array function is the wrong tool for the job.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: how can I remove an item from an array?
Ahh, one of my favorite topics on the Ninox forum . idxRemove() is a User-defined function that must be defined in a formula field before it is used or defined in "Global script definitions".…
- Sean
- 5 yrs ago
- Get help
- Reported - view

1 48 49 50 51 52 71

Back to top

Overview

View all topics