Skip to main content

Forum

Welcome to the Ninox community

Search all topics or ask a question

Badges

Latest Posts

Re: Values from previous record by date
Missed the second use of [this]: let myRec := this; let prevDate := max((Fund.Development[Date< myrec.Date] order Date)).Date; prevDate
- Fred
- 11 mths ago
- Get help
- Reported - view
Re: Values from previous record by date
You are very close. You just need to use the order statement. If you don't use an order statement then Ninox sorts by record Id. let myRec := this; let prevDate := max((Fund.Development[Date< this.…
- Fred
- 11 mths ago
- Get help
- Reported - view
Re: Does a programming tutorial exist?
The official Ninox information is in the Documentation section of the Forum. @Jacques TUR's website has some very helpful tips as well. There are plenty of videos from Ninox and Nixous in Youtube.
- Fred
- 11 mths ago
- Get help
- Reported - view
Re: Trigger on Open....
@Leo Woer If I add a switch to my code from above: let t := this; let layoutName := switch name do case "bubba": "NameSpace" end; let newChild := (create Table1a); let printVar :…
- Fred
- 11 mths ago
- Get help
- Reported - view
Re: Workspaces gone
email Ninox.
- Fred
- 11 mths ago
- Get help
- Reported - view
Re: Trigger on Open....
@Leo Woer You can also simplify the switch to: let myFilename := switch 'Hvilket Licenskort har vedkommende' do case 1: "Provisional" case 2: "A Licens IPSC" case 3: "A+ Licens IPSC" case 4:…
- Fred
- 11 mths ago
- Get help
- Reported - view
Re: Trigger on Open....
@Leo WoerThat is one solution, or you can try out@Jacques TUR solution from this post. Here is code that works for me: let t := this; let newChild := (create Table1a); let printVar :…
- Fred
- 11 mths ago
- Get help
- Reported - view
Re: Trigger on Open....
@Leo Woer Have you tried a print layout name without spaces?
- Fred
- 11 mths ago
- Get help
- Reported - view
Re: Trigger on Open....
@Leo WoerTry changing: i.(Licenskort := importFile(this, printAndSaveRecord(this, myFilename), "Licenskort.pdf")) to i.(Licenskort := importFile(t, printAndSaveRecord(this, myFilename), "Licenskort.…
- Fred
- 11 mths ago
- Get help
- Reported - view
Re: Trigger on Open....
@Leo Woer Have you tried hard coding a print layout name to test that it works?
- Fred
- 11 mths ago
- Get help
- Reported - view
Re: Trigger on Open....
@Leo Woer It cannot find the layout I have in "myFilename" I am sure that it is because I haven't properly linked the parent and the child correctly and the layout is in the parent table.…
- Fred
- 11 mths ago
- Get help
- Reported - view
Re: Trigger on Open....
@Leo Woer said: it is supposed to be hidden, as it only works as a container for the attachment I send in an email If a person can have many licenses then maybe create a child table called images or…
- Fred
- 11 mths ago
- Get help
- Reported - view
Re: How to set a default value for dynamic fields?
@Stef Please mark the post answered when you get a moment.
- Fred
- 11 mths ago
- Get help
- Reported - view
Re: Select only hosts not working on a certain date from joined table.
@James if it works then that is great.
- Fred
- 11 mths ago
- Get help
- Reported - view
Re: Display a text sequence in html format
@Sébastien GuilletYeah, I was trying to figure it out but I couldn't at the moment. But try this: let getRecs := (select Table1); let finalHTML := html(""); for rec in getRecs do finalHTML :…
- Fred
- 11 mths ago
- Get help
- Reported - view
Re: An easy? help request
@RafaelHere it is for me in Chrome in Windows: Looks like this in the Zen browser as well in Windows. Looks the same for me regardless of browser.
- Fred
- 11 mths ago
- Get help
- Reported - view
Re: An easy? help request
@Rafael this is what is looks like for me in Firefox in Windows and Mac: The same as Edge for Windows.
- Fred
- 11 mths ago
- Get help
- Reported - view
Re: How to set a default value for dynamic fields?
@Stef You can try adding at tab at the top of the Edit Fields window. Then you can edit the top Tab's Trigger before view: Does that work for you?
- Fred
- 11 mths ago
- 1
- Get help
- Reported - view
Re: An easy? help request
@skyline. verge. 8d When you get a chance please mark the post answered.
- Fred
- 11 mths ago
- Get help
- Reported - view
Re: An easy? help request
@Rafael don't know what to say. Looks like a Ninox issue as there is nothing special in there. I wrote it in public cloud. here is how it looks in Edge in Public cloud.
- Fred
- 11 mths ago
- Get help
- Reported - view
Re: Display a text sequence in html format
you can wrap the last line in html() instead of join. html(gatherData.'Synthèse concaténée')
- Fred
- 11 mths ago
- 1
- Get help
- Reported - view
Re: Trigger on Open....
@Leo Woer Maybe we can look at it from another direction. Question, why do you need this field in this table if you need to delete the contents when you open the record? What is the field used for?…
- Fred
- 11 mths ago
- Get help
- Reported - view
Re: An easy? help request
I would not recommend using dynamic choice fields to store data because of this issue. I've attached a sample DB. I use dynamic fields and buttons to update child tables that store the data.…
Attachment
- Fred
- 11 mths ago
- Get help
- Reported - view
Re: Issues with 3.15.1
Can you be more specific about the select statements? I tried this on a DB: select Orders where Date < date(2022, 7, 14) and it worked fine. I was also able to filter a column.…
- Fred
- 11 mths ago
- Get help
- Reported - view
Re: Issues with 3.15.1
Here are the release notes for 3.15.1.
- Fred
- 11 mths ago
- Get help
- Reported - view

1 14 15 16 17 18 154

Back to top

Overview

View all topics