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
3418
539
4
Joined: Thu Feb 06 18:42:57 UTC 2020
Follow
My Posts
Latest Posts
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
Re: Unable to populate related table in Choice (dynamic) field
@Richard v. L. said: Each speech is based on different language pairs and directions depending on the speaker. You see on "slides" I have a Language VO (source language) and a Language VI (target…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Unable to populate related table in Choice (dynamic) field
@Richard v. L. said: I also have one "Slide" where the fx field (ConceptNr) is populated although no concepts are clicked. This is a bug in Ninox. Check out this post for more info about this.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Unable to populate related table in Choice (dynamic) field
Since Concepte is based on 'topics n:m' table (but called 'Related SubTopics' in the Main Topics table), the formula for the view 'Trems' is: let dmcselection :…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Column Filter Date?
For the formula you can try: concat('Previous Order'['Date of Previous Order' = date(2022, 10, 17)].'Date of Previous Order') I’m guessing ‘Date of Previous Order’ is a date field.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Column Filter Date?
Can you try = “(fill in date)”
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Unable to populate related table in Choice (dynamic) field
@Richard v. L. don't know. never seen that before. yeah, try to keep it simple and small.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Unable to populate related table in Choice (dynamic) field
@Richard v. L. That is correct. You save an archive then click on the paperclip to upload the file. Don't worry about the mess. You should see mine. It has grown organically as I've learned so it is…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: can I hide a table only for one user?
@Javier Gómez Here is a sample. A user wanted something that they can make a table "read-only". You can view the post if you want. Going this route will mean a ton of work on the front end as you…
Attachment
Fred
Fred
2 yrs ago
1
Get help
Reported - view
Re: Unable to populate related table in Choice (dynamic) field
@Richard v. L. said: with all the different relations between the tables perhaps the index numbers in "Concepte" (I need to change the typo) are not the same indexes in "Sub Categories" ?…
Fred
Fred
2 yrs ago
Get help
Reported - view
1
78
79
80
81
82
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
