-
formatted currency and dmcf issue
Hello, pls take a look at this post. https://forum.ninox.com/t/q6yhnnp?r=g9yhag2 I would like to open a new thread about. Credit goes to Rafael, who was so kind to share a very nice dashboard view,…
-
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
-
Multiple Choice not working on iPad/iPhone app
For a few weeks now i am not able to choose an option from a multiple choice field both on the iPad and on the iPhone app. Still working perfect on the Mac.…
-
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..
如何将这些元素居中? (红线) 谢谢!