-
Choice field and formula
Hi, I'm trying to work out the right formula to calculate my commision on my invoice. In my parent table 'Invoice', I have created a choice field called 'Com %' where I can select the % of my…
-
Lookup table
Hi. Looking for help with a lookup table. I have two tables with three fields each. Table a has a.code, a.amount and a.tax; a.code and a.amount having values already.…
-
Copy records ot a database to records of others records of another database
Hi I have a some records in a Ninox database 1 and should like add them to other records that are in a Ninox database 2. can you tell me the way to do it ?
-
Layout element - View
Dear support, we have an issue with Layout element - View. We think that added formula doesn´t work correctly. In the case of first two vendors it works properly.…
-
Round number field up to next 100?
What is the formula to round a number field up to the next 100 increment. Like 57 = 100, 223 = 300.
-
List of errors
Hi, I create a quite complex DB with 100 of tables and thousands of fields, formulas and links among tables. There is a way to obtain a list of incomplete or wrong formulas? Thanks Max
-
Calculate Sell from Margin %
Hi, This is one for the mathmaticians out there. Sell £100 Purchase Cost £50 Selling fee (i.e.Amazon) of 15% of £100 = £15 Margin = (100 - (50+15))/100 or ((sell-cost)/sell) The question is,…
-
The context view menu does not open !
Hi I am on an Ipad ProWhen I click on one of the rows of a table the context view menu which should open does not display… Can someone help me ? Thanks.
-
Formula Help Needed
What is wrong with this formula? I want the result to be 2.85 when between 50 and 100, and 0 for all else. The result I get is 2.85 all the time.
-
choices fielsd
Hello, I have created choices fields with classes, categories and subcategories that appears according to choices we make but the choices don't want to appear in the table, how should I do ?
-
Changing colours
How do you change the colours of elements on a form For example can you change text colour or make it bold? Also the default value for a chosen item on a switch is blue - can you change this?…
-
Calculate Minutes to hours
Hi everyone ! I work in cinema business and want to create a formula to convert minutes to hours. I tried many times but it wasn't a success. I want to keep both informations :…
-
Optain Bearer-Token Client-Side?
Is there a way to optain the bearer token via basic auth (or smth. similar) against an api-endpoint, like in oauth? How are you supposed to optain the bearer token client side (JS)?…
-
how to use the button
I've created a button but when I click on it I want it to record the new data and close the window and show me the table, how can I do ?
-
I can not get this global function to return useful info....am I missing something?
Hi, This is my first fucntion...so please be kind! I am calling this function in the product table: adjustPriceFromEbayUK('UK Price Ebay', "EUR", 'Postage Type (One Item)', "",…
-
Can you have a one to one relationship?
I have a table with 200 plus fileds.They are product specific values like price, descriptions, keywords, meta info, titles, all with various currencies and langauages.…
-
Please explain Many-to-Many relationships and One-to-Self relationships in Ninox!
I've been looking about everywhere, and every explanation either skips the last steps of *how* to actually build the DB in Ninox, OR says they will offer a one-size-fits-all solution,…
-
Ninox Community Group
Have you already discovered our official Ninox community group? A space for you to exchange with like-minded people about all things Ninox. Share ideas about how to build efficient solutions using…
-
How can you, in code, make a post to the record's comments when a button is pressed?
I have a button that sends an email. We had a situation where we weren't sure whether or note an email was sent for a particular record or when. I've been asked to either add an entry to the record's…
-
Fix this forum so you can post a question even if you have forgotten to log in
What a mess this is. Don't forget to log in before you try to post a new question.
-
Ho un problema nel creare un campo di testo che deve contenere i dati di testo di più campi in automatico. Faccio un esempio Ho i campi 'Ingrediente', 'Fornitore', 'data arrivo merce' e 'DDT' questi dati devono essere presenti tutti nel campo "text" che mi serve per creare un Qr code
"questo è il codice per il Qr code e funziona se io metto i dati a mano nel campo 'text', ma non riesco a generare il testo aggregato di più campi proprio nel campo 'text' if Barcode then Barcode :…
-
Devo creare un campo di testo, contenente il testo di più campi della stessa tabella e di altre, non ci riesco... mi potete aiutare? Ho provato con questo codice ma il campo non si popola di dati
(let Text := Ingrediente;void) + 'Data Arrivo Merce' + Fornitori.'Denominazione Fornitore' + 'DDT n°'
-
font size
how do you change font size in a card
-
Question on Trigger Script - automatically enrolling the students of a class when linking a course to the class
Hi everyone, New to Ninox, I want to put a very simple script that automatically registers the students from a class when a course is created in this class.…
-
Image fields are goofed up. Take a look. What is going on?
I have 4 image fields in my records. I drop an image in image field 1, it goes there, but it also replaces the image in image field 4. Oddly, the table list view is reversed. Look at my screenshot.…