Fred

San Francisco, USA

3614
570
5

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

My Posts

Latest Posts

Re: How to create a 1:M display?
In Ninox there is no "foreign key" that used to link tables. Meaning there is no specific field that you select to link records. Ninox does that for you.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Delete record if fieldA := fieldB
@Gianluca can you create a sample DB so i can try it out?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Table Reference Confusion
That is how a popup works. At first there is no link, then you click on the field and it shows you all the records from the other table, so you can create the link.…
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Fix 0 Value on Line Curve Graph
I get it now. You want the chart to NOT plot the null values in % Acumulada Real. Well that is beyond me. Hopefully someone with more chart experience can help. Sorry.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Table Reference Confusion
When you select Embedded then the Show As is not used as it now shows the default form from the employee table. If you change it to Popup then Show As works.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Fix 0 Value on Line Curve Graph
The troubleshooting is the same. You need to go to the source of the chart and check the raw data. If % Acumulado Real a number field then check the table that the chart is using.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Searching not working as expected (new to Ninox)
@Mike Oh, we are talking about different things. Sorry, I was talking about filtering your columns. @Mike said: I have a column with a Status. It has values like Complete, Partially Complete, etc.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Fix 0 Value on Line Curve Graph
Why is %Accumulado Real = 0 after 1 Apr 2022? You need to check your data to find out why? %Accumulad Real is a formula field. Trace the data that field uses to see where the problem is.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Table Reference Confusion
In your reference field did you set the Show as to show only the fields you want to see? You have think of the Show as section as a formula field so if you want to show multiple fields you have…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Searching not working as expected (new to Ninox)
@Mike Just to be clear. If the field a choice field then you would select the option like the picture Lars posts. But if it is a text field then my suggestion does work.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Ninox Not Syncing with iCloud
If you have done the following already: 1) use the same iCloud account on the Mac and iPhone 2) turned on iCloud drive on your Mac 3) saved the DB into iCloud Then you should email support@ninox.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Searching not working as expected (new to Ninox)
You can try: ="Complete"
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Populate a Related field
When you say "selection field" do you mean a choice/multi field? or dynamic choice/multi field? Or a reference field?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Basic Beginners Help Please! How do you use info in column count as a table field?
I'm guessing you are using the select statement. If so then you would take the select statement and put in the name of the table you are in.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: database wide variables
Another option would be to use dashboards to access your data. Please take a look at the attached sample DB. It is only setup like your example of two grades.…
Attachment
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Basic Beginners Help Please! How do you use info in column count as a table field?
Hi Paula - Sadly you can use the numbers you see at the bottom of columns in Table view. You have to create new formula fields. One would count Quote Ref and another would count Order Ref.…
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Populate a Related field
Hi Rodrigo Can you post your code so we can see what you are doing?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Formula Problem.
Since we are working in a formula field then we just needed to say what happens when 'horas ganada real' equal 0. So we just needed to put 0 after the THEN.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Formula Problem.
Right, so you would change it to: let t := this; if 'Horas Ganada Real' = 0 then 0 else sum((select 'Horas-Actuales')[Semana <= t.Semana].'Horas Actuales') end
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Design Table for WBS
Hi Rafael - You are not wasting my time. Try this in Level 3: a.'Level-2' = b.mainCategory And this in Level 4: a.'Level-3' = b.'Level-3' Like I said earlier, you have too many "a"s and "b"s.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Formula Problem.
One way is: let t := this; if 'Horas Ganada Real' = 0 then 'Horas Actuales' := 0 else sum((select 'Horas-Actuales')[Semana <= t.Semana].'Horas Actuales') end
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Design Table for WBS
What are the formulas you are using?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: if, then not working within a function field script.
One solution is to check for null instead of length of text. You can try something like: if 'Business Process 1' != null then (select 'Business Process Defs' where Id = theIDb).…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How to use Date, Start time and time interval Field
@Admin said: My solution was the following: let dS := Date + 'Finish Time'; let dF := Date + 'Start Time'; 'Massage Booking' := appointment(dS, dF) For some reason dS was putting the time as the…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Auto-populate a predetermined Number in a field depending on a choice made in a combo-box
You need a 3rd table to track the choices selected from the different multiple choice fields. Can you let us know what your DB structure looks like, i.e.…
- Fred
- 3 yrs ago
- Get help
- Reported - view

1 119 120 121 122 123 145

Welcome to the Ninox community

Fred

My Posts

Re: How to create a 1:M display?

Re: Delete record if fieldA := fieldB

Re: Table Reference Confusion

Re: Fix 0 Value on Line Curve Graph

Re: Table Reference Confusion

Re: Fix 0 Value on Line Curve Graph

Re: Searching not working as expected (new to Ninox)

Re: Fix 0 Value on Line Curve Graph

Re: Table Reference Confusion

Re: Searching not working as expected (new to Ninox)

Re: Ninox Not Syncing with iCloud

Re: Searching not working as expected (new to Ninox)

Re: Populate a Related field

Re: Basic Beginners Help Please! How do you use info in column count as a table field?

Re: database wide variables

Re: Basic Beginners Help Please! How do you use info in column count as a table field?

Re: Populate a Related field

Re: Formula Problem.

Re: Formula Problem.

Re: Design Table for WBS

Re: Formula Problem.

Re: Design Table for WBS

Re: if, then not working within a function field script.

Re: How to use Date, Start time and time interval Field

Re: Auto-populate a predetermined Number in a field depending on a choice made in a combo-box

Overview