Andy

NIOXUS

Joined: Tue Feb 20 21:31:43 UTC 2018

https://www.nioxus.com

My Posts

Latest Posts

Re: createXLSX: format column as currency
The only thing you need to do to have your dates come out correctly is to use the text() tag inside your JSON code to ensure that the date content is rendered as text in Excel Regarding the…
- NIOXUS
- 11 mths ago
- Learn and share
- Reported - view
Re: createXLSX: format column as currency
Check out the new exportXLSX training videos on YouTube. At the end of part IV we talk about formatting currency.
- NIOXUS
- 11 mths ago
- Learn and share
- Reported - view
exportXLSX Training Videos

Four-part training class demonstrating how to use the new exportXLSX command now available. Part 1 - Simple Export Part 2 - Compound Export Part 3 - Formatted Export Part 4 - Export Engine
- NIOXUS
- updated 11 mths ago
- 54
- 4
- Learn and share
Re: Documentation.
Yes Kim - we work very hard to keep it complete and no, it is not simply the NINOX manual organized in another way. Commands - YES. Keywords - YES. Functions - YES. Statements - YES.…
- NIOXUS
- 5 yrs ago
- Learn and share
- Reported - view
Re: Documentation.
- NIOXUS
- 5 yrs ago
- Learn and share
- Reported - view
Re: Documentation.
Kim - Our Programming in Ninox section of the User's Manual is complete documentation of the Ninox NX Language
- NIOXUS
- 5 yrs ago
- Learn and share
- Reported - view
Re: Documentation.
Kim - we have written a detail, indexed Ninox User's Manual with hundreds of illustrations and explainations of the Ninox system and its use. It's free for all of our members at www.nioxus.com.…
- NIOXUS
- 5 yrs ago
- Learn and share
- Reported - view
Re: Application DMS Document management system with Ninoxdb
Robert - check out the new Document Management System for Ninox databases at www.ULTIMATEDATASOLUTION.COM.
- NIOXUS
- 5 yrs ago
- Get help
- Reported - view
Re: How I can prevent duplicate records being added?
Hi Wolfgang - We are going to be going over this very topic in our Ninox Learning Lab at 12:00 Noon EST. You can register for the FREE event here >>> https://www.nioxus.…
- NIOXUS
- 5 yrs ago
- Get help
- Reported - view
Re: How do I make a multiple choice box dependent on the value of a specific field?
There are two ways to accomplish what you are trying to do. The first option is a construct called Cascades; In this case, cascading Choice fields. You create and populate with choices all of the…
- NIOXUS
- 6 yrs ago
- Get help
- Reported - view
Re: Make a formula field concider code as plain text
Joelle - when you are entering content in the formula editor, you can enter comments by enclosing the text in quotation marks. This is a formula >>> let x := 2. This is a comment >>> "let x := 2".
- NIOXUS
- 6 yrs ago
- Get help
- Reported - view
Re: How to show AND link a 'last' field
Bilderblitzberlin - we have a Job/Project/Workflow Management Application that may be the solution for which you are looking. If you like, go to WWW.NINOXUS.…
- NIOXUS
- 6 yrs ago
- Get help
- Reported - view
Re: Can i change what is displayed in the Calendar?
Chcik out our training video - Working with Date & Time Fields and the Ninox Calendar at our YouTube Learning channel - Ninox Learning. Here is the link to the video that should give you some insight…
- NIOXUS
- 6 yrs ago
- Get help
- Reported - view
Re: Auto Numbering Issue
Thanks Mike.
- NIOXUS
- 6 yrs ago
- Get help
- Reported - view
Re: Auto Numbering Issue
Rushhenry - the easiest way to do this would be to use an If/Then structure to test whether or not next next record is a continuation of the current series or is it the first record in a new series.…
- NIOXUS
- 6 yrs ago
- Get help
- Reported - view
Re: Linking tables
Glad it workd Thos. Make sure to check out www.ninoxus.com for more Ninox tools, tips and templates.
- NIOXUS
- 6 yrs ago
- Get help
- Reported - view
Re: Print table for only some of the files
Louis - To print a sub-set of all of the records in a table, you need to embed a multi-record layout in the print format itself. Once that has been done,…
- NIOXUS
- 6 yrs ago
- Get help
- Reported - view
Re: Linking tables
Thosbryan - the data model you want to build will contain three tables - two parents and a child. The Parent (or Master) tables are Clinics and Caretakers.…
- NIOXUS
- 6 yrs ago
- Get help
- Reported - view
Re: Formula for age calculation
In that case Pierre you need to turn that year into a date using the date(YYYY,MM,DD) function. So say for example you want to calculate age from the first day of Year (####),…
- NIOXUS
- 6 yrs ago
- Get help
- Reported - view
Re: Formula for age calculation
Pierre - what, exactly, appears in the field 'TheBirthField'. If it is a date, then year(Field) will extract the year component of that date and age(Year) will calculate the number of years between…
- NIOXUS
- 6 yrs ago
- Get help
- Reported - view
Re: Formula for age calculation
Pierrre - You can calculate the age using the formula age(year(The BirthField))
- NIOXUS
- 6 yrs ago
- Get help
- Reported - view
Re: can appointments appear in the same calendar from different databases?
Theoretically yes Mark. Since it's possible to "connect" multiple, separate database applications, you should be able to view date-sensitive data from multiple apps on a single calendar.…
- NIOXUS
- 6 yrs ago
- Get help
- Reported - view
Re: Setting up a formula field across records in a single table
OK - Having now re-read your question, you are correct in that my original answer will not suffice. What you are going to have to do is create a Parent/Child relationship between two tables.…
- NIOXUS
- 6 yrs ago
- Get help
- Reported - view
Re: Is there any way to use icons as label in tabs, instead og text?
Kulejani - copy an emoji image (this is a good site to source emojis >>> https://getemoji.com/ >>> and paste the emoji into the name field for the Tab in the table structure.
- NIOXUS
- 6 yrs ago
- Get help
- Reported - view
Re: Formula for age calculation
Pierre - The code for your "heaven on earth" solution is as follows: let a := age('Date Field') if ('The Birth Field' != null and 'The Birth Field' != 1000 and 'The Birth Field !…
- NIOXUS
- 6 yrs ago
- Get help
- Reported - view

1 2

Welcome to the Ninox community

Andy

My Posts

Re: createXLSX: format column as currency

Re: createXLSX: format column as currency

Re: Documentation.

Re: Documentation.

Re: Documentation.

Re: Documentation.

Re: Application DMS Document management system with Ninoxdb

Re: How I can prevent duplicate records being added?

Re: How do I make a multiple choice box dependent on the value of a specific field?

Re: Make a formula field concider code as plain text

Re: How to show AND link a 'last' field

Re: Can i change what is displayed in the Calendar?

Re: Auto Numbering Issue

Re: Auto Numbering Issue

Re: Linking tables

Re: Print table for only some of the files

Re: Linking tables

Re: Formula for age calculation

Re: Formula for age calculation

Re: Formula for age calculation

Re: can appointments appear in the same calendar from different databases?

Re: Setting up a formula field across records in a single table

Re: Is there any way to use icons as label in tabs, instead og text?

Re: Formula for age calculation

Overview