-
Open Record based on UserName
Good morning! I am trying to make my database more user friendly and was wondering the following. I have a table called Timesheet. I have a dashboard too.…
- Answered
-
Script for Search by Artist Name
Need a script for search by artist name, the screen is a Dashboard and take the from Albums. On view Discography
- Answered
-
Avoid spaces in a sum function when a variable is empty/void
Hello, the product name in my products database is a sum of 9 text and number fields, like this article + " " + Color + " " + more stuffs + " " +kg + " " lt" it works for normal use but in print view,…
- Answered
-
JSON: add a block based on a given condition
Hello. I am creating an XML file and would like to start with a JSON because it offers greater readability and ease of maintenance. In the structure of the JSON how can I decide to add blocks…
- Answered
-
Formula to Count item per Week
Hi I Need a Formula to count the amount of 'Rev A' per Week Example Week 15 - 3 Week 16 - 1
- Answered
-
Sum of values of a field of a specific date
I'm looking (and can't find) a solution to calculate the grand total of a field of a given date... No problem illustrating this with a view, but that's no use to me since I need it as a value in a…
- Answered
-
Force trigger after update with mass update
I have a table called "Bancos" where I import a CSV file with the bank statement. As I wasn't sure on how to, once imported all records, create a new entry on a different table "Entradas/Salidas"…
- Answered
-
Unique / Concat giving different results
Hi all. I have a table showing Orders, in which I have Items that are linked to Products, which each have their own Product Categories (in a multiple choice field).…
- Answered
-
Display multiple dynamic choice items separated by returns rather than commas in Print
I have a table with a dynamic multiple choice field. I am trying print a record with the contents of the dynamic choice field displayed on separate lines.…
- Answered
-
Parameters it is possible to pass to a function
Hi, fairly new to Ninox and now in the process of "tidying" up a database which has become a bit untidy in terms of number of fields and duplication, this thread sort of fits with what I am trying to…
- Answered
-
Hide Multiple fields at once
Hi, I know we can hide individual fields by going to Display field only, if & entering "null". I have say 10 fields that I want to hide. For that to happen,…
- Answered
-
Define start of fiscal year
I can use the function yearweek() to define the week number within the year, but that does not sync with my employer’s fiscal year, which begins on the first Monday of the new year.…
- Answered
-
Script for transfer record N:1
I had to create an additiona table with relation N:1. Table A Reference N:1 to Table B On Table A now I have records included and I need to Include them in the Tabke B, isthere any scripts to do that.…
- 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
-
Using if statements and date calculations to display yes or no based on variable.
I'm new to this program so forgive me, I'm trying to implement an idea rapidly without understanding how complex...or not complex I am going with my attempt at functions... and failing.…
- Answered
-
Time interval use and sum
Hi, there is something I don't seem to understand (odd, uh?) when use time interval fields. I want to define the daily working time and since it doesn't matter when job starts or ends,…
- Answered
-
Filter on hidden columns
Hi, How do I get a view which is a subset of the main table which does not show the field to which the filter is applied. I have a table which lists photographic films which has a text field for…
- Answered
-
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
-
Message - Improvement
Heres a thing... As these days I work mainly from home - I have a reminder that if appropriate! sends and email to my team at the office when I log into Ninox.…
- Answered
-
Need to link each expense from this week to a record and then link it to the main table
Hello! I have in this issue, three tables: 1st Table: Management (for each week there is a record. 2nd Table: Fixe Ausgaben (every record is one expense, which is recurring monthly on a specific date.…
- Answered
-
Automatically link record from one table to open record in another table using a button
In Audits Plan I have the field 'Audit Code' and need to open on 'Non Conformity' field the same 'Audit Code' on the 'Non Conformity' table the 'Audio Code' is a N1.
- Answered
-
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
-
Formula/Script behaves differently when in Full Screen View
Hi Ninox Forum Followers, I have a formula/script as found below that behaves differently when in the full screen view. The behavior resorts back to displaying the time when the full screen is…
- Answered
-
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
Answer questions and share your knowledge