Fred

San Francisco, USA

3522
550
4

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

My Posts

Latest Posts

Re: Problème de plantage sur Ninox
Bonjour To find the app version, click on the gear icon in the top right of the app. If you are running the latest version you should email Ninox support to let them know.
- Fred
- 3 wk ago
- Learn and share
- Reported - view
Re: How to create a unique list of records
We should update this to take advantage of the fact that you can now use JSON in dynamic choice fields. var all := (select Table1 order by Number); for i in unique(all.…
- Fred
- 3 wk ago
- Learn and share
- Reported - view
Re: openTable issue
@spinner. 7580 said: then click the Button in Page 1 the result would be to go to Form but select the Jump tab in Form instead of the Table2 tab. So you used an openTable() command to go to a tab in…
- Fred
- 4 wk ago
- Get help
- Reported - view
Re: openTable issue
@spinner. 7580 said: openTable() is broken for me in Mac app 3.15.4 and the public cloud. I submitted a bug report re openTable() I just tried in 3.15.2 of the MacOS app and 3.15.…
- Fred
- 1 mth ago
- Get help
- Reported - view
Re: openTable issue
@spinner. 7580 Are you talking about openTable() or openRecord(). They both work for me. I just tried openPage() and that didn't take me to the specified tab (public cloud 3.15.4).
- Fred
- 1 mth ago
- Get help
- Reported - view
Re: How to filter fields from a linked table
Are you talking about the reference field from Contact to Project where in Project it shows up as a table? Or are you talking about a view element that you added in Project?
- Fred
- 1 mth ago
- Get help
- Reported - view
Re: openTable issue
@spinner. 7580The Destination form will never switch. It should open a record from the all view then switch to the Destination tab.
- Fred
- 1 mth ago
- Get help
- Reported - view
Re: openTable issue
@spinner. 7580 Try moving the "all" table view to be the first view in the "Destination table" table. The Destination view in the same table is a form view and thus does not seem to allow Ninox to…
- Fred
- 1 mth ago
- Get help
- Reported - view
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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth ago
- Get help
- Reported - view

1 2 3 4 5 141

Welcome to the Ninox community

Fred

My Posts

Re: Problème de plantage sur Ninox

Re: How to create a unique list of records

Re: openTable issue

Re: openTable issue

Re: openTable issue

Re: How to filter fields from a linked table

Re: openTable issue

Re: openTable issue

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

Overview