-
What are the Record Comment Notification capabilities?
I'm looking at using a table for a simple internal communications platform. Can users get notifications when someone adds a comment to a record? Maybe a better question is,…
-
Treating string with commas, as an array?
Hi, I have a string in a text field, lets say it is 'colours' : red, blue, black. If I use item(colours, 3), it will return 'e', instead of black, due to it being a string and not an array.…
-
Can you password protect a table?
Trying to find a way to password protect a Table but can't seems to find this anywhere.
-
How to move Multi-columns from Available to Visible?
Quick question, I have a lot of columns in a database and I quickly want to move over all or most of them to be visible. As a newbie to Ninoxdb I've been dragging them individually but as I am…
-
Problems with Date/Time field
The below code isn't working in the web version: --- let d := date('Date / Time');select Table where date('Date / Time') = d --- Works fine in the Mac app.
-
Unsorted Linked Table
I have a Table called WORK, which has a linked table for CUSTOMER. When I start filling in the form of WORK and come to the linked table field for CUSTOMER,…
-
Wanting a single record instead of the array.
I am using this reference in a formula field : (select ContactTypeJoinTable)[text(ContactTypeChoice.Category) = "Supplier"].Contact.Company In my formula field I now get all records of 'Company' with…
-
Formula - move record to another table
Hi all I have a Quotes table and an Orderstable. I'd like to add a "Convert To Order" button to quotes. I've gotten part of the formula working, but my issue is with the line items.…
-
I have a question about using a URL field.
Is it posible to not only enter a URL into the field, but also fill in a user name and password for that website.
-
Best Practice - Forcing search results - formula vs update text field on trigger
Hi all At the moment, to make results appear how I want in search/lookup functions, I have 7 formula fields at the top of the form that contain info I want to appear in the search.…
-
Tracking User Activity
Is it possible to build a table to count individual user actions in the database as a whole? I want to implement a fun rank and title system, similar to the one on this forum (Apprentice, Ninja, Monk,…
-
Best solution to print texts with a record data if there are many of these texts?
I have a Patients table with their data (name, id number,...). Each time a patient does a different treatment he has to sign a corresponding informed consignment (IC).…
-
is it possible to program a button using statements contained in a choice pull down menu?
is it possible to program a button using statements contained in a choice pull down menu?
-
Is it possible to have small field presentation ?
Hello everyone, I have a table with different kinds of field but when it came to make a layout, they seem to have a minimum space and I cannot shrink them.…
-
Is it possible to use a dot as a decimal separator instead of a comma in a numeric field ?
I think that everything is in the title. regards
-
popup tab
Hi good morning in a table I set two different layout tab views when I try to popup this table I always popup the first, the main layout. how can I popup the second? Which is the proper grammar?…
-
How would I populate a table with random elements from several other tables when I add a record?
I have a table to use as a display and the items from it need to be randomly generated from several other tables. All. of the tables have a unique integer key so randomly generating a number based on…
-
Printout of values
Years back I programmed dBase 4 (and yes, I am very old). When troubleshooting, I could insert print statements which would let me look at calculated values.…
-
pc
is there a pc application
-
Formula comment
How do I make a part of a formula a comment rather than deleting when I am troubleshooting.
-
No attachment file in mail
Hi, I would like to send an email with attachment file, the email is sended but no file attached ! this is my code let myPdf := printAndSaveRecord(this, "DEPANNAGE"); let myName :…
-
how do I use "undefined" in a logical formula?
What is the code for "undefined" in a logical formula, for instance, if the answer to a yes / no question is missing? Thanks
-
How can I optimize a table with lot of data?
I have a table with 728,000 entries. Each entry has about 24 fields - six of which are formula fields. As you can well imagine, whenever I query this table, things tend to slow down,…
-
Increase number by decimal
I thought I posted this but, can't find it so here we go again... I have a version number field, which when I create a new record I need to automatically increase by 0.1.…
Answer questions and share your knowledge