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
3920
posts
633
likes received
5
followers
Badges
Latest Posts
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
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
Fred
1 yr ago
Get help
Reported - view
Re: Trigger on Open....
@Leo Woer Have you tried a print layout name without spaces?
Fred
Fred
1 yr 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
Fred
1 yr 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
Fred
1 yr 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
Fred
1 yr ago
Get help
Reported - view
1
17
18
19
20
21
157
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
Manage workspaces
Manage collaborators
Access permissions
Backups and storage
Process monitor
Solutions
Ninox E-Invoice
View all topics
