Very simple excel formula not translating across to Ninox... what am i doing wrong?

Hello All I need to calculate the trade price of an item based on the shop margin. In excel i use the formula: RRP * (100% - shop margin) But i can't seem to replicate this in Ninox.…

• Answered

Reorder tables?

Is there any way to reorder tables? They are added to the end on the right. I would like to be able to drag and drop them, but I do that unless I'm missing something.

Need to show only the Deliverables that will be issue in the next 7 Days.

Need to show only the Deliverables that will be issue in the next 7 Days, from the DataDate. I need the script that give me information, the information must be taken from the dates FechaP1 to Fecha…

• Answered

Upload a single file with POST API

Hi all, Can please someone help me with the following API call within Ninox? What am I doing wrong? I am trying to upload a document in a record and I call this http request from a record with a…

Button to make record

Еhere is a table where all clients are written, and in this table there are several more sub tables. We created a button separately from all tables through it we make entries in all tables.…

• Answered

Pretty star rating field?

Any suggestions for making a pretty star rating field? Here's what I've got and I don't like it much: If you've done something better looking (or even different) please share. Thanks!

How do I do a text calculation (e.g., First Name & " " & Last Name)

How do I do a text calculation (e.g., First Name & " " & Last Name)? So, if the contact's first name is "John" and his last name is "Doe", I want to create a Full Name calculation that yields the…

multiple languages

Hi everybody, Is there an easy way to crearte tables in multiple languages ? I have a company in diferent countries, where they speak different languages.…

Formula Help Needed

How do I write the formula to display only if "Field" is not like x, w, or z? This is what I have so far but it does not work.

View not showing top line on update

I have a view in my form that's tied to the choice a user makes for Client (a --> linked table). When the user picks a new Client, the view (of their Pets) updates but many times (most times) the top…

Sending Emails using the Email Field Type

I am having untold problems sending an email using the standard Ninox email field type. Apart from a bunch of other issues I cannot for the life of me figure out why some email addresses allow me to…

Create records after checks on three fields

Hi! I have three tables Tab2 is a fixed table with the following fields: Text Tab2: text field Choice1 - 2: choice field between two options Colour: dynamic choice field Name:…

• Answered

Extract certain variable numbers from attached file title

Hello everybody, I'm working on an archive of graphics files. I've imported preview graphics as images and extracted the title with this formula: extractx(text(Preview), "(.+)\/(.…

How to get accurate average numbers?

Hi, we have three shops and in each shop at the end of day we calculate avg price per item and avg purchase per customer. How do I set it up so lets say if i select data for a whole month it shows me…

Hi all; where disappear "Edit" button (to change records in the table) I have only "bulk edit".

field not found - Error

Hi! where is the error? let a := Testo if a = null then let b := "zero" else let b := "molti" end; alert(b) Field not found in line 7 Thanks!

• Answered

Import into Dynamic Multiple Choice from matched records using IDs - not quite working

I'm pretty sure I'm close. I've done a lot of reading and hours messing around with this. I am importing some CSV data from another system export into my database here.…

• Answered

Using tags for searching

I have a table where the data of the zazny department is recorded. The name of the department is formed by tags, tag1 + tag2 + tag3. I want to create a table and separate fields for tags,…