Select using []

I have two related tables Projects and Work Reports. In the scrren shot below you can see Projects (formula) in the Projects form and below the View of the related Work Reports.…

Hours accumulated

Hi, I have a list of time records ordered by date, i.e.: - 01-jan-2022, used time 01:30 Hours - 02-jan-2022, used time 00:25 Hours - 05-jan-2022, used time 02:35 Hours. ...…

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), "(.+)\/(.…

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,…

Time format in Formula field

I need to duration from start to finish. For this I have two fields both "date+Time". To count the time and create a formula field and he thinks everything, The problem is in the display.…

NB - Account issues - renewal

My subscription is up for renewal and I cannot find out how to step up from Basic/Starter to Professional. All I seem to be able to find is to renew my current, now ended, basic subscription.…

Button to create empty field

Hello everyone, is there a way to have a button create a new field of any kind? For instance, I have a text field where I put a name. If I want to put a 2nd name for that same record,…

• Answered

Html email template

I ninox mac app i have the ability to send some text with client name etc. but can i also apply an html template to this email to avoide sending boring text email. if yes how? thanks

Sending email from other than userEmail()

I use my self developed, self owned, application under my personal email for work. When sending emails it uses my personal email which is understood. Is there anyway to have the email sent using my…

do as server vs. local - missing data?

I've got a script on a tab that I run with "do as server". When I do, it always seems to miss manipulating some data--but not all. It does run fast, though.…