Fred

San Francisco, USA

3608
568
5

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

My Posts

Latest Posts

Re: Retrieving values in Dynamic Choice field
So it looks like color() doesn't like dynamic fields. What you can do is create two new formula fields (recColor and recIcon) in the root table of the dynamic field.…
- Fred
- 2 mths ago
- Get help
- Reported - view
Re: Array switches from rid to nid
@Jacques TURthanks, after playing around I found the solution: let allRGRecs := record(Leagues,leagueRecID).RiderGroups; let finalRGsbyTeam := allRGRecs[false].…
- Fred
- 2 mths ago
- Get help
- Reported - view
Array switches from rid to nid

I have the following piece of code: let allRGRecs := record(Leagues,leagueRecID).RiderGroups; let finalRGsbyTeam := allRGRecs[false]; let getRidersByTeam := RidersAnnounced[TeamID = 119].…
- Fred
- 2 mths ago
- 3replies
- 58
- Get help
- Answered
- Answered
Re: use of for fonction
@frsalabert if you are satisfied with John's help, please mark the post answered. thanks.
- Fred
- 2 mths ago
- Get help
- Reported - view
Re: Pricing
The mac app is free to use wit either local or iCloud sync.
- Fred
- 2 mths ago
- 1
- Get help
- Reported - view
Re: Print Image
Also check out this post about using base64 links. Also check out Carbone's docs about pictures.
- Fred
- 2 mths ago
- Get help
- Reported - view
Re: Formula values not appearing correctly in table view
If it works for you please mark the post "answered" when you get a chance. :)
- Fred
- 2 mths ago
- 1
- Get help
- Reported - view
Re: Problème de plantage sur Ninox
@Hubert Follic I don't use the iPhone app much, but I haven't experienced any crashing the few times I have used it. Email tech support at support@ninox.com
- Fred
- 2 mths ago
- Learn and share
- Reported - view
Re: Formula values not appearing correctly in table view
@Leah I did the same thing in the beginning as well. It is all part of the learning curve. I did a post about how my data model has changed through the years.…
- Fred
- 2 mths ago
- Get help
- Reported - view
Re: Formula values not appearing correctly in table view
Try changing Donations to: let x := Splits['Class (Revenue)' = 6]; sum(x.Amount) Try to use reference links whenever possible because it is easier for Ninox to just go through the linked records then…
- Fred
- 2 mths ago
- Get help
- Reported - view
Re: Formula values not appearing correctly in table view
can you post a sample DB with no personal info?
- Fred
- 2 mths ago
- Get help
- Reported - view
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
- 2 mths 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
- 2 mths 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
- 3 mths 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
- 3 mths 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
- 3 mths 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
- 3 mths 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
- 3 mths 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
- 3 mths 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
- 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

1 3 4 5 6 7 145

Welcome to the Ninox community

Fred

My Posts

Re: Retrieving values in Dynamic Choice field

Re: Array switches from rid to nid

Array switches from rid to nid

Re: use of for fonction

Re: Pricing

Re: Print Image

Re: Formula values not appearing correctly in table view

Re: Problème de plantage sur Ninox

Re: Formula values not appearing correctly in table view

Re: Formula values not appearing correctly in table view

Re: Formula values not appearing correctly in table view

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

Overview