Fred's Profile | Ninox Community

Badges

Latest Posts

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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs ago
- Get help
- Reported - view
Re: A question about Choice and Multiple choice
@Rafael The DB is setup to only have 1 company per staff. Did you create a new dynamic multichoice field? or did you add another reference field to company?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: A question about Choice and Multiple choice
@Rafael what is your code?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: A question about Choice and Multiple choice
To unselect a dynamic field you can do: dynamicfield := 0 For the other question you have to use a button. See the attached DB.
Attachment
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Multi selection/paste in Code Editor

Just came across this nifty feature of the code editor. You can place multiple flashing cursors by holding down the Ctrl key and clicking in different areas of the code, see video.…
- Fred
- 2 yrs ago
- 48
- 3
- Learn and share
Re: Questions sur le choix multiple (dynamique)
Remember when working with multiple choice fields, as you start selecting more than 1 choice you get an array as a result. Which means you can't use the = anymore because that is telling Ninox to…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Dynamic Printing Table layout

Hi all - So I'm trying to format a table in dynamic printing where every other line is a different color. I thought you could just format the second line in a different color, but it doesn't show up.…
- Fred
- 2 yrs ago
- 9replies
- 362
- Get help
- Answered
- Answered
Re: the issue of extracting data from parent and child tables.
@441349382 said: I don't know the principle behind it, but it works now. Yes, I forgot that a Yes/No field actually has 3 states (undefined, true, false).…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Questions sur le choix multiple (dynamique)
Here is a sample. Scroll down on the Dashboard till you see MC1. As you make a choice in MC1, MC3 will update with records that have a relationship in the field Multichoice to the selection in MC1.
Attachment
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: the issue of extracting data from parent and child tables.
I created a "Not showing" button in the "Repeat code" and "Random code" tables. I want it to be able to distinguish between several display conditions.…
Attachment
- Fred
- 2 yrs ago
- Get help
- Reported - view

1 67 68 69 70 71 154

Welcome to the Ninox community

Fred

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

Re: Dynamic Printing Table layout

Re: Dynamic Printing Table layout

Re: Thoughts on a DB redesign

Re: Dynamic Printing Table layout

Re: A question about Choice and Multiple choice

Re: A question about Choice and Multiple choice

Re: A question about Choice and Multiple choice

Re: A question about Choice and Multiple choice

Re: A question about Choice and Multiple choice

Re: A question about Choice and Multiple choice

Re: Questions sur le choix multiple (dynamique)

Dynamic Printing Table layout

Re: the issue of extracting data from parent and child tables.

Re: Questions sur le choix multiple (dynamique)

Re: the issue of extracting data from parent and child tables.

Overview