Skip to main content
Ninox-Website
Ninox-Documentation
How to enable Javascript
Sign Up
Log in
Learn & Share
Get help
Webinars
All topics
Contact
Privacy
Overview
Profile
Leonid Semik
Leonid_Semik
205
0
0
Joined: 31 Aug 2016
Follow
My Posts
Latest Posts
Re: create a new record in subtable
@SR try this: let myId:=_id
Leonid Semik
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
Leonid_Semik
2 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
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
Leonid_Semik
4 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
4 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
4 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
4 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
4 yrs ago
Get help
Reported - view
Re: Phone Number Formatting?
Great!
Leonid Semik
Leonid_Semik
4 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
4 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
4 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
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
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
Leonid_Semik
5 yrs ago
Get help
Reported - view
Re: Find the max value of a field
last() Leo
Leonid Semik
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
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
Leonid_Semik
6 yrs ago
Get help
Reported - view
Re: Problem with date
Hi Robert, ":=" - not "=" -- 'field due date' := invoiceDate + 30; -- Leo
Leonid Semik
Leonid_Semik
6 yrs ago
Get help
Reported - view
Re: "comments" in the code
let myComment:="this is a comment" Leo
Leonid Semik
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
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
Leonid_Semik
6 yrs ago
Get help
Reported - view
Re: If any necesary field is blank, then...
if field=null then... Leo
Leonid Semik
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
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
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
Leonid_Semik
6 yrs ago
Get help
Reported - view
1
2
3
4
5
9
Ninox-Website
Ninox-Documentation
Overview
Learn & Share
Get help
Webinars
View all topics