Skip to main content

Welcome to the Ninox community

Search all topics or ask a question

Frank Böhmer

Frank_Bohmer

58
0
0

Joined: Fri Apr 08 12:27:04 UTC 2016

My Posts

Latest Posts

Re: Table References and Relations
Hi elsien57, the best way would be to have tow tables: a) Person b) Weight and then create a reference from weight to Person. In the Person table you would have a field for height and in the weight…
- Frank_Bohmer
- 7 yrs ago
- Get help
- Reported - view
Re: Table References and Relations
Hi Adriaan, you can use unique: concat(unique(Values)) Best regards, Frank
- Frank_Bohmer
- 7 yrs ago
- Get help
- Reported - view
Re: Forms
Hi Steve, it's not possible with a script command. Simply press TAB to activate the first field. Best Frank
- Frank_Bohmer
- 7 yrs ago
- Get help
- Reported - view
Re: Create and Modify Tables
Hi lynnk, tables are ordered alphabetically. One work around would be using names like 1. Products, 2. Articles. Best Frank
- Frank_Bohmer
- 7 yrs ago
- Get help
- Reported - view
Re: Reference of Functions and Language
Hi Logicwar, your formula looks fine. There is no convenience function to calculate this. Best Frank
- Frank_Bohmer
- 7 yrs ago
- Get help
- Reported - view
Re: Create and Modify Tables
Hi Rob, thanks for using Ninox! Unfortunately you cannot copy fields. We plan to implement a feature to re-use choice field lists. Best regards Frank
- Frank_Bohmer
- 7 yrs ago
- Get help
- Reported - view
Re: Table References and Relations
Hi sbaloz, you'd need to set up the schema as follows: - Table Prospects - Table Contact - Table BoardMember - linked to Prospects (Composition: Yes) - linked to Contact With this schema,…
- Frank_Bohmer
- 7 yrs ago
- Get help
- Reported - view
Re: Mass Data Updates
Hi Filippo, the best way to calculate a date difference in days is: days('Due Date', today()) Best regards Frank
- Frank_Bohmer
- 7 yrs ago
- Get help
- Reported - view
Re: Templates
Hi cnorgaard, you can download the templates from http://templates.ninoxdb.de/templates.html Then, use the import archive option to install a template. Best regards Frank
- Frank_Bohmer
- 8 yrs ago
- Get help
- Reported - view
Re: Table References and Relations
Hi Christian, thanks for giving Ninox Server a try! The way the invoice template works is that it stores the price per invoice item to avoid that changing an articles price also changes invoices.…
- Frank_Bohmer
- 8 yrs ago
- Get help
- Reported - view
Re: Reference of Functions and Language
Hi Roberto, 1. You can use select with any table in your database. For linked tables, select is typically not necessary since you can directly access linked records using the field names (which is a…
- Frank_Bohmer
- 8 yrs ago
- Get help
- Reported - view
Re: Forms
Hi Tomek, one way to achieve this would be to have a separate table "Reporting" with number fields for Year and Month. Then, add formulas for your monthly reporting as you like, e.g.…
- Frank_Bohmer
- 8 yrs ago
- Get help
- Reported - view
Re: Printing
Hi mpraljak, thanks for your suggestions! I'll put that on our requirements list. Best regards Frank
- Frank_Bohmer
- 8 yrs ago
- Get help
- Reported - view
Re: Formulas
Hi Gsechi, pls. try MyField := MyField + 1 Regards, Frank
- Frank_Bohmer
- 8 yrs ago
- Get help
- Reported - view
Re: Charts
Hi Thomas, assuming you have a table for Customers with a field State: - Configure your table view as follows (Filter button top / centered): - First column State, Sort: Grouped - Second colum Id,…
- Frank_Bohmer
- 8 yrs ago
- Get help
- Reported - view
Re: Text / Date Functions
Hi Thomas, the date format setting should be MM/dd/yy. (i.e. capital MM, lower case m refers to minutes). Regards, Frank
- Frank_Bohmer
- 8 yrs ago
- Get help
- Reported - view
Re: Forms
Hi Thomas, the new release is a bit different. We'll update the manual, soon. Sorry for that. To create new tabs: - Activate the wrench icon top right. - The form's toolbox will show up.…
- Frank_Bohmer
- 8 yrs ago
- Get help
- Reported - view
Re: Function and Language Reference
Hallo ThorsProvoni, wir haben diese Seite soeben aktualisiert, sie enthält jetzt alle neuen Funktionen. Viele Grüße, Frank
- Frank_Bohmer
- 8 yrs ago
- Get help
- Reported - view
Re: Function and Language Reference
Hi Thomas, in the visual formula editor you can simply follow the reference fields by clicking on them. When you finally hit the field you want to sum up, it will show you all possible aggregations.…
- Frank_Bohmer
- 8 yrs ago
- Get help
- Reported - view
Re: Triggers
Hi GospelTheGrey, good question! And you're right. First the field level trigger will execute, then the table level trigger. Best regards Frank
- Frank_Bohmer
- 8 yrs ago
- Get help
- Reported - view
Re: Forms
Hi klgamble, click on the active tab and then "Edit fields". You can reorder everything by drag&drop. However, moving a tab won't move tis fields so it might take some effort. Regards, Frank
- Frank_Bohmer
- 8 yrs ago
- Get help
- Reported - view
Re: Table References and Relations
Hi Gerrie, you'll find more information regarding the language at: http://manual.ninoxdb.de/en/function-and-language-reference/ Best regards, Frank
- Frank_Bohmer
- 8 yrs ago
- Get help
- Reported - view
Re: Data Field Types
Hi Ivan, we'll add this with the next release. Regards Frank
- Frank_Bohmer
- 8 yrs ago
- Get help
- Reported - view
Re: Data Field Types
Hi Ivan, Ninox doesn't support multiple chocie fields, yet. But that's planned. Best regards Frank
- Frank_Bohmer
- 8 yrs ago
- Get help
- Reported - view
Re: Table References and Relations
Hi Allen, it might work a bit different than in your previously used database software, but I think a simple table reference will do the job (at least for the example you stated):…
- Frank_Bohmer
- 8 yrs ago
- Get help
- Reported - view

1 2 3

Back to top

Overview

View all topics