Fred's Profile | Ninox community

Badges

Latest Posts

Re: Búsqueda entre bases de datos
@Angel Del Pino Velez Sadly the public cloud does not have any Ninox built support to read data between databases. If you don't want to use any other software then you will have to build all the…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: How to remove unnecessary tabs in the Page view?
This sounds like a feature request. That area is the place they show record tab names. By default the first one is called the same as the table. Email Ninox to make the request.
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Find Latest Value from Subtable
You can use the order by command. last('Static Testing' order by 'Test Date').'Static PSI' You can use any field in 'Static Testing' to order by. If it is a number (maybe even a date,…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: select statements
@Jarno Vande Walle you are correct. I didn't see that this was not posted in the get help section.
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: select statements
@Jarno Vande Walle When you get a chance, please mark the post "answered"
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: select statements
You are correct that you should always try to limit the use of selects. If possible use the record() command or reference fields. If you are looking into a child table and only want related records…
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: Substitutions for ui.popupRecord
@RafaelYes, I was wrong. You can add back the raw(). Paul posted working code in his post. First time I've seen three dashes inside double quotes. Fun. Try: onclick = "ui.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Substitutions for ui.popupRecord
@Rafael I don't think you need both text() and raw() in the recordId variable.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: openTable issue
@Sotirios Zormpas I can confirm that popupRecord() does not open the correct tab.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: HTML and Ninox
@MZ That works. Thanks.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: openTable issue
@spinner. 7580 said: Go back to Dashboard and 'Select a View' set to 'Extra Tab' click Open Table and View results in switch to TableA, Form view and Tab TableA selected instead of 'Extra Tab':…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: How to get a specific value in another table
Since you have a variable that has the actual record Id (actualseason), you can just add a period after it then you have access to all the fields from that record. actualseason.…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Calculate opening days for a short time & CSV import problem
@Alliance Informatique Mont-Tremblant said: So right now I have two choices: 1- Create an automation that will update my existing selection field when I do my daily update 2- Create a function who…
Attachment
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Calculate opening days for a short time & CSV import problem
For your CSV duplicates are you selecting one of your fields as the Key? A field that contains data that is unique so Ninox knows which data to update or create?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Substitutions for ui.popupRecord
Ninox has responded and the deprecation was only for global variables. Which I guess is what it actually says. :)
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Keep rID information in a JSON?
@Jacques TUR sorry for the misunderstanding. Here is the JSON. [{"Name":"Contefina LVF","tID":"E","rID":979,"Atm":2,"Cl":1,"ROL":0,"JOAtm":0,"r1POAtm":0,"r3POAtm":0}, {"Name":"A TOI DE PRIM","tID":…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: HTML and Ninox
@MZ Thanks for the tip. I actually want the first two th to show (Name and Atm). The third th (AvP) should only show if lastPr != 2. It seems like the coding should work according to your sample,…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Keep rID information in a JSON?
Ok I got this to work: let tbleBody := xNewData.--- <tr onclick=ui.popupRecord('{ dID }','{ rID }')> <td>{ Name }</td> <td></td> <td></td> </tr> ---; Why it didn't before I don't know.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Ninext documentation
You have a new install process.
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: Keep rID information in a JSON?
@Jacques TUR Here is the code: let tbleHead := " <thead class='tableFixHead'> <tr> <th>Name</td> <th>" + if League = 2 then "R1Atm" else "Atm" end + "</th> " + if League !…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Keep rID information in a JSON?
@Jacques TUR sadly that didn't work either. Here is a bit more of the code: let tbleBody := xNewData.--- <tr onclick="ui.popupRecord('{ dID }','{ rID }')"> <td>{ Name }</td> <td></td> <td></td> </tr>…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: HTML and Ninox
So when you use three dashes you can access field names by using curly brackets: { }. But these don't work if you want to escape out to Ninox to run commands.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Keep rID information in a JSON?
@Fabio Thanks for bringing that up. I forgot about that Ninext changes how ui.popupRecord() works. So I tried: let xPart := unique(Results.Partners); let xNewData := xPart.{ Name: Horse.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Keep rID information in a JSON?
@Fabio Thanks for the tip. I tried raw and string but it didn't work. Ninox sees it as a string, but it needs it to be rID.
- Fred
- 1 yr ago
- Get help
- Reported - view
HTML and Ninox

So I'm trying to understand the difference between using double quotes ( " ) and --- when creating HTML code. I have the following code: let tbleHead := " <thead class='tableFixHead'> <tr>…
- Fred
- 1 yr ago
- 6replies
- 137
- Get help
- Answered
- Answered

1 19 20 21 22 23 158

Welcome to the Ninox community

Fred

Re: Búsqueda entre bases de datos

Re: How to remove unnecessary tabs in the Page view?

Re: Find Latest Value from Subtable

Re: select statements

Re: select statements

Re: select statements

Re: Substitutions for ui.popupRecord

Re: Substitutions for ui.popupRecord

Re: openTable issue

Re: HTML and Ninox

Re: openTable issue

Re: How to get a specific value in another table

Re: Calculate opening days for a short time & CSV import problem

Re: Calculate opening days for a short time & CSV import problem

Re: Substitutions for ui.popupRecord

Re: Keep rID information in a JSON?

Re: HTML and Ninox

Re: Keep rID information in a JSON?

Re: Ninext documentation

Re: Keep rID information in a JSON?

Re: Keep rID information in a JSON?

Re: HTML and Ninox

Re: Keep rID information in a JSON?

Re: Keep rID information in a JSON?

HTML and Ninox

Overview