Mconneen

1140
13
1

Joined: Fri May 11 20:44:06 UTC 2018

My Posts

Latest Posts

Re: Hide a record?
I guess you can create a "view" .. and exclude / hide based on your criteria... .. Or create an attribute "hide row" and set it to true . and create a view and show only rows where "hide row" is…
- Mconneen
- 6 yrs ago
- Get help
- Reported - view
Re: Bingo Board Strategies
Sorry .. forgot to include a screen shot..
- Mconneen
- 6 yrs ago
- Get help
- Reported - view
Re: Bingo Board Strategies
OK.. another stragegy to meet the UI constraints is this.. Do not worry about the sort order of "BINGO". I will fixt that... the Point.. To address the constrainst of the UI...…
- Mconneen
- 6 yrs ago
- Get help
- Reported - view
Bingo Board Strategies

OK.. Looking for some ideas about a traditional bingo board.. I tried buttons.. but they are too big. I tried text fields.. the same.. to big to get 16 across the screen....…
- Mconneen
- 6 yrs ago
- 7replies
- 3021
- Get help
Re: Trigger after update previous value.
Jörg, Thanks.. I downloaded a back up of it.. Interesting that you put the code at the FIELD level.. I would have expected it at the table level.. this way.. if I have N attributes (aka fields) ..…
- Mconneen
- 6 yrs ago
- Get help
- Reported - view
Re: Create automatic records
I like your thinking there @slowwagon. Is "Trigger on Open" an existing trigger? That.. combined with a command line such that you can pass in the name of a database to start with would suffice.. :)
- Mconneen
- 6 yrs ago
- Get help
- Reported - view
Re: Can I open and use two databases at the same time?
Interesting use case. A nice enhancement to the Mac / iCloud version would be "hot swapping" or "fast switching" between databases. In the meantime, best approach may be to combine both databases…
- Mconneen
- 6 yrs ago
- Get help
- Reported - view
Re: Create automatic records
If using the Ninox cloud.. Most likely can be accomplished with Zapier of calling a web services. If using Mac / iCloud... I am not aware of Ninox having a command line version..
- Mconneen
- 6 yrs ago
- Get help
- Reported - view
Re: Do functions support the use of comments?
Thanks Alex.. I was trolling the forum and found a thread that indicated the following works.. I just tested it .. and it does.. but still seems a more strutured "comment" syntax is in order..…
- Mconneen
- 6 yrs ago
- Get help
- Reported - view
Re: Trigger after update previous value.
When creating your audit table. Once you have everything you want.. You may want to "hide" it.. Once you do that.... NO ONE can see the table.. As and Administrator.. you can go to the Data Model..…
- Mconneen
- 6 yrs ago
- Get help
- Reported - view
Re: Days to Hours
Maybe support can lead us to a format statement.. but in my few hacks.. I could not figure it out..
- Mconneen
- 6 yrs ago
- Get help
- Reported - view
Re: Trigger after update previous value.
OK.. So I am still "learning" how the triggers work. Playing around.. from a button that updates two fields.. TWO table after update triggers fire. I would have expected ONE..…
- Mconneen
- 6 yrs ago
- Get help
- Reported - view
Re: Trigger after update previous value.
I do this with SQL stored procedures all the time. Basically .. create your audit table as a mirror of your main table (all columns)... plus additional timestamp. Then..…
- Mconneen
- 6 yrs ago
- Get help
- Reported - view
Re: Days to Hours
I did it on an the tables after update trigger.
- Mconneen
- 6 yrs ago
- Get help
- Reported - view
Re: Days to Hours
Why not just populate the Time Interval field with the result of the calculation?
- Mconneen
- 6 yrs ago
- Get help
- Reported - view
Re: Call a button from a trigger
I recieved an email response from support ... "This is intended behaviour. "onCreate" and "onChange" Trigger will not fire if they themselves triggered by a script. This is a safety feature."
- Mconneen
- 6 yrs ago
- Get help
- Reported - view
Re: Unique Alpha-Numeric Formula
See table "UniqueKey" http://mconneen.infointegrators.net/ninox/NX-Language-Tutorial.ninox
- Mconneen
- 6 yrs ago
- Get help
- Reported - view
Re: Call a button from a trigger
Here is the sample database... See 9. Working with Triggers.. http://mconneen.infointegrators.net/ninox/NX-Language-Tutorial.ninox
- Mconneen
- 6 yrs ago
- Get help
- Reported - view
Re: Call a button from a trigger
OK @jim.. Try this... MOVE each of your button forumulas to a table after update function. Create yes/no fields for each of your validation functions / buttons...…
- Mconneen
- 6 yrs ago
- Get help
- Reported - view
Re: who can develop a small apple script to copy my notes content into a Ninox's text field
google for the attachment logic.. I recall seeing one that pulled the attachments and put them in named folders / subfolders on the desktop. The script I published will at least xfer the notes into a…
- Mconneen
- 6 yrs ago
- Get help
- Reported - view
Re: Trigger
Hmm.. both seem to fire.. but interestingly enough.. I have an alert("Field Trigger") in the fields after update .. and an "alert("Table Trigger") in the tables after update..…
- Mconneen
- 6 yrs ago
- Get help
- Reported - view
Re: Trigger
If I have a "trigger on update" of a FIELD.. and a tigger on update of the TABLE.. Do BOTH triggers fire with FIELD is updated? I am finding that only the TABLE trigger after update seems to fire.
- Mconneen
- 6 yrs ago
- Get help
- Reported - view
Re: Call a button from a trigger
Doing an RTFM (Read the fun manual) .. I see https://ninoxdb.de/en/manual/calculations/triggers which states "A trigger is an operation that is executed each time when the corresponding field is…
- Mconneen
- 6 yrs ago
- Get help
- Reported - view
Re: Call a button from a trigger
Yeah.. I just tried it myself.. It DOES work from the button.. but it does NOT work on other fields.. I put an example in the NX-Language-Tutorial.ninox sample database and sent it to support.…
- Mconneen
- 6 yrs ago
- Get help
- Reported - view
Re: Call a button from a trigger
jim@jcschell.com ... Try this.. Create a field .. say "Validate Data Procedure". Move your button logic into 'Validate Data Procedure' trigger after update. Then...…
- Mconneen
- 6 yrs ago
- Get help
- Reported - view

1 40 41 42 43 44 45 46

Welcome to the Ninox community

Mconneen

My Posts

Re: Hide a record?

Re: Bingo Board Strategies

Re: Bingo Board Strategies

Bingo Board Strategies

Re: Trigger after update previous value.

Re: Create automatic records

Re: Can I open and use two databases at the same time?

Re: Create automatic records

Re: Do functions support the use of comments?

Re: Trigger after update previous value.

Re: Days to Hours

Re: Trigger after update previous value.

Re: Trigger after update previous value.

Re: Days to Hours

Re: Days to Hours

Re: Call a button from a trigger

Re: Unique Alpha-Numeric Formula

Re: Call a button from a trigger

Re: Call a button from a trigger

Re: who can develop a small apple script to copy my notes content into a Ninox's text field

Re: Trigger

Re: Trigger

Re: Call a button from a trigger

Re: Call a button from a trigger

Re: Call a button from a trigger

Overview