-
Duplicate Marking Utility for Large Datasets
I don't know at what point using cnt(select YourTable where YourField = CurrentField) > 1 becomes impractical, but I recently had the opportunity to work with a table that had 64,000+ records,…
-
Highligh patients with symptoms
I have a database with a main table with the names of the patients and a one-to-many connected table where I insert the visits of each patient. At each visit I mark whether the patient has new…
-
How to format a date+time field in a dynamic print layout
Hello, I would appreciate your help because I'm stuck with the following: How do we format a date+time field to display only the date in dynamic printing? I have tried to add the Carbone formatter [:…
- Answered
-
Variables
Hi, I have a "Leads" table where I record the leads of my business. Associated with this is another table where I record appointments with leads ("Meetings").…
-
do a record mod whilst runnings an Api script
whist running the below script . I would like to modify a yes/no field in the table records after it deletes the files for each record. ie 'ImagesDeleted' := 2'.…
-
Improve my script?
I have a "Print" button script that Works without issue! The idea is that if a customer quote contains product images in it, then the appropriate printout format is selected to include or not include…
- Answered
-
3.10.6 weirdness
So I checked by usage today and this is what I saw: The Cloud DBs workspace has only 1 DB and, when I last checked a few days ago, it was under 50GB and only 1 DB was displayed. I've opened a ticket.
-
onclick = ui.openRecord
Not sure if this is the right place to ask this but I have the following question. Can the onclick event "ui.openrecord" in a button also be executed in a function in javascript? For example:…
-
How to open an image through a function field.
I have an image for a registrant in table A I display that image in other tables using a function field. Is it possible to open that image by clicking on the function field?
-
What happend here
Is freeze
-
2 multiple choice creat records ?
In ninox I have two TABLEs The fields of table1 include: household (multiple choice), for example, A01.A02.... Floor (multiple choice) fields, such as 02F.03F.....…
-
New here, could use some help with batch requests
Hello everyone, Using Ninox for some months now. Must figure a lot of stuff out. Really enjoying it to search multiple files for data so that I can (manually) add found data to a master file (my…
-
Practical database to use/learn the Ninox API
I am providing a small sample database here so that you can try it out for yourself and understand how the options shown in the Ninox documentation work in practice with the Rest API.…
-
shareLink Problem
1. I create a text field (ShareField) 2. I create a button with this code. for i in select Albums do i.(ShareLink := shareFile(Cover)) end Copy 3. I try to show the Cover here.…
- Answered
-
How to write code to batch update data in two or more child tables?
Table2 works if there is only one line of data. However, I need to modify multiple lines of data. How do I modify my code? Uploaded files,Thank you for your help!
- Answered
-
Top left Global search
I never use the Global Search top left because it really does need some refinement by Messrs Ninox before it really comes into its own. For one users need to be able to choose columns.…
-
DB Size Problem
Hello, i'm having issues with my DB that for some reason is over 3.6gb in size and causing therfore problems with our license usage. We mainly store images in our records,…
-
Save record to a log file. error
Hmm can't quit get this right I have a script to cycle through contacts table to emails all contacts. which works perfectly. However I now want to as apart of that email process add a record into…
- Answered
-
How to Update in Batch?need your Help.
I want to batch update the "man" data in table1 to "woman" associated with it, without affecting the data not associated with it. How do I do it? Thank you. File uploaded
- Answered
-
<span onclick> , Is it possible in a Formula (html) with for from to do loop ?
Hi, I have seen resent posts where span onclick is discussed. I wonder if it is possible to implement this in my example. I intedent do upload this as a DB,…
- Answered
-
Limit Input to Rational Numbers in a Text Field
This code can be applied to "Trigger after update" in a text field to limit the input to rational numbers. It does not accept characters other than "-", [0-9] and ".…
-
double entries
Hi Ninox users, I'm looking for: prevent double entries in fields with a warning text popup. How to do this? Can someone help me with this? Regards and thanks Rob
-
in Print pdf when..
如何将这些元素居中? (红线) 谢谢!
-
Relationship between 2 tables - how to?
Hi I'm a musical director with a choir. I need to track which songs are going to be sung at each rehearsal. So I have created a table with all the songs:…
-
Ninox Mac app and macOS 14.0 (Sonoma)
Just to inform you... I just upgraded to macOS 14.0 (Sonoma) mac and the Ninox 3.9.3 Mac app works fine.