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
Follow
Joined
Thu Feb 06 18:42:57 UTC 2020
3808
posts
606
likes received
5
followers
Badges
Latest Posts
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
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
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
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
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
Fred
3 yrs ago
Get help
Reported - view
Re: Searching not working as expected (new to Ninox)
You can try: ="Complete"
Fred
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
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
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
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
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
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
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
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
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
Fred
3 yrs ago
Get help
Reported - view
Re: Design Table for WBS
What are the formulas you are using?
Fred
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
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
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
Fred
3 yrs ago
Get help
Reported - view
Re: Design Table for WBS
@Rafael Sanchis You had too many "a" and "b" in your code. Try deleting the contraints and just use the selection of the fields in the left side of the window.…
Fred
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
Are you part of the Ninox Webinar EN 2022 cloud team? If not then email support@ninox.com and ask to be added. Then look at Cascading DC Fields DB for some great work by @RoSoft_Steven Rooryck .…
Fred
Fred
3 yrs ago
1
Get help
Reported - view
Re: How to use Date, Start time and time interval Field
Take a look at this post for a possible solution: https://forum.ninox.com/t/x2hbm58
Fred
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
Hi Steve So you have a multi-choice field with 3 choices. Make another formula field and put this in the formula: number(multichoicefieldname) As you make your choice you will see different numbers…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Design Table for WBS
Now that I've had a chance to play around more, I've modified: Avances Disciplinas Documentos FechaCorte Take a look to see what you can do when you have a horasconsumidas table tracking horas.…
Attachment
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Design Table for WBS
@Rafael Sanchis said: Horas Ganadas Real are the Earned value it reflects the amount of hours that has actually been accomplished to data date. I read this as Horas Ganadas Real should be a formula…
Attachment
Fred
Fred
3 yrs ago
Get help
Reported - view
1
127
128
129
130
131
153
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
Backups and storage
Process monitor
View all topics
