K Gamble
- Latest Posts
-
Views are not saved when I close database
Using Ninox locally on my iMac. I create new views (usually Table views) or modify existing views - both in normal and editor mode. When I close my database and come back in - the views may or may…
-
Ninox DB shuts down with large Deletes
When I delete a large amount of records (30k or so) - either with a button (delete select 'table') or by going to the table and doing 'select all' and 'delete' - the database shuts down (either…
-
Test if File(this,file.png) exists
I'm using the file(this, "image name") and want to add a condition when the function does not return an image. I tried 'not file..' and such but does not work.…
-
Can I use importfile() to pull in a local file instead of web file?
I'm trying to use importFile(this, "file:///users/....") . to add a file as an attachment without luck (on a mac) Does file:/// work? - all the examples I found use http:…
-
New functionality that I found with 2.5
1 - seems like you can pass table records into a function now. For example - I have a table called Scene - and can now write function like: function addNumber(s: Scene, n: number) do ....…
-
Dialog box from Update trigger
I cannot get a dialog box to popup if I put it in the 'Trigger After Update' script. I can get an Alert to popup from there - but not a dialog. I can copy/paste the same dialog into a formula or…
-
Find index position of a value within an array
Is there a function to find the index number of an item in an array? For example - array of [a,b,c,d] - how do I find that b is in the '1' position in the array? I know I can do item(array,…
-
Add Triggers when clicking on a record in a sub table or view
Ability to kick off a trigger script when the user clicks on a row in a sub table or view that is displayed in the form, so you perform an action prior to viewing the sub record.
-
Add System Variables/Settings
Provide the ability to create and store system variables - like "Last Viewed Customer", "Active Record", etc where you could use scripting and triggers to set a variable value to reference in other…
-
Drop out of a FOR loop early
Is there a BREAK command word to stop a loop - when a condition is met prior to cycling thru all the items in the loop? Can't seem to find a way to make it work without using a WHILE loop instead.
-
Suggestion: find references to fields in code
Ability to find where a field is referenced in various function scripts, buttons, triggers, constraints, etc. Useful to know when deleting or changing a field - the impact it could have on other…
-
Forms
Is it possible to re-order the tabs?