Formula don't give anything

These Formula don't give me anything, any idea. let x := (select Documentos where Semana = 9); if Week = (select Documentos).Semana then sum(x.'Horas Ganadas Plan') end Thanks

• Answered

Need help with very simple for loop

Hey Everybody, Im a truck driver and a very novice programmer to Ninox. Im trying to setup a database to track my loads and I need help with a very simple code I can't remember from high school to…

API request limit

Hi there. Want to know if there is API requests limit?

New Record with prefilled date field

What would be the code to put in "on Create" so that when the new record is created, the Date field is automatically completed with the next date of the previous. Example.…

Look up value in table based on two other values

I'm new to Ninox and am trying to set up a database for a distillery's production records. One thing I need to accomplish is a formula that can look up a value in another table based on two inputs.…

• Answered

Selecting Multiple Records in Table View in Order to Update

I frequently need to update multiple records in the table view. How to I select multiple records in order to these the Update Multiple Records function without using the Select All Records menu item?…

Speed issue

I have some speed issues with statements like this, is the a way to work around summing another file let xTM := Termijnnummer; let xWerk := Regel; let xProj := Project; let TVT :…

Button in table x (subscription) to create a record in table y (Deliveries) and its subtable y2 (Delivery lines)

Hey so we work with a subscription formula so the products the customer gets is preset in fields in table x (max8). I want to create a button in table x where when you click it you create a record…

Repeat Appointments

I would like to know if it is possible to repeat appointments. I have several tours that occur everyday at the same time. is this possible to do on Ninox? thanks for all the help

Editing records in embedded view

Hi, small question: is it possible to edit records (like line items in an invoice) in the embedded table you get from the table relation? Or do you always have to go into the other table to edit the…

• Answered

Updating the appointment Field after inputing the date

Hi there, Ive been trying to fine a solution to automatically repeat appointments weekly. Can't seem to come up with a solution so my next best idea was to have the appointment field automatically…

Put Value Number after Formula

How can I put Value Number after these Formula The problem I have is that my field Semana change evelyn week and I need mantein the value for each week.…

Beginner's question

This is so simple and basic I'm almost embarrassed to ask. I have a recipe database one of whose fields is 'Ethnicity', with various options (Chinese, Italian, Greek, etc.).…

• Answered

Customizing database url

Good day team, Is there a way we can customize the url of our database to meet what we want? The custom url will be redirecting to the ninox url in the backend Thanks

Not equal sign

hi what is the not equal sign in ninxo? Also how to create a display only if rule with checkboxes?

COMPARAR SI HAY OTRO VALOR IGUAL EN UN CAMPO DE UNA TABLA

HOLA NO SE COMO SE HACE PARA QUE NO PUEDA ESCRIBIR EL VALOR EN UN CAMPO SI HAY OTRO IGUAL EN LA TABLA. POR EJEMPLO EL CIF DE UNA EMPRESA SI YA HAY OTRO IGUAL

PRINT need some love, please

"If it's there, it should work - otherwise, why have it at all ?" Question: How can I use make my docs look good, using Ninox? I would like to keep all my "project-stuff" in one place...…

Set Choice Value

Hello, I am creating a button to set a value of Box1 to 'Active' (id1). How do I set the choice value of clicking the button instead of: Box1 := 1 I tried: Box1 := text("Active") Box1 := "Active:…

• Answered

Note: Query values of function fields via REST API

I have uploaded two databases to the NX API Team.“REST_Master-Function-Field” and “REST_Master-Function-Field Abfrage”, which illustrate how to query the content of function fields from another…

Automatic cutting stock item when creating invoice

Hello. I would like to know if the below scenario is technically doable in Ninox. I have a table for - Invoices - Stock Invoices and Stock do both have a subtable for Line Items.…

• Answered

User Role

Why do you have to create a user before you create a role. When you send the invitation you then have to do alle the work to define the role. It should be the other way around?

Aggreggate like Excel does

Hi , i have a table with multiple headers , one of them being "Month". Usually in excel i would filter it (the month i need) and apply aggregate to the column that has the numbers that needs summed.…

Export Import File

Hi, I need to produce a file that has references to the same record but on multiple lines. It is for an import file into our web software. The file is:…

How to Reverse Linking between 2 tables ?

Hi, Is it possible to change "Link to" to "Link from" between 2 tables? I happen to have 1 only contact record on a link to sub-menu, don't need more. Is it understandable? Looking forward,…

• Answered