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 I create child records in a subtable?
As a Formula in a Button in the Table 'Student': --- let myID := Id;let myL := create Lesson;myL.Student := myID;popupRecord(record(Lesson,number(myL.Id))) ---- Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: If I have a time field 'Start Time' how would I set 'End Time' to 'Start Time' + 30 minutes?
Hi Paul, --- 'End Time' :=number( 'Start Time')+(30*60*1000) --- Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Color Cells or Text Based on Conditional
https://ninoxdb.de/en/whatsnew
- Leonid_Semik
- 6 yrs ago
- Learn and share
- Reported - view
Re: How to create a field that allows multiple choices
There are several possibilities for that. I have a sample database here. https://www.dropbox.com/s/c6mqm28ce6ktx0t/Contacts.ninox?dl=0 You can create multiple views for the Contacts table above and…
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: How to create a field that allows multiple choices
https://www.dropbox.com/s/5f2ovwghm7x0oyi/COUNTRIES.ninox?dl=0
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: How to create a field that allows multiple choices
you can not import your data into my database. The database is for example only, so you can see how your problem can be solved. Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Color Cells or Text Based on Conditional
You can use a function field f(x) for this. The Formula: styled ("Text","Background","Font colour","icon") e.g. styled("my Text", "#ddeeff", "green", "dialog") Leo
- Leonid_Semik
- 6 yrs ago
- Learn and share
- Reported - view
Re: Add Regular Expression Capability
These functions already exist: replacex(string, pattern, flags, replace) – Replaces occurances of pattern in string with replace. Pattern is a regular expression string,…
- Leonid_Semik
- 6 yrs ago
- Learn and share
- Reported - view
Re: How to create a field that allows multiple choices
You can download this file to your descktop.Then you can click on "import archive" on your web version and choice the file. Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: How to create a field that allows multiple choices
In my Database you can choice one or many categories from the table "Types". And in the table "Types", you can see which contacts belong to the category. I thought that's what you wanted. Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: How to create a field that allows multiple choices
https://www.dropbox.com/s/c6mqm28ce6ktx0t/Contacts.ninox?dl=0
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Инструкция
Да, я на мыло сейчас сброшу
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Инструкция
К сожалению, пока нет. Поэтому спрашивай, постараюсь ответить на все вопросы. Леонид
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: How to delete what must be a corrupt table?
You can click on Data Model, then on the table and then on "Delete Table" Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Days to Hours
Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Syntax to trigger removal of a link between between tables
Hi Laura, the formula to break a link: --- 'Linked field':=0 --- I do not understand your formula. What do you want to achieve with it? Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Format time
Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: trouble with formulas and dates.
you can create a f(x) formula field "Expired". The formula: --- if date(year(Date) + 1, month(Date), day(Date)) < today() thenstyled("YES", "red")elsestyled("NO", "green")end --- Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Importing Image Files
Hi Michael, Your Images are all attached?try your formula without "A7", so: if 'Tomatoe Rating' <= 59 thenImage := "Splat.jpg"elseif 'Tomatoe Rating' >= 60 and 'Tomatoe Rating' <= 79 thenImage :…
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: create a new record in subtable
Ok, then: --- let myID:='invoice table'; let newSUB:=create Subtable; newSUB.'invoice table':=myID popupRecord(record(Subtable, number(newSUB.Id))) --- Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: create a new record in subtable
Hi Robert, --- let myID:=Id; let newSUB:=create Subtable; newSUB.'invoice table':=myID popupRecord(record(Subtable, number(newSUB.Id))) --- regards Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: quatation mark in replace function
try this --- Text := replace(Text, """", "");Text := replace(Text, "<div class=longdesc smartformatted>", "") --- or this --- Text := replace(Text, "<div class=" + """" + "longdesc smartformatted>" +…
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: quatation mark in replace function
try this --- Text := replace(Text, """", "");Text := replace(Text, "<div class=longdesc smartformatted>", "") --- or this --- Text := replace(Text, "<div class=" + """" + "longdesc smartformatted>" +…
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: quatation mark in replace function
Text := replace(Text, "„", "");Text := replace(Text, "“", "");Text := replace(Text, """", "");Text := replace(Text, "«", "");Text := replace(Text, "»", "");
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Long Term Capital Gain
if number(today() - 'transaction date') > 365 * 1000 * 60 * 60 * 24 then"long"else"short"end 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