-
Is it possible to merge two records in same db?
I have a contact db and wanted to update the records that originate in Google Contacts. I created a csv and mapped the fields, then mapped the fields with identical labels, e.g. First Name, Surname.…
- Answered
-
Interesting HTML functionality
So I have a dashboard with three formula fields that show HTML tables. Here are the Leagues and their respective colors. Now on my dashboard the GCL League looks like this:…
-
An idea for a Ninext tweak.
@Jacques TUR Would this be possible? To have a tooltip concept when hovering over a cell that displays the full content of that cell. This could be handy where cell width is reduced,…
- Answered
-
The Ninox Learning Lab is offered most Thursdays at 12pm EDT/ 5pm BST/ 6pm GMT and is free.
The Ninox Learning Lab is offered most Thursdays at 12pm EDT/ 5pm BST/ 6pm GMT and is free. The Ninox Learning Lab has provided training and support to thousands of Ninox users all over the world…
-
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.…