Fred

San Francisco, USA

3614
569
5

Joined: Thu Feb 06 18:42:57 UTC 2020

My Posts

Latest Posts

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
- 4 mths 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
- 4 mths 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
- 4 mths 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
- 4 mths 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
- 4 mths 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
- 4 mths ago
- Get help
- Reported - view
Re: Ninext documentation
You have a new install process.
- Fred
- 4 mths 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
- 4 mths 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
- 4 mths 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
- 4 mths 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
- 4 mths 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
- 4 mths 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
- 4 mths ago
- 6replies
- 96
- Get help
- Answered
- Answered
Keep rID information in a JSON?

I have created a JSON object let t := this; let xPart := unique(Results.Partners); let xNewData := xPart.{ Name: Horse.'Horse Name', rID: Horse.Id, Atm: switch t.…
- Fred
- 4 mths ago
- 11replies
- 75
- Get help
- Answered
- Answered
Re: openTable issue
@spinner. 7580 Well it works for me in public cloud. I used the code you provided and it always goes to the correct tab.
- Fred
- 4 mths ago
- Get help
- Reported - view
Re: openTable issue
Try this DB out. Open the Dashboard table You will see a choice field called 'Select a View'. So select a view. Then click on Open Table and View. Let me know what happens on your end.
Attachment
- Fred
- 4 mths ago
- Get help
- Reported - view
Re: Making a field writable based on a condition
Here is what Ninox says: After looking over the database, the cause of this is that the field using text('To Wallet') renders before the select statement is complete, meaning it isn't populated.…
- Fred
- 4 mths ago
- Get help
- Reported - view
Re: openTable issue
@spinner. 7580 I've tried it with a form view and still no issues, in public cloud.
- Fred
- 4 mths ago
- Get help
- Reported - view
Re: Substitutions for ui.popupRecord
@Jacques TUR More specific I'm asking about ui.popupRecord(). So if I'm making a HTML table I can make button that popups a record. I'm asking for other options to ui.…
- Fred
- 4 mths ago
- Get help
- Reported - view
Re: Ninox public cloud down?
@francesco.stefanello As a courtesy please do not ask non-related questions in other posts. In fact you will probably get your question answered quicker if you made a new post.…
- Fred
- 4 mths ago
- 1
- Get help
- Reported - view
Re: Ninox public cloud down?
@Sam Villano When you have a moment, please mark the post "answered".
- Fred
- 4 mths ago
- Get help
- Reported - view
Re: Búsqueda entre bases de datos
Just to be sure you are talking about different databases and not tables? if you are then are you using the private cloud version? if you are then you should look into do as database.…
- Fred
- 4 mths ago
- Get help
- Reported - view
Re: Ninox public cloud down?
I'm not having issues. Have you tried the new Restart Workspace? In the affected Workspace, click on the gear icon. then click on Process Monitor at the bottom right corner is Restart Workspace.
- Fred
- 4 mths ago
- 1
- Get help
- Reported - view
Re: openTable issue
@spinner. 7580 I just tried on Mac app v3.14.3 and was not able to duplicate. I have a button with just openTable(). I tried it using a Public Cloud DB and a local DB and both instances the button…
- Fred
- 4 mths ago
- Get help
- Reported - view
Re: openTable issue
I'm not able to reproduce it in public cloud 3.15.
- Fred
- 4 mths ago
- Get help
- Reported - view

1 7 8 9 10 11 145

Welcome to the Ninox community

Fred

My Posts

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

Keep rID information in a JSON?

Re: openTable issue

Re: openTable issue

Re: Making a field writable based on a condition

Re: openTable issue

Re: Substitutions for ui.popupRecord

Re: Ninox public cloud down?

Re: Ninox public cloud down?

Re: Búsqueda entre bases de datos

Re: Ninox public cloud down?

Re: openTable issue

Re: openTable issue

Overview