Fred

San Francisco, USA

3614
569
5

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

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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 4 mths ago
- Get help
- Reported - view
Re: Issue with Embedding JSON and Forcing PDF
@Alain how about your template?
- 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
- 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
- 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
- 4 mths ago
- Get help
- Reported - view

1 4 5 6 7 8 145

Welcome to the Ninox community

Fred

My Posts

Re: How to Track Client Changes in Ninox (Audit Log Table)

Re: How to Track Client Changes in Ninox (Audit Log Table)

Re: openTable issue

Re: How to Track Client Changes in Ninox (Audit Log Table)

Re: alert, dialog, notify - ich brauche Bio Intelligenz

Re: Link tables during import CSV

Re: Link tables during import CSV

Re: Formula for Hire Management

Re: Issue with Embedding JSON and Forcing PDF

Re: Link tables during import CSV

Re: Triggering record edition, creation or deletion from a HTML formula field

Re: Triggering record edition, creation or deletion from a HTML formula field

Re: Issue with Embedding JSON and Forcing PDF

Re: Sidebar display

Re: Issue with Embedding JSON and Forcing PDF

Re: How to improve main menu

Re: Calculate TWR

Re: Link tables during import CSV

Re: Link tables during import CSV

Re: Link tables during import CSV

Re: Issue with Embedding JSON and Forcing PDF

Re: Issue with Embedding JSON and Forcing PDF

Re: Link tables during import CSV

Re: Issue with Embedding JSON and Forcing PDF

Re: Dynamic Print Layout Colour

Overview