Contact Sales to request a demo
Request demo
Product
Platforms
Templates
Security
Customer Reviews
Product Updates
Solutions
Success Stories
Partners
Partners
Become Our Partner
Pricing
Support
Help Center
Webinars
Hero Webinar
Manual
Forum
Tutorial Videos
Blog
Contact us
Search
How to enable Javascript
Sign Up
Log in
Support
Forum
Home
Search the community
Home
Learn & Share
Get help
Knowledge Base
Latest Activity
Contact Us
Privacy
Home
Latest Posts
Re: Detect list selection
Ok, your example works for me. So I considered the difference from my db. I added an onselected() function (that does nothing of any use) in my initialisation table.…
UKenGB
UKenGB
6 days ago
Get help
Reported - view
Re: Detect list selection
That's it. The modules have to be loaded by a formula field in that table, or the onselected() function doesn't run, even though the JS calc still works.…
UKenGB
UKenGB
6 days ago
Get help
Reported - view
Re: Detect list selection
The only difference I can think of is that yesterday I ran the load module code in a formula field on that same form (next to the test JS calculation),…
UKenGB
UKenGB
6 days ago
Get help
Reported - view
Re: Detect list selection
@Jacques TUR On same form as field testbool, there is the JavaScript calculation (from your test example) that always shows 30, so that is working.
UKenGB
UKenGB
6 days ago
Get help
Reported - view
Re: Detect list selection
I set up a very simple test, exactly as you did in the example above. In 'Readable if' I have:- function onselected() do this.(testbool := true) end; true testbool is as it seems,…
UKenGB
UKenGB
6 days ago
Get help
Reported - view
Re: Detect list selection
Now I am completely confused. I ran the code to load the modules in a formula field, saw the expected result and then clicking on any row in the table's main view,…
UKenGB
UKenGB
6 days ago
Get help
Reported - view
Re: Detect list selection
@Jacques TUR I thought it was probably as you say. I had an idea, but dialog() won't allow html and although alert() doesn't complain, it just displays the JS and doesn't run it. So that was a bust.…
UKenGB
UKenGB
6 days ago
Get help
Reported - view
Re: Detect list selection
The above, placed in a formula field does load the extended functions, but not in either the Console, nor in 'Trigger after open' and I cannot really figure out why.…
UKenGB
UKenGB
7 days ago
Get help
Reported - view
Re: Detect list selection
Ok, I can see what it's doing, but could that initialisation code be placed actually in 'Trigger after open'? Surely is just needs to run and doesn't matter where,…
UKenGB
UKenGB
7 days ago
Get help
Reported - view
Re: Detect list selection
I will get back to this shortly, but could I ask a couple of questions here (asked on Github, but it seems you are not reading those 'issues':- Does the code to load these have to be run for every…
UKenGB
UKenGB
7 days ago
Get help
Reported - view
Re: Detect list selection
@Jacques TUR I can use 'Trigger before view' which works the first time the record is opened, but that is not triggered just when switching rows.
UKenGB
UKenGB
8 days ago
Get help
Reported - view
Re: Detect list selection
@Jacques TUR Ah, but my code needs to set a value and Ninox complains:- "This formula may not modify data"
UKenGB
UKenGB
8 days ago
Get help
Reported - view
Re: Detect list selection
@Jacques TUR I need to run some code when a row is first selected or changed. I have a workaround that requires clicking a button instead, but would be so much better if this was done automatically…
UKenGB
UKenGB
8 days ago
Get help
Reported - view
Re: Detect list selection
@Jacques TUR How does one add the onSelect function to the actual main list view of a table? Not just a 'view' field added to a form where one creates the selection and can add the onSelect function,…
UKenGB
UKenGB
9 days ago
Get help
Reported - view
Re: Detect list selection
@Jacques TUR It most certainly will. Thanks for the extended function and for the pointer to where I can find it. I think it will be extremely useful.
UKenGB
UKenGB
9 days ago
Get help
Reported - view
Detect list selection
In a table view/list, select a row and the form slides out. One can move the selection up and down the list and the form data changes to reflect the selected row. Standard Ninox behaviour.…
UKenGB
UKenGB
9 days ago
27
replies
103
Get help
Re: sibling tables
Cracked it.
I created a 'dummy' field in p, with binding set to 'Global in memory' (or words to that effect). Then when I update c1.number, the update trigger also updates p.dummy.…
UKenGB
UKenGB
10 days ago
1
Get help
Reported - view
Re: sibling tables
@RoSoft_Steven Yes I tried that, but the view was always simply blank as if the source for a view HAS to be a table and it cannot work from a JSON list.…
UKenGB
UKenGB
10 days ago
Get help
Reported - view
Re: sibling tables
@Fred No, p is THE link between c1 and c2, no other connection. I can build p's list of c2s either just using Ninox relationships or using a more explicit 'select …' statement, Same result.…
UKenGB
UKenGB
10 days ago
Get help
Reported - view
Re: sibling tables
Further explanation. [p] / \ [c1] [c2] c1 and c2 both contain a number field I want to build a list of c1's p's c2 records with a calculated column c1.number x c2.number So c1.…
UKenGB
UKenGB
11 days ago
Get help
Reported - view
sibling tables
I've been struggling with this for a while but no nearer to a solution so looking for inspiration from here. I have a parent table (p) with 2 child tables (c1 and c2).…
UKenGB
UKenGB
11 days ago
7
replies
37
Get help
Re: acces to array items like with Where fonction
@Jacques TUR
UKenGB
UKenGB
1 mth ago
Learn & Share
Reported - view
Re: Dynamic Choice from Dynamic Multi Choice
@Fred Interesting, but I want to simply duplicate the options available (i.e. only some records from the source table) rather than the selection state.…
UKenGB
UKenGB
1 mth ago
Get help
Reported - view
Re: acces to array items like with Where fonction
@Jacques TUR You are often using // to mean a comment and I was quite excited thinking we finally could include comments. However that certainly doesn't work on Mac 3.6.8 (the latest AFAIK).…
UKenGB
UKenGB
1 mth ago
Learn & Share
Reported - view
Re: Dynamic Choice from Dynamic Multi Choice
@Fred said: this post That was fascinating, but I'll need to go over it a few times. For the last few months I've been using what I had previously created with Ninox and missed some new changes.
UKenGB
UKenGB
1 mth ago
Get help
Reported - view
1
2
3
4
5
6
Next
UKenGB
UKenGB
143
2
0
Joined: 02 Jul 2021
Follow
Home
Learn & Share
Get help
View all topics
Tags