-
Duplicate several records with changing one of the fild values
Hello! I need help, guys! How can i duplicate lets say 10 records of a table simultaneously (not one by one), and at the same time automatically changing some text in one of the text fields?…
-
Frustrating time tracking down error fieldnames.
For the past week or so I have had field not found issues when opening a particular table. Spent hours trying to find the missing fields as reported. Even Ninext could not see them.…
-
Help with Changing Multiple If Statement to a Case Statement
I need help converting this multiple if statement to a case statement. Withdrawn and Graduated fields are yes/no. if Withdrawn = 0 and Graduated = 0 then let t := 'Enrolled Date';…
-
How can I create a dynamic multiple choice that uses selections from another dynamic multiple choice.
dMC A item 1 item 2 (selected) item 3 item 4 (selected dMC B shows the following item 2 item 4 The user select items 2 and 4 in dMC A. dMC B shows only the items choses in dMC A
- Answered
-
Create record in another table on a switch
Hi all, Bear with me as I'm a new user and don't have any tech / db-skills. If the answer to my question is in another post, please show me a link. I've tried to search the topics,…
-
double click in cell to activate input - buggy sort of
I notice that the 2 x click in a cell does not always work as expected. I recall others having this problem and advising how to get around it. Sometimes when I 2 x click the record slides in rather…
-
Retrieve the data from a button variable
Hello! I have a database in which I have a table "Dashboard" which is the page that displays when I open Ninox and another table "Accounts" containing all the contact details of my customers.…
- Answered
-
loop in query for view -- how to aggregate?
I use the below formula for a view and a dMC. Yet, it will only return the last record i, not all of them. When I create a button to alert all i, it will prove the loop works correctly.…
-
Is there a way to automatically display an attachment in a formula/image field?
I have paperclip attachments and would like to see them without opening/viewing via the paperclip. Is there some clever script that can be used to display the content of an attachment on screen via a…
-
Display and already uploaded attachment in an 'image field'
As a rule I try to avoid paperclip attachments or displaying large images in fields however on the odd occasion I would like to. Is there a way to display an attachment that has been uploaded in a…
-
Version 3.11
Where does one find this if it is in the Public Cloud New colour themes in Ninox settings New colour themes are now available in the Ninox settings to give your application a modern look.…
-
conditional unique() in column
my view should select all records in elements where the column "text" is unique for one label (being a linked record). So text "a" might appear both for label1 and label2,…
- Answered
-
Dynamic Dropdown sorting
Is there a way to sort the contents of a dynamic dropdown?
-
create options in choice field from variable/loop
It's easy to fill a dynamic Choice field with options from a table/query but how to dynamically create options through something like var options:=[] for i from 1 to 3 do options:=options + i end;…
- Answered
-
Reference field trigger error
Hello Ninox Brain Trust, I have an error occurring after a trigger for a reference field. Attached will be found a sample database that shows the error in the ‘INVOICE TEMPLATE’ reference field of…
- Answered
-
Duration in days, months and years
I'm fairly new at Ninox. I'm building a research database for history data in which we use a lot of dates, for ages, duration of events, etc. An easy readable display of duration would be great for…
-
Custom Buttons
My contribution for the holidays is this template that allows you to create personalized buttons. Happy Holidays! Download and leave a review here...
-
Coding a popup dialog in a for loop if error
I've been reading that loops cannot be coded to exit. But I'm trying to figure out if there could be a way by adding an if statement somewhere in the code.…
- Answered
-
Photo preview but no import
Hi, I'd like to use Ninox for a project that involves many photos. Would it be possible to just refer to an image, and let Ninox generate a preview image but not import the image to reduce the size…
-
Constraints issue
In Proj-Buildings I select the BUILDING NAME taken from BUILDINGS. The constraint here: a.PROJECTS.CLIENT.NAME = b.ORGANISATION.NAME Limits the Buildings list to those for the client/organisation.…
- Answered
-
Compound filter for a view
Hi All, I would like to do a compound filter in a view by using a date range and a dynamic multiple choice. That way I can filter for one or more customer sales within a given date range.…
-
Using triggers for yes/no field
I have tried using the visual part of the Ninox formula and various forms of this text in the script writing, all to no avail. if Status = ("Closed" or "Expired") and 'Campaign Premium' > 0 then…
- Answered
-
Word Wrap doesn't function when you apply a rule to a table
Typical of Ninox, they implement a nice feature with rules in the table but then mess it up because they don't completely make the feature work cosmetically.…
-
Collaborator field options
Is there any way to display more than the default for a collaborator field? For example displaying the email address for the collaborator in an adjacent formula field or in the drop down selection of…
-
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?