Skip to main content

Ninox-Documentation

Leonid Semik

Leonid_Semik

205
0
0

Joined: Wed Aug 31 18:26:09 UTC 2016

My Posts

Latest Posts

Re: how do you calculate the days between two dates
date2-date1 Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: html tag remover
YOURFIELD:=text(YOURFELD)
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Remove break lines in a text field
Yes, you can write the commands one semicolon at a time, e.g. YOURFIELD:=replace(YOURFELD," "," "); YOURFIELD:=replace(YOURFELD," "," "); YOURFIELD:=replace(YOURFELD,"ä","ae"); YOURFIELD:…
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Remove break lines in a text field
you can add a trigger after update: --- YOURFIELD:=replace(YOURFELD," "," ") --- regards Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Issues Select Where function
Hi Rodolphe. Try this: --- let NewSO := 'SO#'; cnt(select 'Sales Order' ['SO#' = NewSO]) --- Sometimes "Select where" does not work, but "select [ ]" always works Regards Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Argument help please
Hi Ray, "Yes / No" field has three options:Yes (true)No (false)Empty (null).You can configure the "after change" trigger like this: 'VALUE $':= if SOLD=true then 0 else COST regards Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Importing Image Files
I am not a developer, only a user. As far as I know, there is only one way to perform the file import. I suppose you've got it. The pictures are now in Ninox as an attachment. 1.…
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Importing Image Files
https://ninoxdb.de/en/manual/import-and-export/import-attachments Regards Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Is it possible to duplicate field options?
Hello Mark,I would take a multiple choice field. There you can click several groups per supplier. regards Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Lookup And Ninox
https://www.dropbox.com/s/0037yunobo16ilq/Shipping.ninox?dl=0 regards Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Conditional value list
Hi, it is not possible with choice fields. The choice fields can only be controlled manually. But you can realize the functionality with two linked tables. https://www.dropbox.…
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Button
Not directly, but possible https://www.dropbox.com/s/t0d4qq7ji1gepte/FILTER%20%281%29.ninox?dl=0 regards Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Email field
Hi Fabio https://ninoxdb.de/en/whatsnew Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Reading values in array
Hi, let myArray:=["a","b","c"]; let vRes:=item(myArray,1) regards Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: select
Hello Henrik --- max(select vaccination[text(Type)="influenza"].vdate) --- regards Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: calculating memberships in a sportsclub
Hello Andy, 1. in the table members group (in the subtable members), the joined aktivities are already filtered. The formula: --- concat(PARTICIPATION[PRESENCE = 1].ACTIVITIES.…
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Text / Date Functions
try this: --- 'TimeField' := time(now()) --- now() includes date and time and you have to tell Ninox exactly what you want to see Regards Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Table References and Relations
You need an extra table with n: m relationship. I have a sample database here. https://www.dropbox.com/s/caho8ua137zrwgs/SHOTS.ninox?dl=0 The shots are visible.…
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Email field
You can also use openURL command and call mailto program. https://www.dropbox.com/s/gv1i7qjg0cry0qj/EMAIL_WITH_CC_BCC.ninox?dl=0 Regards Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: calculating memberships in a sportsclub
Hello Andy, Look here: https://www.dropbox.com/s/xto1hvqyjnmyhor/SPORTCLUB.ninox?dl=0 in the CASH REGISTER you can add a Tickets. And the amount is reduced when family members participate in…
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Create new database based on existing, or clear data from database
Hi Suzie, Are you using a trial version?
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Time formatting
you can also use the today(): --- format(datetime(today(), time(4.13, 0)), "hh:mm:ss") ---
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Time formatting
exactly :-)
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Create new database based on existing, or clear data from database
Hi Sizie, 1. Save your sample database in "my Databases"2. Create an empty database3. Click on "import data"4. choose "Ninox" (top right)5. Choose your sample database6.…
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: How can I calculate age at the time of an event in years?
You can calculate the age with the following formula: --- age(DOB) --- regards Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view

1 3 4 5 6 7 8 9

Back to top

Ninox-Documentation

Overview

View all topics