Go to a specific record

Hi! I have 4 tables: TAB1 with the respective sub-table TAB4 TAB2 with the respective sub-table TAB3 Through the links I start from the N record in TAB1,…

• Answered

How would I code/formula for a MAC address in a text field?

If I enter the following: 00107FCFD06FIs it possible to have it displayed like this: 00:10:7F:CF:D0:6F places : and force uppercase

Hiding the child table

I would like to hide the child table like 'ProjektStückliste' from the side nav. The user shall only see the child records navigating over the parent table.…

• Answered

Renaming part of title attachment

I need to assign the rename function to the button "Manuell Nr zuweisen". By clicking on it, an alert field should come out in which you are asked to enter the number you want with a blank field to…

• Answered

Bug in Ninox workdays() formula

As a member of the Ninox beta team, I am no longer sure where to report bugs. However, I did find a bug with the workdays() formula. According to https://docs.ninox.…

Relationship between "Chice" and "Formula" fields

The table has two fields, a choice "Category" and a formula field "Discount" . Depending on the client category, a discount is assigned. Can someone, please, tell me the formula, for example,…

• Answered

Choice Field

There is a table where information is entered every day, and there is a Choice field - categories. When we open a new day, it is necessary that the value of the categories is transferred to the next…

• Answered

Some little Help

let check := dialog(" ATENCION ", " ¿Confirmar la Actualizacion de los Datos en la tabla de AVANCES_PROYECTO ? ", ["Si", "No"]); if check = "Si" then for loop1 in select WeeksCutOff do Data_Date :…

Dynamic Multiple and Choice fields help

I need to set up a commission check list system for equipment and it seems to me the best way to do this is with Dynamic type choice fields. To give an example:…

Copy fields definition within a table or across tables

@Jacques TUR I am addressing this question to you, as you came with amazing and so useful solutions for Ninox : the search fields usage, or multi language implementation are so smart....…

Copy table including line items from subtable, to another table and subtable)

Hello everyone. I am trying for a few days to get this working but am stuck. Maybe someone can point me in the right direction. I have a table "Quote" and it has a subtable "quLineItems" where I add…

• Answered

Dynamic coloring of a number field

Hi folks, On a number field, I would like to highlight if the number exists already by coloring it red. I tried different approaches with functions and conditional coloring.…

• Answered

Calendar Month View - More Information?

When I look at my Appointments in the Calendar Month view, I see very little information compared to Week view. I desperately need to see a similar block of data according to the Show as settings.…

• Answered

Code Simplification - Loop ?

Hello, I am trying to simplify this code let num := number(Deduction); let rec := record('Taxes/Deductions',num); let ths := this; if rec.Calculation then ths.(Calculation := rec.…

• Answered

Multi-Choice (Dynamic) Field

Ahhh, Multi-Choice (Dynamic).... Truly a wild animal. I have a dynamic multi choice field to select multiple records in a table, staff. How do I get the Staff.…

• Answered

unknown base type undefined

I have just created a HUD toggle on/off field pair, yes/no toggle with formula to hide icons. I have created a load of them so know what to do. But this error is popping up for a new one I have…

• Answered

Create Button PDF

Hi . I have the 3 lines script on the Button (Crear PDF) my report name in Report_1 and need to view it in Emisiones (field pictures), the pdf The script don't work, some help ? Thanks

• Answered

Two fields sum

I have two fields and in the third it shows me the sum of these two fields. They must be summed if one of them is not equal to zero. Can anyone tell me the formula please

duration() format?

I'm using duration() to find the duration of an appointment. However, it always displays as h:mm. I've tried all kinds of format() and can't get it to show as just h.…

Sum of fields for a period of time

I have a table "credit_Fill" and the second table "Tables". In the Credit table there is a credit field, in which credits are recorded that are related to a particular table.…

• Answered

How to select current register within 'select' function

Hi, I need to select all records linked to XXX register in a given table . i.e.: Table named 'VEHICLES': Registration: XXX S/N: YYY etc which has a child table called 'Status' and which has some…