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
Documentation
Solutions
Setup
Databases
Automation
My account
Administration
Webinars
Overview
Profile
Fred
Fred
San Francisco, USA
3614
569
5
Joined: Thu Feb 06 18:42:57 UTC 2020
Follow
My Posts
Latest Posts
Re: How to Track Client Changes in Ninox (Audit Log Table)
In the Date Entry page, there is a Check Out tab and a Check In tab. In Check Out, select a date, customer and machine then click the Check Out button. You will see the records are created in…
Fred
Fred
3 mths ago
Get help
Reported - view
Re: How to Track Client Changes in Ninox (Audit Log Table)
Here is my take on your question. I think the trick here is to track the recordID of the Activities record and the Audit record. Why? So you don't have to do a select when you need to update the…
Attachment
Fred
Fred
3 mths ago
Get help
Reported - view
Re: openTable issue
@spinner. 7580I just tried it on 3.15.4 (public cloud) and 3.15.2 (MacOS) and openRecord() worked for me. The first part of the video shows the record in Table2 with a tab called Jump.…
Fred
Fred
3 mths ago
1
Get help
Reported - view
Re: How to Track Client Changes in Ninox (Audit Log Table)
@mauro. ninox. user Can you post a sample DB with some sample data?
Fred
Fred
3 mths ago
Get help
Reported - view
Re: alert, dialog, notify - ich brauche Bio Intelligenz
There should be a semicolon ( ; ) after the end (line 13) that is right before the first alert. let empfaenger := (select Stammdaten where Name = "N.N." and eMail != null);…
Fred
Fred
3 mths ago
Get help
Reported - view
Re: Link tables during import CSV
@Leo Woer If this works for you then you don't need to upload a sample DB. I can't say right now about setting the links you want until I can see the DB.
Fred
Fred
3 mths ago
Get help
Reported - view
Re: Link tables during import CSV
@Leo Woer can you provide a sample DB? What part is not working?
Fred
Fred
3 mths ago
Get help
Reported - view
Re: Formula for Hire Management
Here is a sample DB. I took a different route. I figure you only need to see conflict when you enter in a booking. So I created a Date Entry Page that shows how this could be done.…
Attachment
Fred
Fred
3 mths ago
Get help
Reported - view
Re: Issue with Embedding JSON and Forcing PDF
@Alain I find using Carbone Studio a faster way to develop templates, especially if you are using JSON. You can see my reasons in this post.
Fred
Fred
3 mths ago
1
Get help
Reported - view
Re: Link tables during import CSV
@Leo Woer oops, try: let getAllMedlemmerRecs := select Medlemmer; for i in (select Betalingsliste) do let matchingMedlemmerRec := first(getAllMedlemmerRecs[Medlemmsnr = i.…
Fred
Fred
3 mths ago
Get help
Reported - view
Re: Triggering record edition, creation or deletion from a HTML formula field
@Javier Gómez Take a look at @Sotirios Zormpas ’ Dashboard Template. He has a pop up window that adds new records.
Fred
Fred
3 mths ago
Get help
Reported - view
Re: Triggering record edition, creation or deletion from a HTML formula field
popping up records has been covered in this forum. I've attached a sample DB of how it can be done in two ways. Here is a list of what can be done in html: database.create database.update database.…
Attachment
Fred
Fred
4 mths ago
Get help
Reported - view
Re: Issue with Embedding JSON and Forcing PDF
@Alain That is correct. Please review the Dynamic Printing section of the Documentation. The printAndSaveRecord() command uses dynamic printing so you need later for the former to work.
Fred
Fred
4 mths ago
1
Get help
Reported - view
Re: Sidebar display
Now that openFullscreen() is fixed you can use it to open a dashboard full screen on a iphone or smaller screen. Put this in the Options > Trigger after open of the DB.
Fred
Fred
4 mths ago
Get help
Reported - view
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
4 mths 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
4 mths 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
4 mths 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
4 mths 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
4 mths 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
4 mths 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
4 mths ago
Get help
Reported - view
Re: Issue with Embedding JSON and Forcing PDF
@Alain how about your template?
Fred
Fred
4 mths 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
4 mths 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
4 mths 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
4 mths ago
Get help
Reported - view
1
4
5
6
7
8
145
Ninox-Website
Overview
Learn and share
Get help
Service status
Documentation
Solutions
Ninox E-Invoice
Setup
Installed apps
Public Cloud
Private Cloud
On-Premises
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
Usage overview
Process monitor
View all topics