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: Contains formula
You can also use if-then-else to test for null on the search field and if it is null just use select yourTable to display all records.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: if this then that
For me, it's not clear what that screenshot is. Is it for a formula field? Is Employee a sub table of 'Time Sheets'?
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Contains formula
This works so you'll just have to rename the items that don't match your names. let yourSrch := yourSearchField;(select Table2)[contains(upper('Repair Number'),…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Contains formula
Is the table View searching the same table that the view is on? This is what I came up with and you have to press tab or return to activate the view update.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Question
I hope Emanuel doesn't mind me jumping in... I haven't seen this before so I wanted to try it. My solution is a little different, but with code there is always more than one way to arrive at a…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Contains formula
Wow!
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Automatic field record
Hi, I apologize, the solution is a bit more complicated. This works in the console, but only if the Record Id's in all 3 tables match. Do you know if that is the case with your tables?…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Automatic field record
It would be similar to this example in the language reference... for p in (select Person)p.Haircolor := "red" You could attach something like this to a button... for r in (select Table3) r.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Universal array handling when array items are not text strings
There isn’t a built-in function or capability that i’m aware of. So, you’re left with trying to grow your own or begging for an enhancement to the Ninox language.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Universal array handling when array items are not text strings
Sorry, it should be a1 := aAppend(concat(a1), "Test " + i)
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Universal array handling when array items are not text strings
I don't speak for the Ninox team, but I am interested in what you consider a large array and whether you have tested the performance on that size of an array.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Trigger After Open
I'm not trying to upstage the work you did here... You can also use the formula used for maxId directly in openRecord() if you want.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Trigger After Open
Good work. I tried something similar, but didn't use the select command. It does navigate to the correct record in table view, but it doesn't update the view to show it.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Trigger After Open
I could get it to work with openRecord() if I entered the Id # of the last record, but that isn't what you're looking for. It would be nice to be able to use last(Id) for the record #.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: "Display field only, if" multiple-choice field is = 1
For what it is worth, the function chosen(multi, number) returns a Boolean value. So it will return true if field 1 is chosen, but it will also return true if other values are chosen as well as field…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Go to view button
It's under User Interface Automation in the language reference. openTable(tableName, viewName) - opens a table view| openTable("Invoices", "All Invoices")
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: "Display field only, if" multiple-choice field is = 1
I'm not official support, but the function is chosen(multi, number).
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Problems with IF Statements
At a glance, it looks like part of the problem is your use of mixed case. All of Ninox commands/functions use Lower Camel Case so all of the single word commands/functions will be lower case like…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: tick any choice on a multiple-choice field with a trigger
You can put this in "Trigger after update"... if 'field A' = 1 then 'field B' := [1, 5, 7, 8] else 'field B' := [4, 2, 3, 6, 10] end
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Nested IF Statements
In your if expression you are using the assignment operator instead of the comparison operator. This: if Address2 := null then Should be this: if Address2 = null then Ninox reads your expression as…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: UD Array Functions by Index
aryContains() - Lets the user check for a value in an array and returns the index. This function uses idxContains() so idxContains() must be defined before aryContains().…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: UD Array Functions by Index
idxContains() - Lets the user check for a value at a given index. Returns a boolean value. Function Call idxContains(concat(yourArray), aryIndex, chkValue) Function Definition function…
- Sean
- 6 yrs ago
- Get help
- Reported - view
UD Array Functions by Index

This has definitely been a progression. Typically, array manipulation is done by using the array's index rather than by the index value and that's how these functions work.…
- Sean
- 6 yrs ago
- 7replies
- 3933
- 2
- Get help
Re: Some User Defined Array Functions
Ooops, brainfart! item(array, index) is already built-in. Sorry!
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Some User Defined Array Functions
aGetItem() - This function returns the array item of a given index. Function Call aGetItem(concat(yourArray), aryIndex) Function Definition function aGetItem(ary : text,aryIndex :…
- Sean
- 6 yrs ago
- Get help
- Reported - view

1 61 62 63 64 65 71

Welcome to the Ninox community

Sean

My Posts

Re: Contains formula

Re: if this then that

Re: Contains formula

Re: Contains formula

Re: Question

Re: Contains formula

Re: Automatic field record

Re: Automatic field record

Re: Universal array handling when array items are not text strings

Re: Universal array handling when array items are not text strings

Re: Universal array handling when array items are not text strings

Re: Trigger After Open

Re: Trigger After Open

Re: Trigger After Open

Re: "Display field only, if" multiple-choice field is = 1

Re: Go to view button

Re: "Display field only, if" multiple-choice field is = 1

Re: Problems with IF Statements

Re: tick any choice on a multiple-choice field with a trigger

Re: Nested IF Statements

Re: UD Array Functions by Index

Re: UD Array Functions by Index

UD Array Functions by Index

Re: Some User Defined Array Functions

Re: Some User Defined Array Functions

Overview