Skip to main content
Ninox-Website
Ninox-Documentation
How to enable Javascript
Sign Up
Log in
Learn and share
Get help
Webinars
Service status
Documentation
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
8 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
8 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
8 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
8 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
8 yrs ago
Get help
Reported - view
1
3
4
5
6
7
8
9
Ninox-Website
Ninox-Documentation
Overview
Learn and share
Get help
Webinars
Service status
Documentation
Setup
Installed apps
Public Cloud
Private Cloud
On-Premises
Databases
Tables
Table relationships
Fields and elements
Pages
Views
Import and export
Modules
Printing
Templates
Use cases
Automation
Scripting
Functions
API
My account
Subscriptions
Administration
Manage workspaces
Manage collaborators
Access permissions
Usage overview
Process monitor
View all topics