Fred

San Francisco, USA

3683
590
5

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

My Posts

Latest Posts

Re: Link tables during import CSV
@Leo Woer can you provide a sample DB? What part is not working?
- Fred
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 mths ago
- Get help
- Reported - view
Re: Issue with Embedding JSON and Forcing PDF
@Alain how about your template?
- Fred
- 5 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
- 5 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
- 5 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
- 5 mths 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
- 5 mths 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
- 5 mths ago
- 1
- Get help
- Reported - view
Re: Only bulk edits?
@Cliff Veal When I tap the gear icon I see all available options.
- Fred
- 5 mths 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
- 5 mths 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
- 5 mths 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
- 5 mths ago
- Get help
- Reported - view

1 7 8 9 10 11 148

Welcome to the Ninox community

Fred

My Posts

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

Re: Dynamic Print Layout Colour

Re: Issue with Embedding JSON and Forcing PDF

Re: Only bulk edits?

Re: Only bulk edits?

Re: Trigger on Open....

Re: How do you distribute changes to a database to other users

Overview