-
HTML text format doesn't work in view print preview
I'm using the html() function in formulas to make selected text bold (SECURITY DEPOSIT), leaving text before and after at the default setting: ... Premises.…
- Answered
-
How to update a field with a lookup value from another table?
In the image above, I have selected an employee from the Employee table via pop-up. Now, however, I want to populate the "emp_fk" field in the Tasks table with the Employee's "emp_pk" field from the…
- Answered
-
How to Calculate Cumulative Sum
I have this info on my Table COST_W, I have the Week, the Cost by Week, but I need a Formula for calculate the Cumulative Sum. On the Table EV_Management is where I charge the Cost by Activitie and…
- Answered
-
AGE function
Not so long ago I watched a video lesson where they talked about the global function ageYM. but I can't find where to copy this formula. can anyone tell me where all the global functions can be…
- Answered
-
Script for Inventory
Hello everyone, For information, I only speak French. So the following is translated by "google translate". I start with NINOX. I am busy developing a table allowing me to carry out inventories.…
- Answered
-
Look up value in table based on two other values
I'm new to Ninox and am trying to set up a database for a distillery's production records. One thing I need to accomplish is a formula that can look up a value in another table based on two inputs.…
- Answered
-
Spam with sendEmail
Hello I have a issue. I send email via ninox and the email goes in spam each time. Any idea how to fix the situation and get the email in mailbox ? here the code sendEmail({ from:…
- Answered
-
Character Occurrences Count
Hello, I'm wondering if there's a way to count how many times a given character is in a string. i.e.: I have the field 'mytext' which contains a string (let's say "rockandrollwillneverdie") and I…
- Answered
-
How to get a filtered sum() from a table-value, where all have a common category?
I need to get the sum() Formula working that it not only gets me the sum of a specific field of a table, but also a filtered value. Like, all data-entries have a numbervalue and i just want to have…
- Answered
-
use yesterday's information in the table
Hello I need some information from yesterday to automatically pass to the next day. I have a formula that does it all, but there is a problem, it changes all previous days, that is,…
- Answered
-
Another Multiple Choice (Dynamic) question
How can the list of choices be filtered? Sorting the list is straightforward, but I cannot figure a way to filter them. By which I mean e.g. select choices where Id > 2 The idea is that the list of…
- Answered
-
Sub-Tables - Add existing record
Has something changed with the new version (3.7.6) with regards to sub-tables? When a table has a sub-table linked to it there are now two buttons on the sub-table to "Add existing record" and…
- Answered
-
Within switch do structure, is there a determined structure of how to define variables?
I am only just learning to code in Ninox and I was busting in my head trying to figure out why I kept getting an error message, and it turns out it had to do with the sequence in which I determined…
- Answered
-
Integration of the ICD-11 Coding Tool into a Ninox database
Hi, I use a Ninox database to keep electronic medical records of my patients. I am writing here looking for help to integrate the ICD-11 Coding Tool into my Ninox database.…
- Answered
-
Ninox Not Syncing with iCloud
I downloaded the iCloud Ninox app, but it doesn't see the Ninox databases that are in my iCloud account. The only (apparently non-synching) way I can get the data on iPhone is to save an archive.…
- Answered
-
Button to create new record for sub-table and with reference
Hello. Apologize for my lack of knowledge in coding. I have a button (Update_Storage) which is supposed to create a new record for a sub-table (History) and copy information in from another table…
- Answered
-
Select all choice in a multiple choice (dynamic)
Hi! In a trigger after update of a field (YES, NO), I would like the code select all options in a multiple choice (dynamic) if YES, Which code should I use? Thanks!
- Answered
-
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
-
Get count of chosen values from different table
Hello, The formula below counts the number of records in the table Timetable where the choice field Jim has been chosen the value "norm" (it works). count(select Timetable where text(Jim) = "norm")…
- Answered
-
Split Function Help
hi to all! I have got this tables in Ninox: TABLE: Genres Field: Genre TABLE: Masters Field (in error): Genre The field in TABLE Master can have 1 or more Genres,…
- Answered
-
Set Choice Value
Hello, I am creating a button to set a value of Box1 to 'Active' (id1). How do I set the choice value of clicking the button instead of: Box1 := 1 I tried: Box1 := text("Active") Box1 := "Active:…
- Answered
-
Account flows
In the Accounts table, I have a view called Flows with the following script. It gives the correct dataset but would like to filter out from that dataset the selected account ledger line items (that…
- Answered
-
Renaming part of title attachment
I need to assign the rename function to the button "Manuell Nr zuweisen". By clicking on it, an alert field should come out in which you are asked to enter the number you want with a blank field to…
- Answered
-
Switch Case Statement: combine multiple cases with same code
I have a switch/case statement where I would like to combine "case 1:" and "case 4:" since both use the same if/then code (rather than duplicate the code in a separate "case 4:…
- Answered
-
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
Answer questions and share your knowledge