Skip to main content
Forum
Privacy
Contact
How to enable Javascript
Sign Up
Log in
Welcome to the Ninox community
Search all topics or
ask a question
Learn and share
Get help
Service status
Documentation
Solutions
Setup
Databases
Automation
My account
Administration
Webinars
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
Overview
Learn and share
Get help
Service status
Documentation
Solutions
Ninox E-Invoice
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
Performance
Scripting
Functions
API
My account
Subscriptions
Administration
Manage workspaces
Manage collaborators
Access permissions
Usage overview
Process monitor
View all topics