Fred

San Francisco, USA

3747
594
5

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

My Posts

Latest Posts

Re: Button script to select/link record on child table
@bflack said: The only step remaining: I could use some help with a button to select all from the dynamic multi choice fields (by sub-group) - and also clear selections.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Questions about writing
@我是我的我 said: When I get ''Detailed.code'', since it's a whole group of data, all I can think of is to split it with the "split()" command and put it in the into "inventory.code".…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: v3.10.7
v3.10.8 and I still have issues. I hope others are having a better time.
- Fred
- 1 yr ago
- Learn and share
- Reported - view
v3.10.7

Just noticed that a new version is up. I noticed because now I can't use my main DB. All hell has broken loose. Interestingly I can use the MacOS app, just not the browser.…
- Fred
- 1 yr ago
- 3replies
- 105
- Learn and share
Re: Button script to select/link record on child table
Take a look at this sample. Also, Ninox did away with the 100 choice limits for dynamic fields. I did a test of one with over 5,000 and it works fine. Just because we can do it doesn't make it…
Attachment
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Button script to select/link record on child table
@bflack said: Three steps for each item becomes laborious when dealing with a 100+ Invoice Items. Any help is appreciated! Wow, those are really long invoices.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Questions about writing
@我是我的我 said: My issue is that the code written to inventory has changed from the code in Detailed. Question: Why did you make the decision not to make a reference field in the inventory table to…
- Fred
- 1 yr ago
- Get help
- Reported - view
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
- 1 yr ago
- Get help
- Reported - view
Re: Thoughts on a DB redesign
@Rafael I don’t have any Pages, just dashboards.
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 1 yr ago
- Get help
- Reported - view

1 63 64 65 66 67 150

Welcome to the Ninox community

Fred

My Posts

Re: Button script to select/link record on child table

Re: Questions about writing

Re: v3.10.7

Re: Button script to select/link record on child table

Re: Button script to select/link record on child table

Re: Questions about writing

Re: Questions about writing

Re: Thoughts on a DB redesign

Re: How many members can I invite? Is there a limit?

Re: format in time

Re: Button to apply filter to sub-table

Re: Button to apply filter to sub-table

Re: How many members can I invite? Is there a limit?

Re: Formula/Script behaves differently when in Full Screen View

Re: Thoughts on a DB redesign

Re: Thoughts on a DB redesign

Re: Thoughts on a DB redesign

Re: Thoughts on a DB redesign

Re: Thoughts on a DB redesign

Re: Thoughts on a DB redesign

Re: format in time

Re: Thoughts on a DB redesign

Re: Help setting up please

Re: add a conditional constraint

Overview