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
3614
570
5
Joined: Thu Feb 06 18:42:57 UTC 2020
Follow
My Posts
Latest Posts
Re: All I want for Christmas!
You are correct. I didn't quite process your post. I guess it got me thinking about views and their limitations.
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: All I want for Christmas!
The ability to change the form you go to when clicking on a record in a view element.
Fred
Fred
3 yrs ago
1
Get help
Reported - view
Re: Understanding file attachment strategies
Just being nit-picky, but Ninox does not use a "foreign key" relationship in the sense of other DBs. You don't pick the field to use as a key. Ninox does it for you when you set the relationship.…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Understanding file attachment strategies
I'm wondering why you would have a table that is a child to two different tables. Ninox will allow you to set Composition to Yes on two different reference fields, so that was interesting.…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Delete multiple records?
If you need to repeatedly delete the contents of a table then you can put this in a button: delete (select TableName) Of course I would be very careful with this.…
Fred
Fred
3 yrs ago
2
Get help
Reported - view
Re: Delete multiple records?
If you ctrl+click the line numbers in a table view you can select all. Then do it again and select Delete selected rows. You can do this after you filter or if you want to clear your table then make…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Delete multiple records?
Through a script?
Fred
Fred
3 yrs ago
1
Get help
Reported - view
Re: Content Refresh on Dynamic Multiple Select
@Gianluca Open Table1. you will see in the table view that the formula field equals 10 for all records. It is a simple formula: sum((select Table1).Num1) now go into record 1 and change the num1…
Attachment
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Content Refresh on Dynamic Multiple Select
I've reported a bug to Ninox where the table view doesn't update properly when using the MacOS app. Are you using the app as well? If so then I wonder if this would fall under whatever issue they…
Fred
Fred
3 yrs ago
1
Get help
Reported - view
Re: Set auto completion on Ninox editor
@Jacques TUR you are the best!
Fred
Fred
3 yrs ago
Learn and share
Reported - view
Re: Set auto completion on Ninox editor
@Peter Romão Have you tried exiting the DB then going back in to the table with Jacques' formula?
Fred
Fred
3 yrs ago
Learn and share
Reported - view
Re: Set auto completion on Ninox editor
@Jacques TUR oops, you are correct. I missed that part.
Fred
Fred
3 yrs ago
Learn and share
Reported - view
Re: All I want for Christmas!
Make printing more integral into the App so we can just print from the DB without having to create a whole new layout or tables. or To be able to use view elements in Printing that way we can get a…
Fred
Fred
3 yrs ago
1
Get help
Reported - view
Re: Set auto completion on Ninox editor
@Jacques TUR Thanks for supporting the code you have created. I've noticed that the first time I view a record with the html code to get your extensions it shows the picture above.…
Fred
Fred
3 yrs ago
Learn and share
Reported - view
Re: The CRM Ninox Hero Webinar with Employees, Deals, and Companies
Creating a reference field for each possible employee is one way of doing it. But not very elegant. In the end it sounds like you have a N:N relationship between Employees and Tasks.…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: How to select a row from a composition table to display in a superform
I too use the Mac App. Ninox does a good job at keeping the versions in sync, so there is not any functional difference between them. I was going to write something else,…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: How to select a row from a composition table to display in a superform
When you created your choice field choices you will see that they have a number next to each choice. By default Ninox uses that number to reference choices.…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Dimensioni campo formula
If you are getting no response you can always email Ninox at support@ninox.com Google Translate: Se non ricevi risposta, puoi sempre inviare un'e-mail a Ninox all'indirizzo support@ninox.com
Fred
Fred
3 yrs ago
Get help
Reported - view
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
3 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
3 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
3 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
3 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
3 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
3 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
3 yrs ago
Get help
Reported - view
1
118
119
120
121
122
145
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
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?