-
Find Highest Letter (a being the lowest) from table
Hi, I have a product code ABC followed by a single letter a,b,c. A product can be: ABCa ABCb ABCc If there is a 'b; ending there must be an 'a' as well etc.…
-
Option tab in the calendar view
The option tab in the clendar view in OSX does not open. A spinning weel appears for a fraction of a second and then disapear. I tried logging out and back in icloud but it has no effect.
-
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…
-
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.…
Answer questions and share your knowledge