Skip to main content

Welcome to the Ninox community

Search all topics or ask a question

Alexander Koenig

Alexander_Koenig

239
0
0

Joined: Fri Apr 08 12:44:44 UTC 2016

My Posts

Latest Posts

Re: Data Field Types
Hello, use this formula on the button: create table_name table_name is the name of your table. You find more info in the NX language reference. Best regards, Alex
- Alexander_Koenig
- 8 yrs ago
- Get help
- Reported - view
Re: Function and Language Reference
Hello Min Oo, thanks for your feedback. The team minded Ninox Cloud can be accessed from all platforms via web browser. This includes Windows. app.ninoxdb.de Best regards, Alex
- Alexander_Koenig
- 8 yrs ago
- Get help
- Reported - view
Re: Function and Language Reference
Hello, add a new column and apply a formula to attribute a new date. if Time < 28800000 then Date-1 else Date where 28800000 is 07:59 in Milliseconds. Best regards, Alex
- Alexander_Koenig
- 8 yrs ago
- Get help
- Reported - view
Re: Basics
Hello, duplicating fields is not possible. But we have a feature planned to create global list for choice fields. This will allow to use global choice list in choice fields at different places.…
- Alexander_Koenig
- 8 yrs ago
- Get help
- Reported - view
Re: Formulas
Hello, with formulas you can also return text. To create a subsequent number for invoices for example, the best method id to use a trigger on table level "on create".…
- Alexander_Koenig
- 8 yrs ago
- Get help
- Reported - view
Re: Function and Language Reference
Hello Min Oo, you can apply a filter in the date2 column: =null Best regards, Alex
- Alexander_Koenig
- 8 yrs ago
- Get help
- Reported - view
Re: Data Field Types
Hi Yves, there is no way to prevent users to enter any kind of data. As a workaround you can use a formula to detect duplicates: let X := name; let Y := surname;…
- Alexander_Koenig
- 8 yrs ago
- Get help
- Reported - view
Re: Function and Language Reference
Hello Min Oo, try: year(now()) * 12 Best regards, Alex
- Alexander_Koenig
- 8 yrs ago
- Get help
- Reported - view
Re: Function and Language Reference
Hello Jack, you can use a formula to check if a record has a duplicate: let Z := Text_Field; cnt((select Table_Name where Text_Field = Z).Text_Field) Insert your table_name and Name of your…
- Alexander_Koenig
- 8 yrs ago
- Get help
- Reported - view
Re: Importing Linked Data
Hello Tom, thanks for your feedback. [Customer No] — [customers (customer number)] (update all) This is specified on the second screenshot. You have to attribute the field "customer no" from the…
- Alexander_Koenig
- 8 yrs ago
- Get help
- Reported - view
Re: Forms
Tabs are a possibility to arrange fields of a table. Each field of a table is unique. As a workaround you can add a formula field and access the image through that to display it on several tabs.…
- Alexander_Koenig
- 8 yrs ago
- Get help
- Reported - view
Re: Importing Linked Data
Hello Thomas, to import linked data a key field which is the same in both tables is required. In this example it is "customer no". This key-field needs to be present in both tables to link the…
- Alexander_Koenig
- 8 yrs ago
- Get help
- Reported - view
Re: Search
Hello, you can use the local search to only search within a specific table. You can access this search function with cmd + f or right click --> search. Best regards, Alex
- Alexander_Koenig
- 8 yrs ago
- Get help
- Reported - view
Re: Importing Linked Data
Hi Thomas, we have updated the manual with screenshots for importing linked data. Let me know if this helps. How dates are imported depend on the system settings.…
- Alexander_Koenig
- 8 yrs ago
- Get help
- Reported - view
Re: Tutorial
Hello JG, from the menu bar, there is tutorial II right below tutorial I. But here is also the link: http://manual.ninoxdb.de/en/tutorial-part-ii/ Best regards, Alex
- Alexander_Koenig
- 8 yrs ago
- Get help
- Reported - view
Re: Table References and Relations
Hello Lisa, you can attribute one contact to many locations if you create a reference from "contacts" to "location". If you like to attribute several contacts to several location, you can use a n:…
- Alexander_Koenig
- 8 yrs ago
- Get help
- Reported - view
Re: Export Data
Hi Allen, there are two export functions: From the database home screen "Export Data". This function will export everything from the table, all data fields and all entries to Excel or CSV.…
- Alexander_Koenig
- 8 yrs ago
- Get help
- Reported - view
Re: Views
Hi TGS, all features from the manual are available. Let us know if there are question. You can also drop us a line at support@ninoxdb.de Best regards, Alex
- Alexander_Koenig
- 8 yrs ago
- Get help
- Reported - view
Re: Logical Functions
Hello, Regex are not supported. But variables can be defined with let a := data_field Another thing is to use substr() and index() to extract parts of text.…
- Alexander_Koenig
- 8 yrs ago
- Get help
- Reported - view
Re: Export Data
Hello, you can use mass data to rename the images according to a field value for example. (note that changes with mass data updates are permanent) To bulk export all images,…
- Alexander_Koenig
- 8 yrs ago
- Get help
- Reported - view
Re: Formulas
Hello John, formula cannot be searched. A workaround is to use mass data updates and write the value permanently into some field in the related table. For future entries set a trigger to perform this…
- Alexander_Koenig
- 8 yrs ago
- Get help
- Reported - view
Re: Text / Date Functions
Hello, you can type in dates into the form in the table view. The formatting depends on the system settings. Go to settings and open "Speech and region". There go to advanced options and go to date.…
- Alexander_Koenig
- 8 yrs ago
- Get help
- Reported - view
Re: Data Field Types
Hi Chris, not yet. The Address needs to be selected from within the map by clicking on the needle. We have more features for the location field to be added already on the change request list.…
- Alexander_Koenig
- 8 yrs ago
- Get help
- Reported - view
Re: Table References and Relations
Hi Allen, linking data from related tables will open a dialog with the table info and a type box. Typing will apply a filter to the choices. There are also two search options:…
- Alexander_Koenig
- 8 yrs ago
- Get help
- Reported - view
Re: Function and Language Reference
Hi Allen, this works with a negative start in substr(field,-4,4). There will be also a new function length() to get the length of string coming with the next release. Best regards, Alex
- Alexander_Koenig
- 8 yrs ago
- Get help
- Reported - view

1 4 5 6 7 8 9 10

Back to top

Overview

View all topics