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: Time formatting
"format" always needs datetime as argument. try this: --- format(datetime(date(2018, 4, 24), time(4.13, 0)), "hh:mm:ss") --- Regards Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: resetting the counter
Try replacing "where" with squered bracket: first formula: --- let myID := number(Id); let myMonth := yearmonth(Start); cnt(select Orders [ text('choicefield')="type a" and yearmonth(Start) = myMonth…
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: resetting the counter
Hi, first formula: --- let myID := number(Id); let myMonth := yearmonth(Start); cnt(select Orders where text('choicefield')="type a" and yearmonth(Start) = myMonth and number(Id) <= myID) --- and…
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: How to replace the comma by a break line when you print a multiple choice?
You can use this formula: join(chosen(YOURFIELD), "") Regards Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Views
You can create a thrid column as sort number. the formula: --- let TT := yourtext;let NN := yournumber;cnt((select YOURTABLE)[yourtext > TT]) + 1 + cnt((select YOURTABLE)[yourtext = TT and yournumber…
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Rich text
You can convert the multiline text into an array. The command is --- split (Multiline field, " ") --- Then you can use a loop to place all the array members in other fields.…
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Is there a way to get the response in one field to trigger a different set of options for the next field?
Hi, https://www.dropbox.com/s/vakgtot99wg54df/SPORT.ninox?dl=0 regards Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Color of formula field
if you need display from value, then: --- let AA:=(your conditions); styled(text(AA), if AA < 0 then "red" else "green" end) --- Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Color of formula field
Hi, --- let AA:=(your conditions); styled("", if AA< 0 then "red" else "green" end) --- regards Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Reference of Functions and Language
Hi Jaime, that's right, "like" in filters behaves differently than in triggers. Try this: Counting cnt(select Record[contains(Dummy, "AAR")]) Selecting records select Record[contains(Dummy, "AAR")].…
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Reference of Functions and Language
Hi John, the now () function returns the current date and time. If you only need the time, you should use the formula Time := time (now ()) Regards Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Function and Language Reference
Was ich versuchen würde: --- for i in select Tasks do for p in select FSA do let q := (create Arbeitsschritte); q.(Tasks.Nr := i.Nr); q.(FSA.Nr := p.Nr) end end --- Es wurde irgendwas an IDs geändert,…
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Text / Date Functions
Hi Andrea, https://www.dropbox.com/s/be5l10gt5yv2qyn/DURATION.ninox?dl=0 regards Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Text / Date Functions
Andrea, --- if ‘Fattura N.’ != null then styled(“Fatturato”,"","","moneybag") else if ‘Data ricezione’ != null and ‘Data invio a fornitore’ != null and ‘Data evasione fornitore’ !…
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Formulas
that's right, the calculation field is not allowed to make any data changes. You should create your formula as a trigger "after update" in the 'Data scadenza fattura' field.…
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Formulas
Hi Andrea, if today() > ‘Data scadenza fattura’ and text(‘Status fattura’) != “Pagata” then ‘Status Fattura’: = “Scaduta” end regards Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Table References and Relations
I have found that my script only works properly in the web. If you are using the app, you should write the following formula in the field ADD TAG in the Constraints: --- cnt (b.SONGS. [SONG.Id = a.…
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Reference of Functions and Language
you can write e.g. --- let Comment: = "here is a comment" --- regards Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Table References and Relations
Without the "HIDDEN TABLE" table, the field "ADD TAG" is displayed with magnifying glass and plus. And with "HIDDEN TABLE" only the magnifying glass are visible.…
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Table References and Relations
Hi hugocentrique, Here is an example of multiple tagging https://www.dropbox.com/s/rckrrg4oza9ydfj/MULTIPLE%20TAGS.ninox?dl=0 regards Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Text / Date Functions
Hi Thierry, Here is a sample database. The duration is calculated in both directions (future and past) https://www.dropbox.com/s/1fz6tdefgk0pjkn/DURATION.ninox?dl=0 regards Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Reference of Functions and Language
The popup alert function does not allow transactions after clicking OK. You can write a ' quasi alert ' https://www.dropbox.com/s/hztqiuo8lrg19x2/Deleting.ninox?dl=0 regards Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Text / Date Functions
leo.semik@gmail.com
- Leonid_Semik
- 7 yrs ago
- Get help
- Reported - view
Re: Text / Date Functions
I do not understand. If you have three fields: 1. 'last contacted' (date) 2. 'callback in' (choice) 3. 'Next Contact' (f (x) with your formula) Then everything should work.
- Leonid_Semik
- 7 yrs ago
- Get help
- Reported - view
Re: Text / Date Functions
I don't understand that. Which data fields do you mean?
- Leonid_Semik
- 7 yrs ago
- Get help
- Reported - view

1 3 4 5 6 7 8 9

Back to top

Ninox-Documentation

Overview

View all topics