Skip to main content
Ninox-Website
Ninox-Documentation
How to enable Javascript
Sign Up
Log in
Learn & Share
Get help
Webinars
All topics
Contact
Privacy
Overview
Profile
Leonid Semik
Leonid_Semik
205
0
0
Joined: Wed Aug 31 18:26:09 UTC 2016
Follow
My Posts
Latest Posts
Re: Formulas
Here the database, https://www.dropbox.com/s/8flxpumduav48yc/Serial.ninox?dl=0 Leo
Leonid Semik
Leonid_Semik
7 yrs ago
Get help
Reported - view
Re: Formulas
Hello Jon, These are the quotation marks in the first line. Please delete this and put your own quotes with Mac / iPad Leo
Leonid Semik
Leonid_Semik
7 yrs ago
Get help
Reported - view
Re: Formulas
Hi Jon, the field "Year" as f(x) formula let YY := "ABCDEFGHIJKLMNOPRSTUFH"; let XX := substr(SerialNumber, 3, 1); let ZZ := index(YY, XX); 1999 + ZZ regards Leo
Leonid Semik
Leonid_Semik
7 yrs ago
Get help
Reported - view
Re: Data Field Types
Hi, sorry, in the german version are _id to Nr. Leo
Leonid Semik
Leonid_Semik
7 yrs ago
Get help
Reported - view
Re: Data Field Types
Hello jonfusa, please try the formula let P := Nr; let A := (create ModuleID); A.(PACID := P); (let NN := number(A.Nr); popupRecord(record(ModuleID,NN))) regards Leo
Leonid Semik
Leonid_Semik
7 yrs ago
Get help
Reported - view
1
3
4
5
6
7
8
9
Ninox-Website
Ninox-Documentation
Overview
Learn & Share
Get help
Webinars
View all topics