Leonid Semik

Leonid_Semik

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

My Posts

Latest Posts

Re: create a new record in subtable
@SR try this: let myId:=_id
- Leonid_Semik
- 1 yr ago
- Get help
- Reported - view
Re: Random number formula
Hallo Maurice, verstehe ich richtig, 01 RuR ist eine Untertabelle von der Tabelle Kursjahrgang und du erstellst die Datensätze aus dem Kursjahrgang in dem du auf den Plus klickst.…
- Leonid_Semik
- 3 yrs ago
- Get help
- Reported - view
Re: Tabelle kopieren
Hallo Florian, die Methode gibt es immer noch. Aber nur für Ninox-App für Mac OS und iOS. Dafür müssen die zu kopierenden Datenbanken in dem ersten Reiter "Meine Datenbanken" liegen.…
- Leonid_Semik
- 4 yrs ago
- Get help
- Reported - view
Re: Befehl per Befehlsschaltfläche / Änderungen nur in ca. 50 Datensätzen
leo.semik@gmail.com
- Leonid_Semik
- 5 yrs ago
- Get help
- Reported - view
Re: Befehl per Befehlsschaltfläche / Änderungen nur in ca. 50 Datensätzen
Hallo Jens, so eine Ferndiagnose ist immer schwierig. Kannst du die Datenbank irgendwo posten?
- Leonid_Semik
- 5 yrs ago
- Get help
- Reported - view
Re: Befehl per Befehlsschaltfläche / Änderungen nur in ca. 50 Datensätzen
Untertabelle ist auch eine verknüpfte Tabelle. Sollte eigentlich gehen. Es kann aber sein dass es tatsächlich bei 'Vorgänger'.'Ende Plan' ein Problem entsteht.…
- Leonid_Semik
- 5 yrs ago
- Get help
- Reported - view
Re: Befehl per Befehlsschaltfläche / Änderungen nur in ca. 50 Datensätzen
Hallo Jens, Die Aufgaben sind doch als Untertabelle zu Projekten oder? Probier zuerst folgendes: --- let me := this;Projekt.Aufgaben [Nr != me.Nr and Aufgabennummer > me.Aufgabennummer].…
- Leonid_Semik
- 5 yrs ago
- Get help
- Reported - view
Re: Befehl per Befehlsschaltfläche / Änderungen nur in ca. 50 Datensätzen
Hallo Jens, wie sieht die Formel aus? Leo
- Leonid_Semik
- 5 yrs ago
- Get help
- Reported - view
Re: Phone Number Formatting?
Great!
- Leonid_Semik
- 5 yrs ago
- Get help
- Reported - view
Re: Add 3 months to an existing date and time field
ANNUAL SERVICE EXPIRY' := date(year(date('ANNUAL SERVICE EXPIRY'))+1, month(date('ANNUAL SERVICE EXPIRY')), day(date('ANNUAL SERVICE EXPIRY'))) Leo
- Leonid_Semik
- 5 yrs ago
- Get help
- Reported - view
Re: How do I express a date to a day, like Monday or Tuesday. Other than using a choice box with a dropdown list. Thank you
either format(today(),"dddd") or weekdayName(weekday(today())) Leo
- Leonid_Semik
- 5 yrs ago
- Get help
- Reported - view
Re: calculate difference between field values in current and previous record
Hi Hans, If you write the weeks as numbers (32,33,34 ...) then you can do it like this: --- let myRec := this;let lastWeek := max((select 'Your Table')[Week < myRec.Date].…
- Leonid_Semik
- 5 yrs ago
- Get help
- Reported - view
Re: It seems to be impossible to include a “View”-field in the print lay-out? Is that true?
Hi, Bas,I've made an example here. https://www.dropbox.com/s/abr4owka73t5bc1/Bas.ninox?dl=0 You can either place the texts in a subtable (subprojects) or write everything in a text field. Leo
- Leonid_Semik
- 5 yrs ago
- Get help
- Reported - view
Re: Find the max value of a field
That's right, I should have explained that before.
- Leonid_Semik
- 5 yrs ago
- Get help
- Reported - view
Re: Find the max value of a field
last() Leo
- Leonid_Semik
- 5 yrs ago
- Get help
- Reported - view
Re: is it possible to include all item in a filter?
Hi, --- let Cl := number(client.ID);if not Cl then select Achats else(select Achats)[ number(Contact.ID) = Cl and other things....]end --- Leo
- Leonid_Semik
- 5 yrs ago
- Get help
- Reported - view
Re: Problem with date
Hi Robert, This is a known problem with summertime.Try this: 'field due date' :=date(year ('invoiceDate'), month('invoiceDate'),day('invoiceDate') + 30); Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Problem with date
Hi Robert, ":=" - not "=" -- 'field due date' := invoiceDate + 30; -- Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: "comments" in the code
let myComment:="this is a comment" Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: If any necesary field is blank, then...
In this case, check all fields with "or": if field1=null or field2=null or field3=null or field4=null then ....... Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Print invoice question
that's standard at Ninox. in Layout Preview you can only see the 6 rows of a table. Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: If any necesary field is blank, then...
if field=null then... Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Multiple Choice - trigger
Hi Andrea, https://www.dropbox.com/s/jxgi8x9hnnldvpi/Checklist.ninox?dl=0 Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: calculate difference between field values in current and previous record
Hi Lieven, as a formula field: --- let myRec := this;let prevDate := max((select 'Your Table')[Date < myRec.Date].Date);if prevDate thenlet prevRec := first((select 'Your Table')[Date = prevDate]);…
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: i'd like to send an attachment with an email, can i ?
Hi, sendEmail({from: "laurentstmont@icloud.com",to: "laurentstmont@icloud.com",subject: "Hello World!",text: Text1 + 'rubrique' + Text2, html:"<b>"+Text1 + 'rubrique' + Text2+"</b>",attachments:…
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view

1 2 3 4 5 9

Welcome to the Ninox community

Leonid Semik

My Posts

Re: create a new record in subtable

Re: Random number formula

Re: Tabelle kopieren

Re: Befehl per Befehlsschaltfläche / Änderungen nur in ca. 50 Datensätzen

Re: Befehl per Befehlsschaltfläche / Änderungen nur in ca. 50 Datensätzen

Re: Befehl per Befehlsschaltfläche / Änderungen nur in ca. 50 Datensätzen

Re: Befehl per Befehlsschaltfläche / Änderungen nur in ca. 50 Datensätzen

Re: Befehl per Befehlsschaltfläche / Änderungen nur in ca. 50 Datensätzen

Re: Phone Number Formatting?

Re: Add 3 months to an existing date and time field

Re: How do I express a date to a day, like Monday or Tuesday. Other than using a choice box with a dropdown list. Thank you

Re: calculate difference between field values in current and previous record

Re: It seems to be impossible to include a “View”-field in the print lay-out? Is that true?

Re: Find the max value of a field

Re: Find the max value of a field

Re: is it possible to include all item in a filter?

Re: Problem with date

Re: Problem with date

Re: "comments" in the code

Re: If any necesary field is blank, then...

Re: Print invoice question

Re: If any necesary field is blank, then...

Re: Multiple Choice - trigger

Re: calculate difference between field values in current and previous record

Re: i'd like to send an attachment with an email, can i ?

Overview