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: can I set and use global variables ?
Yeah, it looks like filter will not accept any kind of proxy.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: can I set and use global variables ?
Here's what I meant about the possibilities... function myVar(operation : text,num : number) doswitch operation docase "+=":record(GV,1).(Number := record(GV,1).Number + num)case "-=":record(GV,1).…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: can I set and use global variables ?
Laurent, Why ask? Test!!
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: can I set and use global variables ?
Günther, This would be considered a global constant since it is hardcoded, but I really like the possibilities of this approach.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: can I set and use global variables ?
You’re welcome Laurent. I don’t mind a work around as long as it isn’t too cumbersome and this one isn’t bad.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: can I set and use global variables ?
I assume you put it in "Global script definitions". I know a couple of us tried that when release 2.5 came out and didn't have any luck. One option is to create a table for persistent variables.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: how can i automatically link two fields from two tables?
You’re welcome. Here’s the link for language reference... https://ninoxdb.de/en/manual/calculations/reference-of-functions-and-language
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: how can we interrupt a too long process ?
I have no clue what would happen on the server side if you Force Quit the app that was interfacing with it. Are you saying you Force Quit the client side app and tried to reconnect and the server…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: how can i automatically link two fields from two tables?
Hi jeroen, You used the record level link code in your example so it only linked records in the n table that matched the current record in the 1 table assuming QRcodes is the 1 table and CLUBS is the…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Some User Defined Array Functions
I follow you now and, yes, you are correct. I thought you were using a "Choice" field type, but you are a linked table which would return an array of values.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: how can we interrupt a too long process ?
Well, if you want to get medieval on it's...
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: how can i automatically link two fields from two tables?
https://ninoxdb.de/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/is-it-possible-to-link-automatically-via-a-function-fields-in-two-tables-that-contain-the-same-text-5c6aaf80e850ad238982b496
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Some User Defined Array Functions
I'm pretty sure the "Choice" field type does not return an array.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Some User Defined Array Functions
Did you mean "Multiple choice" instead of "choice" type? I did some testing with the "Multiple choice" type and got the same result you did. It looks like the user-defined functions do not allow user…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: How can I add two arrays?
I just noticed that it could have reduced it to 2 lines... let array := numbers('Multiple choice');array := unique(array, 10) You can also use it with slice() to insert items...…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: How can I add two arrays?
Yes, I'm familiar with that thread. I'm curious why you would choose that approach instead of one like this... let array := numbers('Multiple choice');let add := 10;array := unique(array,…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: How can I add two arrays?
Ioannis Sorry, I got two threads mixed up in my head. In your example ar3 becomes an array with a single item equal to "1, 2, 3, 4". You can test this with item(ar3, 0).…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Some User Defined Array Functions
Hi dessein, Thank you! I tested the function using a "preconcatenated" variable in the function and it worked. One thing I do see is you have "Let" instead of "let".…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: How can I add two arrays?
Hi Ioannis That is one of the problems with those array functions at the moment... they always return text values regardless of the input type. Another problem is any value/item that has a ",…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Ninox HTTP Calls syntax
@Mconneen, when you say you filter in the for loop, are you downloading all the records from the cloud to your computer and then filter them client side?…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: How can I add two arrays?
Ioannis You’re welcome. Looks like you’ve got it. I’m familiar with the unique() function’s named purpose, but was not aware that it would combine an array with other values.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Ninox HTTP Calls syntax
@Mconneen, Thanks for the update. I would think that the main reason for implementing REST/API is to use Ninox as a back end server. If that's the case,…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: How can I add two arrays?
Hi Jörg, Thank you for posting this. The array request has been going on for some time now... is this recently implemented functionality? Best, Sean
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: How can I add two arrays?
Hi Jörg, numbers() is not a function in the Mac app. Here is a screenshot of my test...
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: How can I add two arrays?
@Ioannis, it's possible and once you have the code worked out it will do all the work for you. Post what you want to do and I will try to help. @Jörg, that just returns the values that are not of…
- Sean
- 5 yrs ago
- Get help
- Reported - view

1 56 57 58 59 60 71

Welcome to the Ninox community

Sean

My Posts

Re: can I set and use global variables ?

Re: can I set and use global variables ?

Re: can I set and use global variables ?

Re: can I set and use global variables ?

Re: can I set and use global variables ?

Re: can I set and use global variables ?

Re: how can i automatically link two fields from two tables?

Re: how can we interrupt a too long process ?

Re: how can i automatically link two fields from two tables?

Re: Some User Defined Array Functions

Re: how can we interrupt a too long process ?

Re: how can i automatically link two fields from two tables?

Re: Some User Defined Array Functions

Re: Some User Defined Array Functions

Re: How can I add two arrays?

Re: How can I add two arrays?

Re: How can I add two arrays?

Re: Some User Defined Array Functions

Re: How can I add two arrays?

Re: Ninox HTTP Calls syntax

Re: How can I add two arrays?

Re: Ninox HTTP Calls syntax

Re: How can I add two arrays?

Re: How can I add two arrays?

Re: How can I add two arrays?

Overview