Skip to main content

Ninox-Documentation

ESM

ESM

27
0
0

Joined: Fri Aug 25 02:41:02 UTC 2017

My Posts

Latest Posts

Re: filter records from a reference table to calculate a value to be stored on a fiend on parent table
Well after playing around I solve the above with this formula: last(Operacion[Clase = "Noche"].Horometro) - first(Operacion[Clase = "Noche"].Horometro)
- ESM
- 6 yrs ago
- Get help
- Reported - view
filter records from a reference table to calculate a value to be stored on a fiend on parent table

Hello, I have this two referenced tables, the first one called 'Registro' and a child called 'Operacion'. I need to filter on the 'Operacion' table all the "Dia" registries on the field -Clase- and…
- ESM
- 6 yrs ago
- 1reply
- 1994
- Get help
Re: filtering and summarize
Update. I did update further the formula (attached here) and now is working well; I also think I'm undestianding better how this formula works.
- ESM
- 6 yrs ago
- Get help
- Reported - view
Re: filtering and summarize
I did made some changes at the formula on the field 'Clase' (see attached) pls compare this new one from the one received above. Also did change the format on the field 'Hora' which is used to…
- ESM
- 6 yrs ago
- Get help
- Reported - view
Re: How I can prevent duplicate records being added?
Unique field is important on web app; hope Ninox will solve this soon
- ESM
- 6 yrs ago
- Get help
- Reported - view
Re: filtering and summarize
Hi, tks for the hint, but I'm doing a mess. Attached screenshot shows the field 'Clase' does not correspond to the 'Hora', seems to me the "N" and "D" are filled whitout following the formula.…
- ESM
- 6 yrs ago
- Get help
- Reported - view
Re: How I can prevent duplicate records being added?
I use the web app; seems Ninox does not support this option on web
- ESM
- 6 yrs ago
- Get help
- Reported - view
Re: How I can prevent duplicate records being added?
Hi Nick, I did include the code you sent me (attached screenshots) and I still can enter same date on the next fields of my table without any warning. Any hint?
- ESM
- 6 yrs ago
- Get help
- Reported - view
filtering and summarize

I have this database with two tables, the first one (parent table) called "Registro" and a child called "Operacion" On the "Operacion" table I need a script that fill field "Clase" with letter "D"…
- ESM
- 6 yrs ago
- 8replies
- 2668
- Get help
Re: How I can prevent duplicate records being added?
Hi, I have a table with a field date and I want to keep this unique; I tried to use the above formula but it does nothing; can u pls help me to use this formula with dates field?
- ESM
- 6 yrs ago
- Get help
- Reported - view
Re: format time in hh:mm
Noted. Tks
- ESM
- 6 yrs ago
- Get help
- Reported - view
Re: use if logical syntax
Ahh must add record type. Tks
- ESM
- 6 yrs ago
- Get help
- Reported - view
Re: calculate time elapsed between two concomitant records
Noted. Tks
- ESM
- 6 yrs ago
- Get help
- Reported - view
Re: calculate time elapsed between two concomitant records
Hi Leo, After applying your script of above, below is the result, which is ok for me so I'm moving on with this little proyect. Tks a lot for the help, the formula on this field is doing his job well.…
- ESM
- 6 yrs ago
- Get help
- Reported - view
Re: use if logical syntax
Hi, This is the formula This is the table where it goes. Obviuosly my formula is wrong, because I only receive 0 instead of 1. If u can give my a hint I would appreciate.…
- ESM
- 6 yrs ago
- Get help
- Reported - view
Re: calculate time elapsed between two concomitant records
Hi, Well where I should put the scirpt you send me before on the table?
- ESM
- 6 yrs ago
- Get help
- Reported - view
Re: calculate time elapsed between two concomitant records
Hi, Is there where it goes? But it does nothing...
- ESM
- 6 yrs ago
- Get help
- Reported - view
Re: calculate time elapsed between two concomitant records
Hi, tks again. I have to give a try to learn this scripting language. There is any document(s) regarding? By the way the funcions fields can be alligned; for exaple the field "Tiempo" to the right?
- ESM
- 6 yrs ago
- Get help
- Reported - view
Re: calculate time elapsed between two concomitant records
Hi Leo, Tks for the hint, but the formula field I want to format as hh:mm which I did named initially as "Duracion" but to avoid name confusion I renamed as "Tiempo" as far I understand only can be…
- ESM
- 6 yrs ago
- Get help
- Reported - view
Re: calculate time elapsed between two concomitant records
Hi Leo, Tks for the hint, but the formula field I want to format as hh:mm which I did named initially as "Duracion" but to avoid name confusion I renamed as "Tiempo" as far I understand only can be…
- ESM
- 6 yrs ago
- Get help
- Reported - view
use if logical syntax

Hello, I have on y calculated field this logical formula: if Usuario = "ESM" then 1 else 0 end . But it does not work, even if the field Usuario contains the text "ESM" it always give me 0.…
- ESM
- 6 yrs ago
- 4replies
- 2271
- Get help
format time in hh:mm

Hello, how can I format a field to display it in hours and minutes? I have a function field named "Duration" wich display for example: 2 days 0:28:14.358 and I want to show in hours and minutes as 48:…
- ESM
- 6 yrs ago
- 2replies
- 2049
- Get help
Re: calculate time elapsed between two concomitant records
Hi Leo, How can I format the column 'Duracion' in hh:mm only? I tried but once it gave me 7 hours added.
- ESM
- 6 yrs ago
- Get help
- Reported - view
Re: calculate time elapsed between two concomitant records
Hi Leo, How can I format the column 'Duracion' in hh:mm only? I tried but once it gave me 7 hours added.
- ESM
- 6 yrs ago
- Get help
- Reported - view
Re: calculate time elapsed between two concomitant records
Hi Leo, First at all tks a lot. I was able to make it works even if I do know 0 about Ninox scripting. Hope I can learn more and have time to time a little help.
- ESM
- 6 yrs ago
- Get help
- Reported - view

1 2

Back to top

Ninox-Documentation

Overview

View all topics