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: Button functions
Hello Ron, i understand you very well. I'm not a programmer and at the beginning I had thousands of simple questions. Sometimes the developers could not understand these questions,…
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Button functions
Hey guys, here is the link to the reference of functions and language https://ninoxdb.de/de/manual/berechnungen/funktions-und-sprachreferenz Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Button functions
openRecord(recordId) - opens the record and jumps to the related table openRecord(record(Invoices, 1)) popupRecord(recordId) - opens the record in a popup form without switching to another table…
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: How to divide time by a number?
Hi Jonathan, You should first convert the time interval to a number --- number ('time interval'). --- The result is in milliseconds. To convert this to hours:…
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: how do you calculate the days between two dates
Can it be that one of the data fields have the type datetime? Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Multi Link
this is a link to you private dropbox. You must share the file so we can download it too. Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Tabelle kopieren
Schade, ich kann mit dir leider nicht diskutieren weil ich dein Geschäftsmodell und auch das Datenmodell nicht kenne. ich habe wirklich ein Paar Beispiele wo man Jahr für Jahr eine neue Excel Tabelle…
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Tabelle kopieren
Bevor du mit Ninox aufgibst.... ich glaube, es liegt ein Gedankenfehler vor. Ich habe schon öfters gemerkt, dass die Excel-Nutzer es versuchen die Excel Logik auf Datenbanken 1:1 zu übertragen.…
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Button to link N records
Hi Andrea, —- let myF:=_id; let myC:='customer field'; for II in select Ordini ['customer field'=myC] do II.Fatture:=myF end —— Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Monate zu Datum addieren
Hallo Chreve, habe gerade heute gepostet https://ninoxdb.de/de/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/calculation-of-dates-5b32ded615616768acd281cd?post=5b333dea15616768acd281d1&page=1 Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Calculation of dates
Trigger on update Field1: —- Field2 := date(year(Field1) + 1, month(Field1) + 6, day(Field1)) —- Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Button to Create a New Linked Record?
Hi Andrea, you can filter the records and then run the update multiple records Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Previous Value Formula?/Audit Trail
Only created date "_cd" and modifications date "_md“ Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Previous Value Formula?/Audit Trail
No, it is not possible.
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Phone Number Formatting?
In your case: —- let Area := substring(Phone, 0, 3);let Num := substring(Phone, 3, 6);let Num2 := substring(Phone, 6, 10);Phone := "(" + Area + ")" + " " + Num + "-" + Num2 —- Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Previous Value Formula?/Audit Trail
format(now(), "MM/DD/YYYY, hh:mm A")
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Previous Value Formula?/Audit Trail
'AUDIT TRAIL' := now() + " paid value changed to " + Paid +"" + 'AUDIT TRAIL' Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Previous Value Formula?/Audit Trail
You can use the Formula: 'AUDIT TRAIL':='AUDIT TRAIL'+" "+now()+" "+Paid —- the first record must be empty or 0 Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Button to Create a New Linked Record?
that is not possible yet Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Random number formula
or with duplicate check. Table name :"Invoice", text field: 'Invoice number'. Trigger on create: ---- let DD := 1;while DD < 2 do 'Invoice number' := "R285" + format(floor(random() * 1000000000),…
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Random number formula
As trigger on create: 'Invoice number':="R285"+format (floor(random ()*1000000000),"000000000") Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Random number formula
'Invoice number' as a text field. as formula for the Button: --- let CC :="0123456789"let LL := length(CC);'Invoice number' := "R285";for II from 0 to 9 do'Invoice number' :…
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Button to Create a New Linked Record?
do you use a WEB-APP?, try this: let myID := Id;let NN := (create 'Repair Notes');NN.(Repair := myID);popupRecord(record('Repair Notes',number(NN.Id))) Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Button to Create a New Linked Record?
let myID:=Id; let NN:=create 'Repair Notes'; NN.Repair:=myID; let myRN:=number(NN.Id)); popupRecord(record('Repair Notes',myRN)) Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: What's the for loop syntax?
Hi Paul, as a code in a function field f(x): --- var s := ">>";for i from 1 to 10 dos := s + "*"end;s ---- Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view

1 3 4 5 6 7 8 9

Back to top

Ninox-Documentation

Overview

View all topics