Skip to main content
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
Setup
Databases
Automation
My account
Administration
Webinars
Overview
Profile
Fred
Fred
San Francisco, USA
3421
540
4
Joined: Thu Feb 06 18:42:57 UTC 2020
Follow
My Posts
Latest Posts
Re: The CRM Ninox Hero Webinar with Employees, Deals, and Companies
You know what I don't use the Link to or Link from buttons in admin mode. But yes it is. My process is to Edit Fields then select the table from Create table reference.…
Fred
Fred
2 yrs ago
1
Get help
Reported - view
Re: How to select a row from a composition table to display in a superform
Hi Rob - When you created the reference field in Events to People, Ninox should have created a similar view field in People to Events. Do you not see the field in People?…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: The CRM Ninox Hero Webinar with Employees, Deals, and Companies
You can create a second reference field to Employees. The magic of Ninox is you can create multiple reference fields to the same table and Ninox will keep track of the links and not freak out.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: How to update a field with a lookup value from another table?
Now that you learned the trigger method with Steven, another way of doing this would be to make emp_fk a formula field and put this in the formula: Employee.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: How to create a 1:M display?
I thought you would be creating the links. You have to create the link manually at sometime. I guess I should have realized you already have employee data in your task table.…
Fred
Fred
2 yrs ago
2
Get help
Answer
Reported - view
Re: Creating an address block from different fields
@Michael The "magical" this command gathers all the data from the current record. You can see in line 3 all the fields start with "t.". This tells Ninox where the data for the array is coming from.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: How to create a 1:M display?
"Trust the force, Luke"
Let Ninox handle the relationship for you. You don't need to set any constraints or do any extra work. Did you try creating the reference field in Tasks not in Employees?
Fred
Fred
2 yrs ago
Get help
Reported - view
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
Fred
2 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
Fred
2 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
Fred
2 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
Fred
2 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
Fred
2 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
Fred
2 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
Fred
2 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
2 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
2 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
2 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
2 yrs ago
Get help
Reported - view
Re: Searching not working as expected (new to Ninox)
You can try: ="Complete"
Fred
Fred
2 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
2 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
2 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
2 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
2 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
2 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
2 yrs ago
Get help
Reported - view
1
111
112
113
114
115
137
Ninox-Website
Overview
Learn and share
Get help
Service status
Documentation
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
Scripting
Functions
API
My account
Subscriptions
Administration
Manage workspaces
Manage collaborators
Access permissions
Usage overview
Process monitor
View all topics
Let Ninox handle the relationship for you. You don't need to set any constraints or do any extra work. Did you try creating the reference field in Tasks not in Employees?
You have to create new formula fields. One would count Quote Ref and another would count Order Ref.…