Skip to main content
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
Setup
Databases
Automation
My account
Administration
Webinars
Overview
Profile
Fred
Fred
San Francisco, USA
3381
533
4
Joined: Thu Feb 06 18:42:57 UTC 2020
Follow
My Posts
Latest Posts
Re: Calender language changed with newest update
Check out this post. Looks like you need to email support to let them know.
Fred
Fred
8 mths 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
8 mths 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
8 mths 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
8 mths 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
8 mths 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
8 mths 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
8 mths 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
8 mths 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
8 mths 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
8 mths ago
Get help
Reported - view
Re: Birding database
Can you post a sample DB?
Fred
Fred
8 mths 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
8 mths 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
9 mths 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
9 mths 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
9 mths 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
9 mths 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
9 mths ago
Get help
Reported - view
Re: Some idea please
can you post a sample DB?
Fred
Fred
9 mths 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
9 mths 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
9 mths ago
1
Get help
Reported - view
Re: Duplicate record has stopped working
@Mel Charles Just wondering why you choose duplicate() over create()? If you did create() then you wouldn't have to null out fields you can just set the fields you need.
Fred
Fred
9 mths ago
Get help
Reported - view
Re: createXLSX: format column as currency
If you have time, next Thursday, Nioxus will hold their weekly Zoom seminar and will be going in-depth with createXLSX(). You can sign up with this link.
Fred
Fred
9 mths ago
Learn and share
Reported - view
Re: Range Date between two dates 'Plan' and null the other date 'Real'
You don't want an 'or'. It should be an 'and'. Plus you are missing a second 'Plan 1' after the or. You use the variable myTo, but you don't define it any where.…
Fred
Fred
9 mths ago
1
Get help
Reported - view
Re: View of contacts with large number of rows
I found that formulas can slow down display time. Another way is to use a Dashboard to interact with your data. You are probably filtering your table, so why not setup a Dashboard where you are…
Fred
Fred
9 mths ago
1
Get help
Reported - view
Re: createXLSX: format column as currency
@Puff playing around, I can get the .00 at the end of my numbers and that transfers to the the XLSX sheet: but I can't seem to figure out formulas yet.
Fred
Fred
9 mths ago
Learn and share
Reported - view
1
27
28
29
30
31
136
Ninox-Website
Overview
Learn and share
Get help
Service status
Documentation
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
Scripting
Functions
API
My account
Subscriptions
Administration
Manage workspaces
Manage collaborators
Access permissions
Usage overview
Process monitor
View all topics
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.…