Sean

1763
81
0

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

Coding Dart/Flutter in my spare time

My Posts

Latest Posts

Re: can we use a regex to filter a column ?
Hmm, I'm thinking no. I've been playing around with the regex functions and I think that's the only way you can use regex in Ninox. That means in order for Ninox to interpret the regex condition for…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: FIELD BACKGROUND COLOURS
Once you have dialed in the numbers you want, click on the circle that displays the resulting color. I use 238, 238, 238 if I want to match the default background gray.
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: UD Array Functions by Index
This might not be applicable, but if you define the function in a formula field instead of in "Global script definitions" and declare the array (it can be empty) before the function definition then…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: UD Array Functions by Index
There are a couple of problems. As far as I'm able to tell, you still can't pass an array to a user-defined function so you would need to pass the array as a string using concat() or join().…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Switch statement stop working?
I mean, which one worked?
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Switch statement stop working?
It worked?
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Switch statement stop working?
Oops, wrong terminology. Reorganize is what I meant to say, but if that doesn't do it try making a duplicate.
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Switch statement stop working?
@Nick, Other than the update broke something I really don’t know. Strange that it’s not consistent across databases though. Did you try to rebuild any of them?
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Can I default some values of a new record to be the same as the previous record?
This thread explains how to do that... https://ninoxdb.de/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/question-5c40c978b03a5d15e04ad2e6?post=5c423cb788e94d34092bcf36&page=1 You can enter the…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Switch statement stop working?
Nick, I only checked one database that I know uses a switch statement, but it's still working.
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Changing ID numbers
You can add a button to your form and enter the code in the "On click" section of the button. Once the records are updated you can just delete the button.
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: How can I reference the present record/table in a select statement?
If I recall correctly, I tried to use "this" directly in a formula in the past and it didn't work so I got in the habit of assigning it to a variable. They make changes when they update the app,…
- Sean
- 6 yrs ago
- Learn and share
- Reported - view
Re: How can I reference the present record/table in a select statement?
When you say you want to update all the Invoices, do mean you want to link the records?
- Sean
- 6 yrs ago
- Learn and share
- Reported - view
Re: How can I reference the present record/table in a select statement?
You had... let C := Client; I'm saying this... let C := this.Client; so it would be... let C := this.Client;for I in select Invoices where SameAsProject = true and Client = C doI.(Client := C)end
- Sean
- 6 yrs ago
- Learn and share
- Reported - view
Re: How can I reference the present record/table in a select statement?
Try this... let C := this.Client
- Sean
- 6 yrs ago
- Learn and share
- Reported - view
Re: Multi-dimensional array
@Mconneen, Have you noticed the array() function? It didn't register for me until yesterday. That function and the unique() function will combine 2 "multi-dimensional" arrays and you can access all…
- Sean
- 6 yrs ago
- Learn and share
- Reported - view
Re: Multi-dimensional array
@Mconneen, I haven't spent enough time with the API to understand what you describe. I guess I'm getting tripped up on "support". The approach I'm suggesting is definitely a hybrid of Table/Array…
- Sean
- 6 yrs ago
- Learn and share
- Reported - view
Multi-dimensional array

I'm just pointing this out. The Table is an array of objects and it can be assigned to a variable. I don't know what the size limitations are, however. If you made a Table generic enough,…
- Sean
- 6 yrs ago
- 3replies
- 1864
- Learn and share
Re: How to display an array
If you want your array to be persistent and editable, I suggest you use a table. There aren’t any minimum requirements for how many fields or records a table contains.
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: How to display an array
I think the "View" will only display data from a table using the "select" statement. If you are not getting your array values from a table you can use this function to display the array in columnar…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: How to display an array
Have you tried the "View" layout element? You can display an array in a formula field, but if you want a spreadsheet format the "View" would be better.
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Changing ID numbers
@Westy, Excellent solution... I did a mental facepalm when I read it! @computers@rbaarchitects.com.au, You can fill the number field of existing records using code like this in a button or through…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Changing ID numbers
You would have to create your own "Id" field and and then update the numbers when you insert a new record. This Id field is basically a ranking field and you would sort the records on this field.…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Switch syntax wrong?
That's kind of the allure for me! I figured since the "and" operator didn't throw an error I might as well try "+". I agree that the documentation is lacking, however,…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: another way that filtering
You can omit the "order by" part of the formula because it doesn't have any affect on the order of the View. You can set the order in the View like you would a Table.
- Sean
- 6 yrs ago
- Get help
- Reported - view

1 44 45 46 47 48 71

Welcome to the Ninox community

Sean

My Posts

Re: can we use a regex to filter a column ?

Re: FIELD BACKGROUND COLOURS

Re: UD Array Functions by Index

Re: UD Array Functions by Index

Re: Switch statement stop working?

Re: Switch statement stop working?

Re: Switch statement stop working?

Re: Switch statement stop working?

Re: Can I default some values of a new record to be the same as the previous record?

Re: Switch statement stop working?

Re: Changing ID numbers

Re: How can I reference the present record/table in a select statement?

Re: How can I reference the present record/table in a select statement?

Re: How can I reference the present record/table in a select statement?

Re: How can I reference the present record/table in a select statement?

Re: Multi-dimensional array

Re: Multi-dimensional array

Re: How to display an array

Re: How to display an array

Re: How to display an array

Re: Changing ID numbers

Re: Changing ID numbers

Re: Switch syntax wrong?

Re: another way that filtering

Overview