Sean

1762
79
0

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

Coding Dart/Flutter in my spare time

My Posts

Latest Posts

Re: Prevent record pop-ups when clicking the view table or a subtable
I don't think that is possible with a View layout element or Table Reference yet. If you have access to the Webinar EN 2020 team there is an example database, HTML Tricks,…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: how do i delete a reference between rows
Set the table reference equal to 0. So if you wanted to unlink the current record in the many table you would use code like this... let curRec = this; curRec.…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: How to delete a table
Click on the gear icon and choose "Edit fields..." then you'll see a red "Delete table" button at the bottom left corner.
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: What relationship is appropriate?
See if these two links help. I think you need a Many to Many relationship.…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Find by array ?
You're welcome Alain. I worked up some code based on your original post which was more general about wanting to select records based on items in an array.…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Regex (tests) not working as expected ?
You're welcome Luis. I'm fairly confident Ninox does not support the ability to turn modes on/off for only part of the regular expression. Where the manual briefly mentions the regex functions,…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Regex (tests) not working as expected ?
Here are a couple of ways that produce the same result in a View layout element. First, uses the testx() function and 'Search String' is a text field...…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Regex (tests) not working as expected ?
Well, I always wondered how people managed to post the same thing twice
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Regex (tests) not working as expected ?
You answered your own question. From the manual... testx(string, regular_expression, flags) You were trying to combine the pattern with the flag and I'm not so sure your pattern would work.
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Regex (tests) not working as expected ?
You answered your own question. From the manual... testx(string, regular_expression, flags) You were trying to combine the pattern with the flag and I'm not so sure your pattern would work.
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Find by array ?
How are you filling your array? The only way I know it can be done is to create another table that you can copy the information to and then you can either go to that table or use it as the source for…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Forms
If I understand correctly, you need to add a Tab layout element to one of your Forms. This enables you to have different fields on each Tab, but you can't have the same field on multiple Tabs.
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Static Map With Multiple Markers
Very nice Steven! Thanks for sharing
- Sean
- 4 yrs ago
- Learn and Share
- Reported - view
Re: How to Sort Localisation fields properly ?
I wasn't aware of all the possible prefix names. It is easily fixed though. Move all single word prefixes to the end of the list of compound prefixes that begin with the same word.…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: I would like to copy the contents of a field to the same field in the next record
Please look at this thread... https://ninox.com/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/question-5c40c978b03a5d15e04ad2e6?post=5c423cb788e94d34092bcf36&page=1
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: multiple choice equal to twice the same value!
Scott, Difficult to say without more information. You can use the numbers() function, but you have to convert it to a string first. Something like this...…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: How to Sort Localisation fields properly ?
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Is there a way to combine 2 print layouts?
I would send an email to Ninox support directly or join one of their webinars at this point.
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: integrated Google Maps Formula.
Hi Terry, It's possible to do what you want in Ninox, but I don't know if it's going to work in Google Maps. I tried your code from just the "Street Address" condition and didn't use "do as server".…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: integrated Google Maps Formula.
Terry, Would you please post what the final src string is supposed to look like. "" equates to nothing when you are building a string so I don't know why that is in there.…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: How to Sort Localisation fields properly ?
Julien, You can do it a couple of different ways. In my tests, I just added a formula field to the table and entered the formula there. You can also put the formula in the "Trigger after update" of…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: How would I code/formula for a MAC address in a text field?
In the "Trigger after update" of you MAC Address field enter this... 'MAC Address' := replacex(upper('MAC Address'), "(\w{2})(\w{2})(\w{2})(\w{2})(\w{2})(\w{2})", "$1:$2:$3:$4:$5:$6")
- Sean
- 4 yrs ago
- 1
- Get help
- Reported - view
Re: Why is Formula Editor changing my variables?
I would try changing the variable names to something other than single capital letters. I think your variable names are conflicting with internal Ninox Ids.…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: on which database is Ninox build
If you look at this link https://ninox.com/en/jobs/senior-full-stack-developer in their Careers section, you'll see Mongodb and PostgreSQL mentioned. I'm just speculating,…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Multi line cell to several singel line cells
You can use the split() function which will return an array. Something like this... newArr := split(MultilineField, " ") Use the count() function to get the total array items and use the item()…
- Sean
- 4 yrs ago
- Get help
- Reported - view

1 32 33 34 35 36 71

Welcome to the Ninox community

Sean

My Posts

Re: Prevent record pop-ups when clicking the view table or a subtable

Re: how do i delete a reference between rows

Re: How to delete a table

Re: What relationship is appropriate?

Re: Find by array ?

Re: Regex (tests) not working as expected ?

Re: Regex (tests) not working as expected ?

Re: Regex (tests) not working as expected ?

Re: Regex (tests) not working as expected ?

Re: Regex (tests) not working as expected ?

Re: Find by array ?

Re: Forms

Re: Static Map With Multiple Markers

Re: How to Sort Localisation fields properly ?

Re: I would like to copy the contents of a field to the same field in the next record

Re: multiple choice equal to twice the same value!

Re: How to Sort Localisation fields properly ?

Re: Is there a way to combine 2 print layouts?

Re: integrated Google Maps Formula.

Re: integrated Google Maps Formula.

Re: How to Sort Localisation fields properly ?

Re: How would I code/formula for a MAC address in a text field?

Re: Why is Formula Editor changing my variables?

Re: on which database is Ninox build

Re: Multi line cell to several singel line cells

Overview