Sean

1762
79
0

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

Coding Dart/Flutter in my spare time

My Posts

Latest Posts

Duplicate Marking Utility for Large Datasets

I don't know at what point using cnt(select YourTable where YourField = CurrentField) > 1 becomes impractical, but I recently had the opportunity to work with a table that had 64,000+ records,…
- Sean
- 5 yrs ago
- 1reply
- 1268
- 1
- Learn and Share
Re: Is it possible to tell where a given field is being used in a database?
You can do this with the count() function and select command in a formula field... count(select YourTable where YourField != null) If the result is 0 then you can make your decision about that field.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: How to Sort Localisation fields properly ?
Yes, it can be done with regex exclusively... extractx(text(Location), "(\d+) (?:Boulevard de|Quai de la|Rue des|Rue du) (.+), (\d{5}).", "$3$2$1")
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: How to Sort Localisation fields properly ?
Julien, This is one solution. I don't know if it's possible to use regex exclusively. switch contains(text(Location), text(Location)) docase contains(text(Location), "Bou"):extractx(text(Location),…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: How to Sort Localisation fields properly ?
@Julien, You can extract the ZIP Code and copy it to a field using a button or a trigger. Without modifying the regex pattern you can simply use "$3" instead of "$3$2$1".…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Field Tab Order When Entering Data
Mel, There isn't a "Tab order" or "Tab stop" property. You can use a combination of "Display field only, if:", "Trigger after update" and "Writable if" as a work around.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: The online user manual
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: how can I convert a field type from text to choice?
This is one way... https://ninoxdb.de/en/manual/tables/update-multiple-values This is another way...…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: The online user manual
@Jörg, I'd be happy to help in any way I can.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Reviewing duplicates in one field
Wes, You're welcome. That was a satisfying bone for me to gnaw on yesterday. The code was the first version that would mark the duplicates so I went with it.…
- Sean
- 5 yrs ago
- Learn and Share
- Reported - view
Re: Reviewing duplicates in one field
Ok, I forgot I could login and use the Mac app to run the code on the "Duplicate Test" database, D'oh! The database is updated and you have 571 duplicates and it took approximately 38 seconds to…
- Sean
- 5 yrs ago
- Learn and Share
- Reported - view
Re: Reviewing duplicates in one field
I'm not sure what's going on. I was able to import the file to my team and it works fine, but I still can't import it to your team.
- Sean
- 5 yrs ago
- Learn and Share
- Reported - view
Re: Reviewing duplicates in one field
I waited almost an hour for the loop to run and gave up so I downloaded the file and ran it in the Mac app and it took less than 5 to process. I tried to upload the file 5 times and it failed every…
- Sean
- 5 yrs ago
- Learn and Share
- Reported - view
Re: Reviewing duplicates in one field
I'm looping through the records now
- Sean
- 5 yrs ago
- Learn and Share
- Reported - view
Re: Reviewing duplicates in one field
This is a more appropriate screenshot...
- Sean
- 5 yrs ago
- Learn and Share
- Reported - view
Re: Reviewing duplicates in one field
It looks like the solution of using the "select" command is impractical for that many records... A better algorithm would be to iterate through the records ordered by ItemID,…
- Sean
- 5 yrs ago
- Learn and Share
- Reported - view
Re: Please fix the extract() function so flags will work
I can't help myself . Why would you use "i" or case insensitive mode when you are only extracting numbers?
- Sean
- 5 yrs ago
- Learn and Share
- Reported - view
Re: Reviewing duplicates in one field
I don't mind and I've got some time to look at it today. Do you have the Mac app? I'm wondering if that makes any difference.
- Sean
- 5 yrs ago
- Learn and Share
- Reported - view
Please fix the extract() function so flags will work

Flags simply do not work the way Frank suggests in this post... https://ninoxdb.de/en/forum/technische-hilfe-5ab8fe445fe2b42b7dd39ee8/regex-flags-5b87f00b37fc0c3278cdf4b4
- Sean
- 5 yrs ago
- 6replies
- 1294
- Learn and Share
Re: Reviewing duplicates in one field
I don't have a similar data set to work with so I can't really troubleshoot this. Do you get the correct result without using the filter? Maybe a stupid question,…
- Sean
- 5 yrs ago
- Learn and Share
- Reported - view
Re: trouble with a simple selection using a multi-choice field
Mel, I can't say for sure. I am curious whether using "this" would work as well. let t := this; SalesVatRate := first((select VATCodes)[VATCode = t.SalesVatCode].…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Reviewing duplicates in one field
Try clicking the Refresh icon in the upper left corner or close and reopen the database
- Sean
- 5 yrs ago
- Learn and Share
- Reported - view
Re: trouble with a simple selection using a multi-choice field
If SalesVatRate is a field then you shouldn't put "let" in front of it. Also, try VATCode = text(SalesVatCode)
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Add Regular Expression Capability
@Leonid, Have you ever gotten "flags" to work in extractx()? Beyond capture groups, what does the "extract" argument represent and how do you access it.…
- Sean
- 5 yrs ago
- Learn and Share
- Reported - view
Re: Reviewing duplicates in one field
The formula I posted goes in a Formula field not "Trigger after update"
- Sean
- 5 yrs ago
- Learn and Share
- Reported - view

1 38 39 40 41 42 71

Welcome to the Ninox community

Sean

My Posts

Re: Is it possible to tell where a given field is being used in a database?

Re: How to Sort Localisation fields properly ?

Re: How to Sort Localisation fields properly ?

Re: How to Sort Localisation fields properly ?

Re: Field Tab Order When Entering Data

Re: The online user manual

Re: how can I convert a field type from text to choice?

Re: The online user manual

Re: Reviewing duplicates in one field

Re: Reviewing duplicates in one field

Re: Reviewing duplicates in one field

Re: Reviewing duplicates in one field

Re: Reviewing duplicates in one field

Re: Reviewing duplicates in one field

Re: Reviewing duplicates in one field

Re: Please fix the extract() function so flags will work

Re: Reviewing duplicates in one field

Re: Reviewing duplicates in one field

Re: trouble with a simple selection using a multi-choice field

Re: Reviewing duplicates in one field

Re: trouble with a simple selection using a multi-choice field

Re: Add Regular Expression Capability

Re: Reviewing duplicates in one field

Overview