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
3615
570
5
Joined: Thu Feb 06 18:42:57 UTC 2020
Follow
My Posts
Latest Posts
Re: Questions about writing
I'm not sure what you mean by "their order is in a messy". Is everything else correct just how they show up in the table? Can you sort the table into a view that works for you?
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Thoughts on a DB redesign
@Rafael I don’t have any Pages, just dashboards.
Fred
Fred
1 yr ago
Learn and share
Reported - view
Re: How many members can I invite? Is there a limit?
@我是我的我 said: Do invitees also have to subscribe? Yes, anyone who you want access to your DBs will have to have a subscription to ninox. It can be at any level.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: format in time
@fastmey. be said: Sorry, it's a time interval field If I'm not mistaken there is no field that is called time interval. I'm not sure how the timeinterval() command would work here.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Button to apply filter to sub-table
@IDAO SARL said: I've many buttons for each quarter of a year and would like display only the technical interventions for the 1st, 2nd, 3th ou 4th quater by clicking them.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Button to apply filter to sub-table
You can do a select. You call INTERVENTIONS a subtable of CONTRAT I will assume they are linked in a N:1 relationship, many interventions to 1 contrat. If that is true then you can use the…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: How many members can I invite? Is there a limit?
Each member has to have a subscription, so the limit is your budget.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Formula/Script behaves differently when in Full Screen View
To be clear, if you go full screen using the brower fullscreen (either button or menu) then it shows. If you use the openFullscreen() command then it disappears.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Thoughts on a DB redesign
Here is an example of how to use relationships to fill in dynamic fields or views: Step 1: League is a dynamic choice field to the table Leagues. Step 2:…
Fred
Fred
1 yr ago
1
Learn and share
Reported - view
Re: Thoughts on a DB redesign
@Sotirios Zormpas Thanks. You should always try to use relationship to get to the data you need instead of doing a select then filtering for the same records.…
Fred
Fred
1 yr ago
Learn and share
Reported - view
Re: Thoughts on a DB redesign
@Rafael Thanks. I also haven't done anything real with Pages yet.
Fred
Fred
1 yr ago
Learn and share
Reported - view
Re: Thoughts on a DB redesign
@Mel Charles Another example of removing selects is in dynamic fields. In my dashboards I started by creating dynamic choice fields to Leagues with: select Leagues Which works.…
Fred
Fred
1 yr ago
Learn and share
Reported - view
Re: Thoughts on a DB redesign
@John Halls said: Looks like a big part of your success is down to recognising and setting Composition correctly. You have some nested three (or four?) deep. That is correct.…
Fred
Fred
1 yr ago
1
Learn and share
Reported - view
Re: Thoughts on a DB redesign
@Mel Charles You can use any reference link as long as you end on a table? For example in my Team Dashboard I already have a reference field to the Team table from where I select a team to view on my…
Fred
Fred
1 yr ago
Learn and share
Reported - view
Re: format in time
What kind of field is duration? @fastmey. be said: Now I want to create a dashboard. Select Titles. I get the genres in the chart but it does not add up the duration. What chart are you talking about?
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Thoughts on a DB redesign
I think I'm done for now. I've removed unnecessary table links and cleaned up my dashboards so I'm using links instead of selects and everything is running smoothly.…
Fred
Fred
1 yr ago
Learn and share
Reported - view
Re: Help setting up please
First thing that comes to mind is that you will probably need a third table to track classes and clients. You said you have a client and group(class) table. That makes sense.…
Fred
Fred
1 yr ago
1
Get help
Reported - view
Re: add a conditional constraint
@我是我的我 said: Can 1:N implement the conditional constraint As you see there is no contraints part of a reference table. It is already constrained to only show linked records.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Dynamic Printing Table layout
@RoSoft_Steven Thanks for the heads up. I downloaded their template and looked at it. It does look like a simple formatting, but when I try it. I get. Looking more at the formatting they have some…
Attachment
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Dynamic Printing Table layout
@Eichelfr Sorry, I deleted the post cause I was wrong. My code was broken due to some other changes in my DB. I've fixed the code and now I get this PDF with your Template.
Attachment
Fred
Fred
1 yr ago
1
Get help
Reported - view
Re: Thoughts on a DB redesign
Here is an update on my data model redesign. I couldn't have done it without Ninext as I can find all of the links I was going to break and point them to the new path as I moved things around.…
Fred
Fred
1 yr ago
Learn and share
Reported - view
Re: Dynamic Printing Table layout
I'm trying it with the repetition function: Even though the second row is colored it doesn't print. Which I guess that makes sense it Carbone just takes the first row and duplicates it with new data.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: A question about Choice and Multiple choice
@Rafael Take a look at the code for the newDMC field. You also have to have a multiple choice field in staff.
Attachment
Fred
Fred
1 yr ago
1
Get help
Reported - view
Re: A question about Choice and Multiple choice
@Rafael You are correct. Using text() caused an incorrect valuation. Marketing is 1 and R&D is 10, so 1 is in 10 so anyone in Marketing shows up in R&D.…
Fred
Fred
1 yr ago
2
Get help
Reported - view
Re: A question about Choice and Multiple choice
@Rafael The code for the Staff field in Check looks for any records in Staff that have 1 of the choices selected in company. Audrey is related to Marketing only.…
Fred
Fred
1 yr ago
Get help
Reported - view
1
58
59
60
61
62
145
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
Usage overview
Process monitor
View all topics
