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: Attach file
Hi Andrea, that is not possible yet Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Function Problem: pulling in data from another table
Hi, --- let myID:=opportunityId; last((select 'Calls' where opportunityId = myID).'Next Action Date') --- Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Color Code a Formula
as a formula feld: --- html("<center>" + 'Text Field' + "</center>") --- Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Can you import Filemaker files into Ninox?
I can not confirm that. I find import function very flexible. Have you ever tried to set the date format before importing? Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Attach file
Hi Andrea, https://www.dropbox.com/s/a13p3b9w69dgoen/Andrea-2.ninox?dl=0 'Fattura N.' must not be empty. And if the file already contains a file with the same name, the file will not be created. Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Attach file
Hi Andrea, It has to work . What is 'Fattura N.'? A text or a number? Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Attach file
Hi Andrea, --- importFile(this, printAndSaveRecord(this, "Allegato Ordine"), 'Fattura N.'+".pdf") --- Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Button functions
Hi Su, --- let thisNUM := number(Id);let myNUM := min((select 'Your Table')[number(Id) > thisNUM].number(Id));openRecord(record('Your Table',myNUM)) --- Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Reset after anniversary
Without a data model, I can not understand who you need the formula. Ninox does not have its own time management. The test must be controlled manually with the Button.…
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Reset after anniversary
Without a data model, I can not understand who you need the formula. Ninox does not have its own time management. The test must be controlled manually with the Button.…
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Reset after anniversary
I do not really understand your question Date2:=date(year(Date1)+5,month(Date1),day(Date1)) Date2:=date(year(Date1)+6,month(Date1),day(Date1)) Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Come si aggiungono le righe nel modello fattura? Devo fare fattura di vendita di molteplici prodotti, il programma calcola tutto ma mostra soltanto sei righe nella stampa. Come aumentarle?
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Select syntax
Hi Ludo --- let lastDATE:=max(select 'Table'.'Date Field'); 'Field to copy':=last(select 'Table' ['Date Field'= lastDATE]).'Field to copy'; --- Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: dialog function
Hi Andrea, Without a data model, it is difficult. Why do you have the quotation marks on 'Ordini.Prodotti'?I would try like this: --- let check := dialog("Attenzione", "confermi la cancellazione?",…
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Reset after anniversary
Hi Stephen, if you have a start date (Date1) then the date (Date2) after 1 year: --- Date2:=date(year(Date1)+1,month(Date1),day(Date1)) --- Leo
- Leonid_Semik
- 6 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
Hi, either format('date field',"dddd") or weekdayName(weekday('date field')) Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: How to sort alphanumerically
Hi Su, you should sort by the column Formula. --- let myD := number(extractx('Plot No', "\d+"));let myT := extractx('Plot No', "\D+");cnt((select Plots)[number(extractx('Plot No',…
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Filter Column Records That Have Entries?
Hi Laura, you don't have to do that. Just write your word in the filter field
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: How to sort alphanumerically
Hi, You can insert an additional column with the following formula: --- let myD := number(extractx('plot number', "\d+"));let myT := extractx('plot number', "\D+");…
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Filter Column Records That Have Entries?
I think I've read it here in forum before Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Filter Column Records That Have Entries?
Hi Mr.K. try this: --- !=null --- Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Email field
Hi Peter, That comes with the next update (August) Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Button to show fields?
Ron, try again please: https://www.dropbox.com/s/heotl2i0tkfadjl/VISIBLE.ninox?dl=0
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Button to show fields?
Hi Ron, https://www.dropbox.com/s/heotl2i0tkfadjl/VISIBLE.ninox?dl=0 Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view
Re: Iphone ou Ipad
Hi, ninoxApp() => "mac" | "ipad" | "iphone" | "web"; identifies the type of app Leo
- Leonid_Semik
- 6 yrs ago
- Get help
- Reported - view

1 2 3 4 5 9

Back to top

Ninox-Documentation

Overview

View all topics