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
Follow
Joined
Thu Feb 06 18:42:57 UTC 2020
3811
posts
606
likes received
5
followers
Badges
Latest Posts
Re: Odd behavior / bugs with PAGES on macOS
@Nick You are correct, Nick. I forgot to test on local DB. I can confirm that Pages, does not work on local DBs.
Fred
Fred
1 yr ago
1
Get help
Reported - view
Re: Odd behavior / bugs with PAGES on macOS
tested in v3.12.2 on my Mac and had no issues with images or dynamic choice fields.
Fred
Fred
1 yr ago
1
Get help
Reported - view
Re: Display associated content with conditional constraints.
@我是我的我 said: Although these are too difficult for someone like me who doesn't understand code, It wasn't that difficult as you seem to have no problem figuring it out.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: createXLSX: format column as currency
Well, according to Andy at Nioxus the Ninox docs for createXLXS() are not completely accurate. In addition he talked about a format function that is not defined in the docs as well.…
Fred
Fred
1 yr ago
Learn and share
Reported - view
Re: Display associated content with conditional constraints.
@我是我的我 said: For example, in the 'copy table,' 'beverage' is also considered a duplicate item. How can we achieve the same effect for these as well? That was the next step in the process.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Calender language changed with newest update
Check out this post. Looks like you need to email support to let them know.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Display associated content with conditional constraints.
You wrote: let xxx := length((select copy).name); for i from 0 to xxx do if i = 0 then 1 else 0 end end Here are the steps I suggested: 1) create an array of all records that have "coffee" in a the…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Display associated content with conditional constraints.
@我是我的我 said: I would also like to write a piece of code in the copy table such that if "coffee" appears 3 times, the first occurrence of "coffee" is marked as 1, and the other two are marked as 0.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Professional help
Ninox has a partners search: https://ninox.com/en/find-partner We here in the forum are always willing to answer questions.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Birding database
@SimonS If you had the table of species then you can do a simple count() or length() of the table. Or you can modify the html code I posted earlier and add a few lines to get a count of species:…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Whether the data content of table1 field can become the field of select(table2)
shucks,@John Halls beat me to it. Let us breakdown your code: let t := this; let X := 'code name'; first((select Table2)[name = t.name].X) According to your first picture,…
Fred
Fred
1 yr ago
1
Get help
Reported - view
Re: Display associated content with conditional constraints.
@我是我的我 can you post your solution so others can learn from your wisdom?
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Birding database
to be helpful like,@Sotirios Zormpas , here is a sample html. Put the following into a formula field. let getSightings := (select 'Sightings revised 1'); let uniqueSpecies :…
Fred
Fred
1 yr ago
1
Get help
Reported - view
Re: Birding database
@SimonS said: Not quite sure how to do that. I’ve attached an archived version. that will work. so you have this in your view element: select 'Sightings revised 1' where unique(Species) Sadly,…
Fred
Fred
1 yr ago
1
Get help
Reported - view
Re: How to run chatgpt or Claude…
@Tomasz Winiarski that is pretty cool. According to Ninox, the MacApp can not do any API work. That is why it is free.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Birding database
Can you post a sample DB?
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Display associated content with conditional constraints.
As you can see there is no way to modify the many (N) side of a reference link. This field shows you all records linked to the current record. It is normally shown as a table,…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: ninoxApp() returns "ipad" on an iPhone...
@Eric Plet Ninox's history of their app updates is not very good and their response to fixes is pretty slow, so I made sure not to automatically update. In the cloud, I have no choice.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: ninoxApp() returns "ipad" on an iPhone...
@Eric Plet said: Mac version: 3.12.2 iPhone version: 3.12.2 It is a database published on iCloud. I tested in this environment except that my iphone is till running 3.10.11 and it returned iphone.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: ninoxApp() returns "ipad" on an iPhone...
what version of the app are you running. when i tested on my iphone, i'm running 3.10.11 and the server is 3.12.2 and it recognizes my iphone. here is the code i have in a dashboard:…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: HTML Pivot Table
So I've been racking my brain on how to make things go faster and one way I thought of is to create a table called byCountry, then link all of the Covid19 data to their respective country.…
Attachment
Fred
Fred
1 yr ago
Learn and share
Reported - view
Re: Some idea please
I was just thinking that you do a lot based on your cut off date. Why not put all of your data tables that use this as subtables to the cut off date table?…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Some idea please
can you post a sample DB?
Fred
Fred
1 yr ago
Get help
Reported - view
Re: can not open Excel file after creation?
Sadly, my computer updated my app to 3.12.2. 😥 But now I can try this out and I was able to duplicate it. It only happens on locally stored DBs. I tried it on a cloud DB and it worked fine.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: View of contacts with large number of rows
@erik I know that Nioxus offers Private cloud hosting services. They say it cost the same to go through them plus Nioxus does the hosting. I don't know anymore than that,…
Fred
Fred
1 yr ago
1
Get help
Reported - view
1
44
45
46
47
48
153
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
Backups and storage
Process monitor
View all topics
