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: 2 views different fields
https://ninoxdb.de/en/forum/ideas-and-suggestions-5abb9f4f45eda7ea1e75ed02/unique-form-views-5d17a70dccd6ea4c56021f9d
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Barcode
There is a barcode database in the Webinar EN 2020 team
- Sean
- 4 yrs ago
- Learn and Share
- Reported - view
Re: 2 views different fields
I don't think it's possible with "Views". You can add a "Tab layout element" to a Form in a View. The first Tab layout element should be place at the top of the field list for the first Tab view and…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Filtering Grouped columns
You can try this... https://ninoxdb.de/en/forum/use-cases-5abd0b9c4da2d77b6ebfa395/duplicate-marking-utility-for-large-datasets-5e2d30194e9f3771e468dd52
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Is it possible to link automatically (via a function) fields in two tables that contain the same text?
You beat me to it. The code doesn't create the Reference field, it creates the link and, as you figured out, you add the Reference field from "Edit fields...".…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Is it possible to link automatically (via a function) fields in two tables that contain the same text?
I created two tables the way you described and ran the first code you posted and they linked without a problem... I just copied and then pasted the following into the Ninox editor...…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Is it possible to link automatically (via a function) fields in two tables that contain the same text?
Ben, I'm going to work so I'll have to look at it later tonight
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: zipcode field removing leading zeroes
Ben, Steven already gave you a link in this thread... https://ninoxdb.de/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/one-to-many-relationship-5b705fed9efc8227533e7c96?…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Undo function
I don't have a dog in this hunt, but I have wonder why such seasoned coders NEED to have this feature built into the software. Sure, it will be a nice feature to have when it is eventually…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: formula to count unique records
Try this... count(unique((select YourTable).ID))
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Select statement in formula is REALLy slowing my table down. Any solution?
You can create a separate table for global variables. This thread might help...…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Have SQL Command That I Am Trying Run with Ninox
It doesn't use SQL. It has 3 SQL-like statements, select, where and order by. Here is a link to the language reference... https://ninoxdb.de/en/manual/calculations/reference-of-functions-and-language…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Phone Number Formatting?
I made some changes to your code. Hope you don't mind... let sym := "+";let pad := "#";let digits := replacex(Phone, "\D", "g", "");let ln := length(digits);let pre :…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Phone Number Formatting?
I don't think that is possible.
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Phone Number Formatting?
Looks like you're getting the hang of it Ben. You can omit else sym := sym since sym was already defined in the beginning.
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Phone Number Formatting?
Art, The code accepts 10, 11 and 12 digit phone numbers and automatically adds "+" for 11 and 12 digit numbers. You could type "+" if you like, but it would be removed before the formatting took…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Searching again - Using REGEX (Regular Expressions)
I don't know which regular expression module you are using in Python, but it could be very different with regard to features. You might want to look at this... https://www.rexegg.com/regex-python.…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Searching again - Using REGEX (Regular Expressions)
Please search the Forum using replacex, extractx or testx as the search criteria.
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Phone Number Formatting?
I made a mistake with the previous code. It will strip non-numeric characters for testing the length, but it didn't update the phone number string. The following code fixes that.…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Inserting a record in a Child Table from a Script
If you are trying to link the records you would do something like this... let p := create PRODUCT;p.Type := "Box"; p.Amount := 115;let masterTableId := item((select MASTER where PK = 10).Id, 0);p.…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Phone Number Formatting?
This code does the same thing and should be easier to modify. It strips any formatting and if the length of the number isn't at least 10 digits it will set the field to null.…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Technical Question/ How to choose the lowest value from several fields in a record?
Steven, thank you for the vote of confidence. Regex is use for matching patterns in strings or text so it's probably not the best tool for the job here.…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Id reset
Click the gear icon and choose "Edit fields..." then select "Duplicate table..." at the bottom left. That will create a copy of the table with Id starting at 1.
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Generate list of unique choices from linked table
Steven, I misstated my solution and decided not to correct it until there was a response. What I should have said was you would check only one of multiple values and all of the unique values.…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Generate list of unique choices from linked table
Another possible option would be to add a Yes / No field, named "Unique" for example, to "table 1" and select Yes for each of the unique records. Then you can use the constraint b.Unique = true
- Sean
- 4 yrs ago
- Get help
- Reported - view

1 35 36 37 38 39 71

Welcome to the Ninox community

Sean

My Posts

Re: 2 views different fields

Re: Barcode

Re: 2 views different fields

Re: Filtering Grouped columns

Re: Is it possible to link automatically (via a function) fields in two tables that contain the same text?

Re: Is it possible to link automatically (via a function) fields in two tables that contain the same text?

Re: Is it possible to link automatically (via a function) fields in two tables that contain the same text?

Re: zipcode field removing leading zeroes

Re: Undo function

Re: formula to count unique records

Re: Select statement in formula is REALLy slowing my table down. Any solution?

Re: Have SQL Command That I Am Trying Run with Ninox

Re: Phone Number Formatting?

Re: Phone Number Formatting?

Re: Phone Number Formatting?

Re: Phone Number Formatting?

Re: Searching again - Using REGEX (Regular Expressions)

Re: Searching again - Using REGEX (Regular Expressions)

Re: Phone Number Formatting?

Re: Inserting a record in a Child Table from a Script

Re: Phone Number Formatting?

Re: Technical Question/ How to choose the lowest value from several fields in a record?

Re: Id reset

Re: Generate list of unique choices from linked table

Re: Generate list of unique choices from linked table

Overview