ESM
-
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…
-
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"…
-
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.…
-
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:…