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?

Open a URL in a table from another table.

I have a table 'locations' in which I have a field (URL) to a OneDrive folder to display a file associated with a record (a room drawing). In a child table 'project equipment' I have a formula that…

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

Info delete Field

There are some way in Ninox to delete a info inside a field. I need to delete a range the info inside a field. For example I need to delete all Dates inside the Field Fechas.

• Answered

Changing the color of a formula field text on click of the field.

I have a formula field that gives me a date and I would like to change the color of the letters or the field to green on click. Is there way? Thank you!

Help with Scripting

Hi, I am trying to add logic to a function that I created that will flip the item status from listed to sold, donated, returned, etc. I would like to put in a safety piece that will prevent this…

• Answered

Message - Improvement

Heres a thing... As these days I work mainly from home - I have a reminder that if appropriate! sends and email to my team at the office when I log into Ninox.…

• Answered

Other formula problem

Hi again with another problem with formula. if Actividades.Disciplinas.Discilina = "Civil" then sum('Horas Ganadas Plan') = " Civil" end Don't give me anything

• Answered

Formula don't work

Hi I need to take a Date from one table and insert in other field in other tablet that is posible.? I try (select FechaCorte). DataDate O try (select FechaCorte.)' DataDate) but don't work. Thanks

• Answered

Update Email Address for Ninox

Hello, Is there a way I can update my email address in Ninox? It appears its a read-only field.

• Answered

Formula

if FechaR4 <= DataDate and FechaR4 != 0 then 'Hito 4' end I have a numeric field with that formula, that need take the info in Hito4 but don't work Some body help, aprecciate

• Answered