Ninox Profile

Technical Help / Show date when # turns < than #

I have a formula that turns yellow when stock is low, and red when we need to re-order. I'd like to show the date that happens as we don't always see it as soon as it happens. Is this possible? The current formula: let AA := sum('Seamless QTY on Hand (Bags)') + sum('HELP QTY on Hand (Bags)') + sum('Mt Waverley QTY on Hand (Bags)');styled(text(AA), if AA < sum('Re-Order Level (bags)') then"red"else

M

Technical Help / Unexpected continued closure, ipados 13.2.3 ninox ver. 2.6.3

Same problem, again thanks

Ninox Profile

Technical Help / Unexpected continued closure, ipados 13.2.3 ninox ver. 2.6.3

Hi Jörg It's still crashing for me (using 2.6.4 and an iPad 12.9 in Split Screen) Thanks Al

Ninox Profile

Technical Help / Pivot table cration

Hi, You need to put the x and y axis in the first to places of the list of fields and in the third place the aggregation of the x field. That would be a good question for our webinar and it would be nice if you could bring it up there.Thank you. At our Ninox webinar tips and tricks will be presented in the first 30 minutes, the remaining 90 minutes will be used for a live support where the partici

2

Technical Help / Formulaire

Bonjour, J'aimerai créer un formulaire contenant une base des données des candidats. Et dans ce formulaire, j'aimerai avoir la possibilité par exemple, de chercher une danseuse qui ne parle qu'allemand. Est-cela est possinle?, je n'yrrive pas. Je vous remercie de votre aide

J

Use cases / Reviewing duplicates in one field

Fantastic! That works perfectly. Thank you very much Steven for your help. Best, Julie

Ninox Profile

Technical Help / Módulos

Hola! Puedo seguir manteniendo dos módulos distintos con sus tablas o tengo que tener un módulo y dentro del mismo dos tablas? Se pueden relacionar tablas de módulos distintos o NO? GRacias

Ninox Profile

Technical Help / function valid for one time

I use an item price table that has a date range. Then a function that looks up the price based on a date (Sale Date for example)... Then I have a button on the item price to "Add New Price" .. which closes the existing range and opens another... Once an Item Price has a sale.. the price field is read only.. Only way to get a "new price" is to add a new range with a price.

Ninox Profile

Technical Help / Módulos

Hola Laura, a mi modo de ver tienes que separar el tipo de datos primero, no mezclar en la misma tabla de la db CLIENTES con los SERVICIOS a FACTURAR. Yo crearía tres tablas independientes y las vincularía posteriormente con las relación entre tablas que permite Ninox 1 a todos y todos a 1. De esa forma Cada cliente tendría sus facturas con los servicios a facturar. Lo que debes es pensar cada tab

A

Technical Help / Create subrecord automaticaly

Thank you for sharing, Steven! I'm examining the code now! Big thanks!!!

Ninox Profile

Technical Help / function valid for one time

Best way to do this is with a button. Not with a formula field. Let's say you have 3 numeric fields A,B and C. The button formula would be for example C:= A * B So only when you click on the button, the field C will be updated. If this doesn't help you then give me some more details of your tables,relations and fields, i'll get back to you then. Steven

Ninox Profile

Use cases / Reviewing duplicates in one field

You can put this in the 'Trigger after update' of your Identification field : let p := Identification;if cnt(select laye where Identification = p) = 2 then Identification := null; alert("Identification already in use")end Steven

Ninox Profile

Technical Help / function valid for one time

No help ?

Ninox Profile

Technical Help / Create subrecord automaticaly

Here's an example. https://www.dropbox.com/s/zzcnjjxaongb8rb/Appointments.ninox?dl=0 Steven.

J

Use cases / Reviewing duplicates in one field

Hello, I am a brand new Ninox user and in the phase of creating a database. I would like to make sure that in a table called 'laye' one of my fields called 'Identification', which is a text field, does not contain any duplicates. How can I do so? Many thanks in advance for your help.

Ninox Profile

Use cases / Feedback desired on database template

Cool! Thanks Birger! :-)

Ninox Profile

Technical Help / print button

Hi, Yes, please use the following formula to print the current record: printRecord(record(tableName, recID), "My layout name") Best, Jörg

Ninox Profile

Technical Help / Unexpected continued closure, ipados 13.2.3 ninox ver. 2.6.3

Please update to the latest version 2.6.4 and try again. Thank you, Jörg

B

Technical Help / how to implement chart in table by "adding layout field - chart"

sorry, "adding layout element" -> "chart"

B

Technical Help / how to implement chart in table by "adding layout field - chart"

Hello, I am trying to a chart in a table using "adding layout field -> chart" but it does not work. I am doing a mistake with the formula to define columns, some one che help me? Thanks a lot Barbara