Skip to main content
Ninox-Website
Ninox-Documentation
How to enable Javascript
Sign Up
Log in
Learn & Share
Get help
Webinars
All topics
Contact
Privacy
Overview
Profile
Sean
Sean
1715
56
0
Joined: Tue Jul 31 23:45:13 UTC 2018
Follow
Coding Dart/Flutter in my spare time
My Posts
Latest Posts
Re: filling an appointment field
You could put this in the Trigger after update of the 'end date' field... YourAppointment := appointment('start date', 'end date')
Sean
Sean
5 yrs ago
Get help
Reported - view
Re: Syntax for "View" element
It can be helpful to breakdown each action into its own formula field. I don't think the line let x := split('Herbs in formula', ","); has the result you are looking for.…
Sean
Sean
5 yrs ago
Get help
Reported - view
Re: How do I define the 'Number format' as 'Fraction Number' in a number field?
I don't think that's possible with a number field. You'd have to concatenate the fraction to the whole number in a formula field.
Sean
Sean
5 yrs ago
Get help
Reported - view
Re: Is there any way we can have images in the main column? (see image - where circled)
I'm a user not support, but I would say that's unlikely. You don't get the option to adjust row height like you do for column width.
Sean
Sean
5 yrs ago
Get help
Reported - view
Re: Is there any way we can have images in the main column? (see image - where circled)
It works in their Real Estate database template. Click or tap on a column header and choose "Show column..." from the popup and then select your image field.
Sean
Sean
5 yrs ago
Get help
Reported - view
Re: can I set and use global variables ?
Yeah, it looks like filter will not accept any kind of proxy.
Sean
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
Sean
5 yrs ago
Get help
Reported - view
Re: can I set and use global variables ?
Laurent, Why ask? Test!!
Sean
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Sean
5 yrs ago
Get help
Reported - view
1
54
55
56
57
58
69
Ninox-Website
Ninox-Documentation
Overview
Learn & Share
Get help
Webinars
View all topics