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
3527
551
4
Joined: Thu Feb 06 18:42:57 UTC 2020
Follow
My Posts
Latest Posts
Re: Pass current viewing record Id to a view element column formula
Now that this post has been revived, I can share what I have figured out in the mean time. As some of you know I have a sports DB. Which means there are lots of stats that need to be generated.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: add onselect event for view field
@Maurice Ninext is shutting down. Please see this post.
Fred
Fred
2 yrs ago
1
Learn and share
Reported - view
Re: Ninext : Important information
I'm very sadden to hear that Ninext is disappearing. You have taken this community to the next level with your work and have inspired others to do the same, i.e. Dark Mode.…
Fred
Fred
2 yrs ago
2
Get help
Reported - view
Re: Creating a new record in a linked table using code
@spinner. 7580 said: Line 5 didn't work but all is not lost. Question: in what table does this button exist? I assumed it was in the Routes table, but since it doesn't work I guess not.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Mileage Chart Spreadsheet to Ninox Table
@Chris Thomasson said: At this time, I don’t need to use the mileage chart to plan a route or track trips; I need the mileage chart to look up paid miles.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Sort view by initial exam
Can you give us a bit more info about your db structure?
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Ninext : Important information
what is going on? is this something that Ninox is doing?
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Unable to populate related table in Choice (dynamic) field
@Richard v. L. said: It works fine but I feel there must be a more elegante way to get around this extra step. Personally, I think the Dashboard is a more elegant way of accessing your data.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Unable to populate related table in Choice (dynamic) field
@Richard v. L. said: I've done the same as well but not used a Dashboard (I want to keep the original dB-structure) but I can't connect the dots. In tblTerms I've created a "first" ref to tblSpeeches…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Unable to populate related table in Choice (dynamic) field
@Richard v. L. said: It appears at first glance that your "dashboard" is simply another table connected to the original structure that auto-populates on opening? It doesn't auto populate.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Sort Table by Surname in another table / show Titles as text
@Richard v. L. said: Now I have a column in my "connected" table called FullName but I don't want the records sorted by the first name or Title but by the Surname (from tblPeople that is not a field…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: More Vieweirdness
@UKenGB said: The 'fullDesc' field is a concatenation of several Dynamic MultiChoice fields, each using text() in order to add some additional text. Can you post the code for fullDesc?
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Filtering contacts from a specific client
@Mel Charles said: however what do you think the limitation would be if i scaled this up to say over 2000 companies with between 1 and 4 contacts per customer- do you reckon there would be some…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Filtering contacts from a specific client
Mel shows a good use of the dynamic choice field. If you want to stick with your example, take a look at my sample. Just select the Quote table. The other tables are from another test.…
Attachment
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Embedding a multiple choice dynamic field
@Holly M what is the error message? You did change to the appropriate table name?
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Embedding a multiple choice dynamic field
The one issue I see with using a dMC in your dashboard is that it will make people think they can change the root data by changing the dMC. When that is not the case.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Embedding a multiple choice dynamic field
Just to be clear, you want to create a field in the Dashboard that shows the value of a dMC in Projects? How do you want to show the values of the dMC from Projects? In a formula field? In a dMC?…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Embedding a multiple choice dynamic field
Let me see if I understand the post. You want to create a dynamic multi choice (dMC) field in a form that is in another table, but you want that dMC to be influenced by the data in the dashboard?…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Creating a new record in a linked table using code
@spinner. 7580 said: When creating a new record in ‘Ride Log’ I need to do 2 things with that number: Set field ‘Route ID’ in ‘Ride Log’ to ‘Route ID Match’ Set the link reference field Route_ID in…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Filtering contacts from a specific client
You are trying to constrain ATTN, so you need to use another field, which in the Quotes table would be the field called Customer. I’m guessing Customer is a reference field to Company,…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Leave formula field empty if .....
@Bernd Krell said: If Qty is more then one, then 'Total Sales Price' is empty and so is TOTAL field. That is weird. I was able to duplicate it. You can try the other way Fabio recommended:…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Unable to populate related table in Choice (dynamic) field
Ok take a look at this attempt. I've used a "dashboard" to interact with your data. It will open to a new table "Dash1". From there you select the Conference,…
Attachment
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: More Vieweirdness
Alan brings up a good point. Can you share a formula that you have issues with?
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Linking tables after importing from database
can you give us a bit more information? what are the table names? what are the reference field names in the tables?
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Filtering contacts from a specific client
Constraints are not very obvious. Since you didn’t tell us what your fields are I’ll use the example from this original 3 year old post. When you open the constraint window on the left hand side you…
Fred
Fred
2 yrs ago
Get help
Reported - view
1
82
83
84
85
86
142
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
