-
Ninext : Fields inspector (evaluate the impact of changing/deleting a field before to do)
Hello everyone, Have you ever had a cold sweat before deleting a field in a table ? I always wonder what will happen. And the more my database is important,…
-
add onselect event for view field
In response to @Alain Fontaine & @Fred Christmas wish (https://forum.ninox.com/t/h7hbkmp?r=h7hbvzj), I have added a viewEvent function to Ninext project.…
-
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...
-
Custom HTML Dashboard
Hello, i was looking to create a custom Dashboard in Ninox to have a clear overview over some important KPIs and also allow controllers to get a quick view at key data.…
-
Matching Phone Area Codes to Region
So, for a lot of Data I receive, I don't have any location material besides one's phone area code. I know that the area code is not the most accurate in todays cell-phone age,…
-
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.…
-
Ninox names vs user names
Is it possible to access a list of the Ninox element names used for the User defined names? I inadvertently deleted a link to a table 'Projects' which Ninox has 'CA'.…
- Answered
-
Conditional formula to calculate 'taxable' and 'non taxable' items...
Hello, I'm trying to figure out how to include two fields that calculate the sum of taxable and non-taxable items. If you look at the attached image, you'll see that there's a field for the base…
-
Dynamic Reports - my first attempt
Hi there, Here I was thinking it would be straight forward. I have a docx template and in Word I added {d.'PROJECT TITLE'} as a data field (it's spelt correctly, all UPPER).…
- Answered
-
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
-
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
-
Auto-increment?
Is there currently an auto-increment field of some type? If not, is there a way in code? (I found some old posts, so I don't know how relevant they are anymore,…
-
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
-
Font in print layout
I would like to integrate the Arial Black font into the field where the number 978 is indicated in the print layout. I set the Arial Black font from the desktop app for mac.…
-
Hiding Icons HUD - choosing which to hide
I use this to hide ALL icons etc on forms. I have tried to show only the PRINT icon by removing 'none' in the relevant line but regardless of refreshing the page or toggling the HUD Y/N the print…
- Answered
-
Auto-populate pricing from another table?
Ok Ninox wizards, now I'm trying to auto-populate some pricing and job details. Here are the top level details: Main table is 'Job Status Log' which has 100s of job entries that are connected to my...…
-
Auto-populate Music Library Fields
I am working on databasing all of my sheet music and would like to auto-populate a field on one table with information from two other tables if possible.…
- Answered
-
Create new records with a button
Hello! I've been learning a lot with Ninox and this forum has been very helpful. This is the first time that I would be creating a button. But I think it is possible to make the process easier and…
-
3.10 BUG feed back please.
When I try to select an option here, I get nothing offered. Can anyone confirm before I report to Support
-
Formula to Include Multiple Filters from Choice Fields
Ok, I have been stumbling a few days over this trying to get the right formula. What I am doing is creating a sub table to give me the values I need, so then I can draw those into a chart correctly.…
- Answered
-
Files on google drive
In looking for other topics on this I have not quite found what i want on the forum. So at the moment I am storing images of files (customer Order Acknowledgement/ Delivery Note etc) within 6 set…
-
Enter the content of another field inside a rich text field
Hello again. I'm just ending the development of a custom application that needs to print and export some rich text fields with lots of text. What I need is some kind of "data merge" inside a rich…
-
Show "1" instead UNDEFINED
Good morning everyone, I am writing because I need "Field1" to show the result "1" when the result of the formula is "undefined". Otherwise it must show the correct number, extracted by the formula.…
- Answered
-
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';…
-
Copy to clipboard: Multi-line referenced table
Hi Folks, Here's a doozy (well, hopefully not). I'd like to add a 'Copy' button below a referenced table "Project Details". Within that table, I'd like to copy a couple of fields:…