Skip to main content

Ninox-Documentation

Ben

Ben.2

25
0
0

Joined: Mon Feb 17 04:11:46 UTC 2020

My Posts

Latest Posts

Re: Phone Number Formatting?
well, it seems like I just answered my question. I put the following in the TABLE "trigger after update" of a test table with a bunch of unformatted numbers and updated one cell,…
- Ben.2
- 4 yrs ago
- Get help
- Reported - view
Re: Phone Number Formatting?
I'm wondering if its possible to put this in a trigger after update for the table, modified so that it checks/reformats the entire field
- Ben.2
- 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?
And, just to be explicit now about the steps I did to make it work: Starting point: two tables exist (full of data) with fields that are not linked but contain data to link.…
- Ben.2
- 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?
update to my "5 steps" above... the code does not appear to work if you create the relationship from the child table. I just re-ran my test and it gave me the same "can't find field" in line 6 of the…
- Ben.2
- 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?
True! I find Ninox extremely pleasant to use, and there is a great deal of overlap with other models, but the idea of creating the relationship itself as a field is one that is important to wrap…
- Ben.2
- 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?
Thanks again for your help. Ninox is really well designed, but there is definitely a learning curve. Its way more power than I initially thought, but it has some differences from other databases and…
- Ben.2
- 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?
So, I went in and created a new field in the State table, which is the "relationship" of "from City." I then tried your code, and it ran successfully, filling the new relationship field with the data…
- Ben.2
- 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?
When did the reference fields appear in your tables? Are they the result of your code? Because I am dealing with a situation where I have already set up a few tables and made some references between…
- Ben.2
- 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?
Thanks Sean, and no worries about the timing. Thanks for all your helpful ideas and suggestions
- Ben.2
- 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 meant to note that if I changed the last line to j.(select State).(StateID := item(myTable1Id, i)) then it simply places the random numbers and letters in the StateID into the corresponding column…
- Ben.2
- 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?
Hi Sean, since all conversations of this topic seem to point to this code, I'm going to post my difficulty here. I've tried with a few different sets of data, but for simplicities sake,…
- Ben.2
- 4 yrs ago
- Get help
- Reported - view
Re: zipcode field removing leading zeroes
Hi Sean, the link Stephen gave is to your code in the thread that you reference here. I will post my copy of the code below yours over there, but in my tables,…
- Ben.2
- 4 yrs ago
- Get help
- Reported - view
Re: zipcode field removing leading zeroes
To put it all together... this is the formula that I placed in the "Trigger after Update" section of the table (not on the specific field for zipcodes, although I think you could place this code in…
- Ben.2
- 4 yrs ago
- Get help
- Reported - view
Re: zipcode field removing leading zeroes
When you do the "update multiple records" as suggested by tacho, you can use: format(ZipCode, "00000") as the formula for the new "text" based ZipCode or zipPrint field.…
- Ben.2
- 4 yrs ago
- Get help
- Reported - view
Re: zipcode field removing leading zeroes
I have a table with zipcodes linked to a table with cities and states. I don't want to go through the hassle of reconnecting the fields, so I'm creating a ZipPrint field which is the display value of…
- Ben.2
- 4 yrs ago
- Get help
- Reported - view
Re: One to many relationship
Hi Sakshi, I am struggling to make this work between two numerical fields that already exist. Essentially, I have two tables: "collectors" and "artwork".…
- Ben.2
- 4 yrs ago
- Get help
- Reported - view
Re: Phone Number Formatting?
Cool! Looks great , and I definitely don't mind. It definitely feels more clean, this way and I like the # substitution. After playing with many ways to reference the field name with a variable,…
- Ben.2
- 4 yrs ago
- Get help
- Reported - view
Re: Phone Number Formatting?
Oh, great ! Thanks for the tip. Slightly off topic, but related to the codes here: is it possible to make a reference like let fieldname:= x at the beginning and then use if y then x:…
- Ben.2
- 4 yrs ago
- Get help
- Reported - view
Re: Phone Number Formatting?
I put the symbol and padding variables at the top so you can change them without having to hunt through the code.
- Ben.2
- 4 yrs ago
- Get help
- Reported - view
Re: Phone Number Formatting?
Halio, below is my latest code (with lots of ideas taken from Sean). It adds a "+" to any string of numbers over 10, adds the (###) ###-### formatting to any string of 10+ numbers,…
- Ben.2
- 4 yrs ago
- Get help
- Reported - view
Re: Phone Number Formatting?
Thanks for the info. I'm very amateur at scripting/coding, but I'm finding NX really easy to use, and the application in general extremely useful for my purposes.…
- Ben.2
- 4 yrs ago
- Get help
- Reported - view
Re: Phone Number Formatting?
Sean, your code is very elegant, and I didn't realize while reading up on NX script that it accepted character class formatting via replacex and extractx commands... I'll have to keep tweaking
- Ben.2
- 4 yrs ago
- Get help
- Reported - view
Re: Phone Number Formatting?
let input := trim(text(TestPhone));let break := "-";let p := length(input);let init := substr(input, 0, 1);if init = "0" or init = "1" or init = "2" or init = "3" or init = "4" or init = "5" or init…
- Ben.2
- 4 yrs ago
- Get help
- Reported - view
Re: Phone Number Formatting?
sean, your code looks great although I don't like the idea of the field setting to null if it doesn't get 10 digits. For my use, with a variety of international numbers in my database,…
- Ben.2
- 4 yrs ago
- Get help
- Reported - view
Re: Phone Number Formatting?
Hello Halio, I think you would need to add some sort of "if" function to check the start of the number. In the US, it is not permitted for an area code to start with "0" so I'm thinking of trying to…
- Ben.2
- 4 yrs ago
- Get help
- Reported - view

Back to top

Ninox-Documentation

Overview

View all topics