Leonid Semik

Leonid_Semik

Joined: Wed Aug 31 18:26:09 UTC 2016

My Posts

Latest Posts

Re: calculate time elapsed between two concomitant records
https://ninoxdb.de/en/manual/calculations/reference-of-functions-and-language Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: use if logical syntax
if text('Creado por')="ESM" then 1 else 0 end Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Datum aus Datumsfeld mit einer Anzahl an Monaten addieren
Hallo Benny, Monatlich: --- Datum2:=date(year(Datum1),month(Datum1)+1,day(Datum1)) --- Vierteljährlich: --- Datum2:=date(year(Datum1),month(Datum1)+3,day(Datum1)) --- usw. Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: calculate time elapsed between two concomitant records
You can display the time in format "00:00". Then the data is shown evenly in the column --- let myID := number(_id);let nextDateTime := first(select 'Your Table' where number(_id) > myID).…
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: calculate time elapsed between two concomitant records
Sorry, that's not possible yet. The formula really only works in form fields. Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: calculate time elapsed between two concomitant records
Hi, Tiempo is formatted as a text, and a text is aligned to left. Try this: html("<p align='right'>" + 'Text field' + "</p>") Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: calculate time elapsed between two concomitant records
let myID := number(_id);let nextDateTime := first(select 'Your Table' where number(_id) > myID).'date_time'; let myT := number(nextDateTime - 'date_time') / 1000 / 60 / 60;floor(myT) + ":…
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: calculate time elapsed between two concomitant records
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Search Bar with Button
let Main :=this; let SRC:=Search; let CRI:=create Items; CRI.Invoices:=Main; CRI.Products:=SRC; Search:=0
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: calculate time elapsed between two concomitant records
Hi, as formula field --- let myID := number(_id);let nextDateTime := first(select 'Your Table' where number(_id) > myID).'date_time';nextDateTime - 'date_time' --- Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: How to calc sum of date specific entries in one table from another
You can write a funktion as trigget at button: --- for ii in select 'fares table' do let myDate:=ii.Date; if cnt(select 'sum table' where Date=myDate)=0 then (let newSum:=create 'sum table'; newSum.…
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: How to calc sum of date specific entries in one table from another
Here is an example. If you enter a date in the Taxt Fares table, a new date is created in the Dates table and the records are linked. If the date already exists, this date is simply linked.…
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: If Statement between dates
Hi slowwagon, hi Andrew, this can also be realized with switch: --- let YS14 := date(2014, 8, 1);let YE15 := date(2015, 7, 31);let YS15 := date(2015, 8, 1);let YE16 := date(2016, 7, 31);let YS16 :…
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Control to view web page?
Oh, this formula works in the Mac App only. Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: choice list
Hallo Frank, Die Auswahlfelder bei Ninox können momentan nur manuel ausgefüllt werden. Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Control to view web page?
Hi, as a formula field: --- html("<iframe width=" + "100%" + " " + "height=" + "100%" + " " + "frameborder=" + "0" + " " + "style=" + "border:0" + " " + "src=" + 'YOUR URL FIELD' + "></iframe>") ---…
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Add 3 months to an existing date and time field
Hi, as a formula field: --- date(year(date('date and time field')), month(date('date and time field')) + 3, day(date('date and time field'))) + time('date and time field') --- if you want to change…
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Attach file
this is a bug and will (hopefully) be fixed with the next update Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: All data has duplicates
Oh, this is a formula for the german system. in your case: --- for ii in unique((select 'Your Table').'Your Field') dolet myRec := first((select 'Your Table')['Your Field' = ii].…
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: All data has duplicates
Add a Button in your table with formula: --- for ii in unique((select 'Your Table').'Your Field') dolet myRec := first((select 'Your Table')['Your Field' = ii].…
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Linked tables
@Thierry, With the new feature "View" you no longer need an additional link. Formula --- Invoices.Items --- @Nick, You can write several commands with semicolon Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Linked tables
I think he has created duplicate linking to the Customer table.It is not useful but possible Customer -> Invoices Invoices -> Items Customer -> Items Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Linked tables
Hi Thierry, you can create a trigger "on create" in Items-table: --- let myC:=Invoice.Customer; Customer:=myC --- Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Use of a variable following a Select statement
If you use a new table for each account, then "yes" - it's a problem. I would try to keep all accounts together in one table (with a checkbox "Account name"). Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Use of a variable following a Select statement
Hi Terry,that is not possible. Ninox understands the variable "myAccount" only as text. How many accounts do you have? If there are not that many, you can use switch-case: --- let myAccount:…
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view

1 2 3 4 5 9

Welcome to the Ninox community

Leonid Semik

My Posts

Re: calculate time elapsed between two concomitant records

Re: use if logical syntax

Re: Datum aus Datumsfeld mit einer Anzahl an Monaten addieren

Re: calculate time elapsed between two concomitant records

Re: calculate time elapsed between two concomitant records

Re: calculate time elapsed between two concomitant records

Re: calculate time elapsed between two concomitant records

Re: calculate time elapsed between two concomitant records

Re: Search Bar with Button

Re: calculate time elapsed between two concomitant records

Re: How to calc sum of date specific entries in one table from another

Re: How to calc sum of date specific entries in one table from another

Re: If Statement between dates

Re: Control to view web page?

Re: choice list

Re: Control to view web page?

Re: Add 3 months to an existing date and time field

Re: Attach file

Re: All data has duplicates

Re: All data has duplicates

Re: Linked tables

Re: Linked tables

Re: Linked tables

Re: Use of a variable following a Select statement

Re: Use of a variable following a Select statement

Overview