Skip to main content
Forum
Privacy
Contact
How to enable Javascript
Sign Up
Log in
Welcome to the Ninox community
Search all topics or
ask a question
Learn and share
Get help
Service status
Plugins
Documentation
Setup
Databases
Automation
My account
Administration
Solutions
Webinars
Overview
Profile
Fred
Fred
San Francisco, USA
Follow
Joined
Thu Feb 06 18:42:57 UTC 2020
3900
posts
629
likes received
5
followers
Badges
Latest Posts
Re: Issue with Embedding JSON and Forcing PDF
@Alain said: I have no template. The JSON is generated on the fly by this script Just to be clear, you are trying to print a dynamic print layout? If you are then you need a template that follows…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: How to improve main menu
Without knowing your DB, it is hard to make recommendations. Did you have some things you wished the Main Menu can do?
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Calculate TWR
I don't know the TWR formula so I can't help you there, but I tested out your code with a number field with some data and the formula seems to work. I have a parent record with a 5 child records.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Link tables during import CSV
@Leo Woer I'm confused. You are not deleting any records, you are only linking the medlemmer reference field. Is there other code you are not showing me that deletes records?…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Link tables during import CSV
@Leo Woer let Xarray := select members.Medlemsnr for j in select Xarray do let myText := j.Medlemsnr; for i in (select Betalingsliste)[Medlemmsnr = myText] do i.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Link tables during import CSV
@Leo Woer Ninox lets you save the second code? In the tables members and Betalingsliste, what kind of field is Medlemsnr?
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Issue with Embedding JSON and Forcing PDF
Here is a test template and a sample output. I changed the pdfVersion to 16 and it printed out in version 1.6.
Attachments
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Issue with Embedding JSON and Forcing PDF
@Alain how about your template?
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Link tables during import CSV
I was not able to get Ninox to recognized a number in a CSV to be the record Id of a reference field. It looks like you will need to import the reference record Id into another field then use a…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Issue with Embedding JSON and Forcing PDF
@Alain can you post your template and some sample JSON code?
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Dynamic Print Layout Colour
ooops, error in my writing: The second set of { } tells Carbone which key [e1FR] to check if it is not empty [ifNEM] and if it is then use [show] the value from the success key (which sits one level…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Dynamic Print Layout Colour
Here is the documentation for color in Carbone. Here is my example. Attached is the final output. Here is a sample of the JSON: { "leagueNum": 2, "league": "Major League Show Jumping", "season": 2024,…
Attachment
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Issue with Embedding JSON and Forcing PDF
May I recommend that you remove the formatJSON() from your formula field. You only need it if you want to display the JSON data. As the documentation says,…
Fred
Fred
1 yr ago
1
Get help
Reported - view
Re: Only bulk edits?
@Cliff Veal When I tap the gear icon I see all available options.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Only bulk edits?
I can see individual records in my iPhone app (v3.14.3) and can edit individual fields in a record. Can you post a screenshot? Have you contacted Ninox directly?
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Trigger on Open....
@Leo Woer If you really want to be inspired, look at @Sotirios great Dashboard Template.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: How do you distribute changes to a database to other users
I'm assuming you are talking about the local app? The end user can add the DB to their app. Then open the new DB. Then: click on Table Menu > Import Data select Ninox from the top tabs select the old…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Changing an imagefield
To clear out an image field is a two step process: removeFile(Image); Image := null
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Display a text sequence in html format
Thinking a bit too much about this. To make things a bit easier in the future is to breakup 'Synthèse concaténée' into two parts. One would be a new formula field (preHTML) that is just the html…
Fred
Fred
1 yr ago
1
Get help
Reported - view
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
Fred
1 yr 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
Fred
1 yr 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
Fred
1 yr 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
Fred
1 yr ago
Get help
Reported - view
Re: Workspaces gone
email Ninox.
Fred
Fred
1 yr 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
Fred
1 yr ago
Get help
Reported - view
1
16
17
18
19
20
156
Ninox-Website
Overview
Learn and share
Get help
Service status
Plugins
Documentation
Setup
Installed apps
Public Cloud
Private Cloud
On-Premises
Plugins
Databases
Tables
Table relationships
Fields and elements
Pages
Views
Import and export
Modules
Printing
Templates
Use cases
Automation
Performance
Scripting
Functions
API
My account
Subscriptions
Administration
Private Cloud Administration
Manage workspaces
Manage collaborators
Access permissions
Backups and storage
Process monitor
Solutions
Ninox E-Invoice
View all topics
