Skip to main content

Ninox-Documentation

Leonid Semik

Leonid_Semik

205
0
0

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

My Posts

Latest Posts

Re: Text / Date Functions
Hello Jeni, either 'Last contacted' + (30 * number (text ('Callback in')) or with calendar months date (year ('Last contacted'), month ('Last contacted') + number (text ('Callback in')),…
- Leonid_Semik
- 7 yrs ago
- Get help
- Reported - view
Re: Reference of Functions and Language
Hi Jeni, if 'Accepted' != null then ........ regards Leo
- Leonid_Semik
- 7 yrs ago
- Get help
- Reported - view
Re: Reference of Functions and Language
Hi Adriaan, You must first declare the ID of the record as a variable. let myID:=Id; let newTask:=create task; newTask.proposal:=myID Regards Leo
- Leonid_Semik
- 7 yrs ago
- Get help
- Reported - view
Re: Data Field Types
It is very difficult to describe as text. I have created a test database for you. https://www.dropbox.com/s/dz82xtnmhqiwtrv/STUDENT.ninox?dl=0 There is an additional table "RESULTS" with links to…
- Leonid_Semik
- 7 yrs ago
- Get help
- Reported - view
Re: Data Field Types
Hi, you can write a trigger on create by Table A let AN := Id; for II in range(0, 2) do let BB := (create B); BB.(A := AN); (let BN := BB.Id; for JJ in range(0, 2) do let CC := (create C); CC.…
- Leonid_Semik
- 7 yrs ago
- Get help
- Reported - view
Re: Logical Functions
Hi, you can insert a formula field: substr('multiline field', 0, index('multiline field', " ")) Click Enter between quotation marks regards Leo
- Leonid_Semik
- 7 yrs ago
- Get help
- Reported - view
Re: Data Field Types
Hi qgoforth, You can also use the following formula: "AG" + lpad(text(Id), 5, "0") regards Leo
- Leonid_Semik
- 7 yrs ago
- Get help
- Reported - view
Re: Reference of Functions and Language
Hi Viktor, try this: let MyCC := ‘Customer code’; first(select 'Customers' where 'Customer code'=MyCC).'Customer name' Simple characters (a, b, c ...) sometimes use Ninox as system variables.…
- Leonid_Semik
- 7 yrs ago
- Get help
- Reported - view
Re: Views: Filtering Values
Hi Robert, Insert a new column with formula(x): if Date = today() then "Today" else format(Date, "YYYY-MM-DD") Insert a filter in this column: Today regards Leo
- Leonid_Semik
- 7 yrs ago
- Get help
- Reported - view
Re: Text / Date Functions
Hi Martin, try this: https://www.dropbox.com/s/d4kgfhvgfpaai1k/All_Day_Appointments.ninox?dl=0 regards Leo
- Leonid_Semik
- 7 yrs ago
- Get help
- Reported - view
Re: Triggers
Hi, In the first line you must write "if (Checkbox = true) " Not "if (Checkbox := true) " Regards Leo
- Leonid_Semik
- 7 yrs ago
- Get help
- Reported - view
Re: Reference of Functions and Language
Hi Gordon, you can try also: delete select Addresses where Email = null Leo
- Leonid_Semik
- 7 yrs ago
- Get help
- Reported - view
Re: Reference of Functions and Language
This is correct, the formula can not modify any data other fields. You must set Update Multiple Records to the FDICNameID field, and the code would be: - The Code - FnameEnd: = index (name, " ");…
- Leonid_Semik
- 7 yrs ago
- Get help
- Reported - view
Re: Table References and Relations
Hi Steven, Here is a video https://www.youtube.com/watch?v=6YOtUFE1dEA regards Leo
- Leonid_Semik
- 7 yrs ago
- Get help
- Reported - view
Re: Reference of Functions and Language
Hi Rudi, try the formula field with this code let myId := Id; 'Drilled depth' - max((select 'my table' where Id < myId).'Drilled depth') Regards Leo
- Leonid_Semik
- 7 yrs ago
- Get help
- Reported - view
Re: Text / Date Functions
Oh, sorry! Here is a sample database: https://www.dropbox.com/s/gz427ktqi5mip8e/Age.ninox?dl=0 regards Leo
- Leonid_Semik
- 7 yrs ago
- Get help
- Reported - view
Re: Text / Date Functions
Hi Si, age(Birthday) regards Leo
- Leonid_Semik
- 7 yrs ago
- Get help
- Reported - view
Re: Reference of Functions and Language
Hi jef, 'Given Name' + ” ” + 'Family Name' + (if aka = null then "" else " (" + aka + ")") Regards Leo
- Leonid_Semik
- 7 yrs ago
- Get help
- Reported - view
Re: Reference of Functions and Language
Hallo Philipp, du hast diese Frage schon mal im deutschsprachigen Teil des Blogs gestellt. dort habe ich auch geantwortet. Ich vermute, du hast deine Frage nicht mehr gefunden.…
- Leonid_Semik
- 7 yrs ago
- Get help
- Reported - view
Re: Function and Language Reference
Hallo thinsch, versuch mal die Anführungszeichen bei Marker01 weg zu lassen. Wo liegt die Formel? als Trigger bei Marker01 oder woanders? Grüße Leo
- Leonid_Semik
- 7 yrs ago
- Get help
- Reported - view
Re: Printing
I'm afraid that does not work
- Leonid_Semik
- 8 yrs ago
- Get help
- Reported - view
Re: Printing
20 times the same record or 20 records per page? Leo
- Leonid_Semik
- 8 yrs ago
- Get help
- Reported - view
Re: Formulas
Comic, Wordpress cuts my formula
- Leonid_Semik
- 8 yrs ago
- Get help
- Reported - view
Re: Formulas
Oops ‘color box’ := if year >= 2000 and year = 2006 and year <= 2010 then "rgb(0,63,255)" else "black"
- Leonid_Semik
- 8 yrs ago
- Get help
- Reported - view
Re: Formulas
Hello Jon, bei "year" trigger after update 'color box':=if year >=2000 and year=2006 and year<=2005 then"rgb(0,63,255)" else "black" You can find the RGB codes by inserting a formula field text…
- Leonid_Semik
- 8 yrs ago
- Get help
- Reported - view

1 3 4 5 6 7 8 9

Back to top

Ninox-Documentation

Overview

View all topics