How to enable Javascript

Latest Posts

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
- Leonid_Semik
- 1 yr 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
- Leonid_Semik
- 2 yrs ago
- Get help
- Reported - view
Re: Befehl per Befehlsschaltfläche / Änderungen nur in ca. 50 Datensätzen leo.semik@gmail.com
- Leonid Semik
- Leonid_Semik
- 2 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
- Leonid_Semik
- 2 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
- Leonid_Semik
- 2 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
- Leonid_Semik
- 2 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
- Leonid_Semik
- 2 yrs ago
- Get help
- Reported - view
Re: Phone Number Formatting? Great!
- Leonid Semik
- Leonid_Semik
- 3 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
- Leonid_Semik
- 3 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
- Leonid_Semik
- 3 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
- Leonid_Semik
- 3 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
- Leonid_Semik
- 3 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
- Leonid_Semik
- 3 yrs ago
- Get help
- Reported - view
Re: Find the max value of a field last() Leo
- Leonid Semik
- Leonid_Semik
- 3 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
- Leonid_Semik
- 3 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
- Leonid_Semik
- 4 yrs ago
- Get help
- Reported - view
Re: Problem with date Hi Robert, ":=" - not "=" -- 'field due date' := invoiceDate + 30; -- Leo
- Leonid Semik
- Leonid_Semik
- 4 yrs ago
- Get help
- Reported - view
Re: "comments" in the code let myComment:="this is a comment" Leo
- Leonid Semik
- Leonid_Semik
- 4 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
- Leonid_Semik
- 4 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
- Leonid_Semik
- 4 yrs ago
- Get help
- Reported - view
Re: If any necesary field is blank, then... if field=null then... Leo
- Leonid Semik
- Leonid_Semik
- 4 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
- Leonid_Semik
- 4 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
- Leonid_Semik
- 4 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
- Leonid_Semik
- 4 yrs ago
- Get help
- Reported - view
Re: calculate time elapsed between two concomitant records https://ninoxdb.de/en/manual/calculations/reference-of-functions-and-language Leo
- Leonid Semik
- Leonid_Semik
- 4 yrs ago
- Get help
- Reported - view

1 2 3 4 5 9 Next

Leonid Semik

Leonid_Semik

204
0
0

Joined: 31 Aug 2016

Follow