Skip to main content

Ninox-Documentation

Nick

Nick

Greece

699
29
1

Joined: Wed Jan 01 00:00:00 UTC 2014

My Posts

Latest Posts

Re: DATE CREATED FIELD
From the manual: _cd - returns the creation timestamp of the current record. Doesn’t appear to work in the Mac app. _md - returns the modification timestamp of the current record.…
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Help with a formula
Thanks a lot Sean Works fine!
- Nick
- 5 yrs ago
- Get help
- Reported - view
Help with a formula

This formula produces always the Default Text (NOT SPECIFIED)... The field 'Score' is a Number field. switch number(Score) docase > 90:text("EXCELLENT")case >= 75 and <= 85:…
- Nick
- 5 yrs ago
- 2replies
- 1222
- Get help
Re: Need assistance to set fields and coding to count the number of days between two dates and display
You need two Date fields e.g. DateStart, DateEnd and a formula field with this code (for number of days between two dates): days(DateStart, DateEnd)
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Urgent please help - I'm a newbie!
In your child table create a formula field (e.g. Calendar Display) with desired names from you pafrent table. Then use this Calendar Display field in the 'Show As' box.
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Formula to pull price from matching price sheet
Good job Sarah! Thanks for sharing.
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Convert Table into sub-table
Yes you can! Let's call the existing main table: Events Create a new table, e.g.: Dates (with desired fields Date, Time etc). Now, in the Events table create a reference to Dates table and set the…
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: How would I check to see if my SKU text field is unique and that no other values SKU of that value is in the table?
@Paul Read this topic: https://ninoxdb.de/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/how-i-can-prevent-duplicate-records-being-added-5b7697059efc8227533e7d76
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: How would I check to see if my SKU text field is unique and that no other values SKU of that value is in the table?
One simple way to check for duplicates (formula field) let d := SKU; cnt((select Product where SKU = d).SKU) Where the result is 2 it's double...
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Multiple links
If I understand you correctly, read this topic for many-to-many relationships…
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Show everything in find menu
Command-L shows all records but it doesn't clear the selection.
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: how do i delete a reference between rows
Maybe your record is locked (writable if)? Or try to unlick from the other side.
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: how do i delete a reference between rows
On the iPhone tap the reference (relationship). then tap the Menu (top right, 3 dashes) and finaly tap Unlink
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: show three formula fields (with icons) together in a fourth field
Of course, in that case you don't need "styled" function. let d := today();if d >= DateStart and d <= DateEnd then"" end
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: open record
Doesn't work for me either... :-(
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: show three formula fields (with icons) together in a fourth field
@Steven is right, works with unicode characters. Search the internet for Unicode Characters then copy and paste.
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Color coding appointments
Yes you can, I have Mac app too, as @Mconnen told you... For example: code for the "Show As" box if Choice = 1 thenstyled('Calendar Display', "green", "")elsestyled('Calendar Display', "blue", "")end
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: problem with conditional function
Hi, try this let d := today();if d >= DateStart and d <= DateEnd thenstyled("", "", "bell")end
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: How can I hide a field in a form?
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: How to formulate a multiple if/then/else statement?
Try this: if ChoiceType = 1 then FormulaI_1 else if ChoiceType = 2 then FormulaI_2 else if ChoiceType = 2 then FormulaI_3 else “Not Assigned” end
- Nick
- 5 yrs ago
- 1
- Get help
- Reported - view
Re: the CSV filemaker 11 file (El capitan 10.11.6) is not recognised by Ninox for reason unknown by my iMac 2019 with Mojave OS. What can I do ?
I moved all my databases from Filemaker 14 (.fp12) to Ninox without problems. As I remember FMP 11 uses an old format (.fp7). So, try to open the exported csv files with Excel or Libreoffice Calc,…
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Greek letters not diplayed properly on PDFs
You are correct, I tried cloud version and there is a problem: Let's wait some responce from the support.
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Greek letters not diplayed properly on PDFs
I don't have this problem with Mac app. Maybe it's your browser settings?
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Filtering by date is ignored on the PDF
When I want to do something like this, I'm doing the filtering in the Print Layout screen. Clicl the table then click 'Edit Columns' and finaly enter the filters in the Date field. For the "...…
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: choice based on text entered in other field
Hi, you can use something like this in the box 'Trigger After Update': if Description like "taxi" or Description like "plane" or Description like "ship" thenYourChoiceField :…
- Nick
- 5 yrs ago
- Get help
- Reported - view

1 17 18 19 20 21 28

Back to top

Ninox-Documentation

Overview

View all topics